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.
|Column name||Column type||Column constraint||Table constraints|
|logging_session_id||UNSIGNED INT||NOT NULL|
|counter_id||UNSIGNED SMALLINT||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.