Viewing all trackable database server property values

View the list of database server property values that can be tracked.

Context

Only database server properties with numeric values can be tracked.

You can find the PropNum of the database server property by running the sa_eng_properties system procedure or by calling the PROPERTY_NUMBER function.

Procedure

Execute the following statement:

SELECT * FROM sa_eng_properties()
WHERE PROPERTY_IS_TRACKABLE( PropNum ) = 1;

Results

The list of database server properties that can be tracked is returned.