Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Returns performance statistics for the server, databases, and connections.
Returns the ID number of the database.
Returns NULL if the property type is Server.
Returns the connection ID (a number) for the current connection.
Returns NULL if the Type is Server or Database.
The sa_performance_statistics system procedure returns a result set consisting of a set of performance statistics. The results
are a subset of the results you can return using the PROPERTY, DB_PROPERTY, and CONNECTION_PROPERTY functions.
You must have the MONITOR system privilege.
The following example unloads all performance statistics to a text file named dump_stats.txt:
SELECT CURRENT TIMESTAMP, *