Troubleshooting SQL performance slowdowns

The workshop covers troubleshooting SQL performance slowdown incidents in production environments.

An SQL performance slowdown incident satisfies the following two conditions:



A problem report can come from various sources, such as the following examples:



Response time is perceived as ?too slow? when it is slower relative to expectations set by comparisons such as the following comparisons:



The cause or explanation of a problem is not immediately apparent. The problem could be caused by different things influenced by different people. For example, the problem could be caused by things in the realm of the database management system (DBMS) server under the purview of the database administrator; the problem could be caused by the application SQL and code under the purview of the application developer; the problem could be caused by other IT technical areas such as storage under the purview of IT staff, other than the database administrator.

In this workshop, a step by step approach is being used to troubleshoot any of the problems.

The steps followed in diagnosing the problem are as below ::