Version: latest

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.