Chat now with support
Chat with Support

Spotlight on SAP ASE 2.11 - Getting Started Guide

Database Analysis drilldown

The Database Analysis drilldown displays key performance statistics for all active databases and database partitions in an instance. At its top level, the drilldown provides an overview of performance during the current monitoring session. This is shown in the Databases tab.

From the Databases tab, you can drill down to detailed information on caching, sorting, locking, I/O activity, and more for a certain database or partition. This is shown in sub drilldown tabs, which are displayed in the lower half of the window when a database or partition is selected. The additional statistics can be used to diagnose any problems detected in the Databases tab.

Using the Database Analysis drilldown

The steps below outline the basic workflow involved in using the Database Analysis drilldown.

To use the Database Analysis drilldown

  1. View top level tabs to detect problems in a database. Work from the Databases tab to check statistics. Work from Criteria tab to filter the list in the Database tab based on criteria such as level of physical I/O or number of locks held.

  2. View Rows in the Databases tab in the Tablespaces tab to focus on a certain database or one of its partitions. Check columns in the Databases tab to see statistics for a database or partition.

  3. View sub drilldown tabs to see additional statistics for a certain database. Click the database row to display the tabs. The information they contain can help you diagnose problems detected in the Databases tab.

  4. Open a Toad for DB2 or session to view properties, update configuration parameters, or identify storage problems for a specific database or database partition. (You must have either product licensed and installed on the same computer where the Spotlight for DB2 client resides.)


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating