sa_diagnostic_statistics table

The sa_diagnostic_statistics table is owned by the dbo user, and contains a history of performance counters maintained in the server. Each row represents the value of a given performance counter at a given moment in time.

There are two versions of this table: sa_diagnostic_statistics, and sa_tmp_diagnostic_statistics.

Columns
Column name Column type Column constraint Table constraints
logging_session_id UNSIGNED INT NOT NULL
"time" TIMESTAMP NOT NULL
counter_id UNSIGNED SMALLINT NOT NULL
type TINYINT NOT NULL
connection_number UNSIGNED INT NOT NULL
counter_value UNSIGNED INT NOT NULL

logging_session_id   A number uniquely identifying the logging session during which the diagnostic information was gathered.

"time"   The time at which the performance counter value was captured.

counter_id   A number uniquely identifying the performance counter. You can get the name of the property that this counter_id represents using the PROPERTY_NAME function.

type   Indicates whether this is a database, server, or connection statistic. Possible values are 0 for server, 1 for database, 2 for connection, and 4 for external database.

connection_number   In the case of a connection statistic, the connection number from which this property was captured. In the case of an extended database statistic, the file number for the file from which this property was captured. Otherwise, the value is 0.

counter_value   The value of the performance counter.

See also