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	Description
logging_session_id	UNSIGNED INT	A number uniquely identifying the logging session during which the diagnostic information was gathered.
"time"	TIMESTAMP	The time at which the performance counter value was captured.
counter_id	UNSIGNED SMALLINT	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	TINYINT	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	UNSIGNED INT	For a connection statistic, the connection number from which this property was captured. For an extended database statistic, the file number for the file from which this property was captured. Otherwise, the value is 0.
counter_value	UNSIGNED INT	The value of the performance counter.

sa_diagnostic_statistics table

Columns

See also