Accessing database server property values

Database properties apply across the database server as a whole. You can use the PROPERTY system function to retrieve the value for an individual property, or you can use the sa_eng_properties system procedure to retrieve the values of all database server properties. Property names are case insensitive.

 Retrieve the value of a database server property
  • Use the PROPERTY system function. For example, the following statement returns the number of cache pages used for global server data structures:

    SELECT PROPERTY ( 'MainHeapPages' );
 Retrieve the values of all database server properties
  • Use the sa_eng_properties system procedure:

    CALL sa_eng_properties;
 See also
 Database server properties