Database SQL Statistics
Aggregates Unique SQL completion-path execution count and elapsed time by database, and computes the percentage of instance DB_TIME. Node-wide report, which can be viewed in node mode for detail or all report types. Unique SQL must be enabled.
Table 1 Columns in SQL Stats by Database
Column | Description |
|---|---|
DB Name | Database name. |
Exec Count | Execution-count delta for the database between snapshots. |
Total Time(s) | Total elapsed time in seconds. |
Avg Time(ms) | Average elapsed time in milliseconds; 0 when Exec Count is 0. |
% of DB Time | Percentage of the instance DB_TIME delta. |
Only databases with Exec Count or elapsed-time delta greater than 0 are listed, ordered by Total Time descending.