Profiling workloads v9

Most RDBMS experts agree that inefficient SQL code is the leading cause of most database performance problems. The challenge for DBAs and developers is to locate that SQL code in large and complex systems and then optimize that code for better performance.

The following extensions works with PEM to allow you to profile a server's workload:

• SQL Profiler — allows a database superuser to locate and optimize inefficient SQL code
  • See Installing the SQL Profiler extension
  • See Using SQL Profiler
• Index Advisor — works with SQL Profiler by examining collected SQL statements and making indexing recommendations for any underlying tables to improve SQL response time