You can retrieve the value of a specific database property or the values of all database properties. Database properties apply to an entire database.
The server properties QueryBypassedCosted, QueryBypassedOptimized, QueryDescribedOptimizer, and StatementPostAnnotatesSimple are updated only for queries against catalog store tables.
Use the db_property system function to retrieve the value of a database property. The following statement returns the page size of the current database:
select db_property ( 'PageSize')
Use the sa_db_properties system procedure to retrieve the values of all database properties:
call sa_db_properties