Tutorial Flow:




Determining the problem category


As part of the initial diagnosis, the database administrator looks for familiar patterns of symptoms to categorize the problem at a high level. The database administrator views the report to identify abnormal values. The database administrator focuses on key indicators that can rule-in or rule-out common, general problems.

Few metrics that indicate some general problem categories



From this evidence, the database administrator concludes that slowdown is localized in statement processing.