Profiling workloads
===================

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 :ref:`Installing the SQL Profiler extension <Installing the SQL Profiler extension>` 

-  See :ref:`Upgrading SQL Profiler <Upgrading SQL Profiler>` 

-  See :ref:`Using SQL Profiler <Using SQL Profiler>` 

-  :ref:`Using the Index Advisor <Using the Index Advisor>`  — works with SQL Profiler by examining collected SQL
   statements and making indexing recommendations for any underlying
   tables to improve SQL response time

.. toctree::
  :maxdepth: 3

  Using--profiling_workloads--installing_sql_profiler
  Using--profiling_workloads--using_sql_profiler
  Using--profiling_workloads--index_advisor