Returns the status of the accent sensitivity feature. Returns On if the database is accent sensitive, Off if it is not, or FRENCH if it is using French sensitivity rules.

Returns the database name.

Returns the alternate mirror server name associated with the database if one was specified. See -sm database option (deprecated).

Returns the alternate server name associated with the database if one was specified. See -sn database option.

Returns an estimate of the amount of CPU time accumulated by the database, in seconds. The value returned may differ from the actual value by as much as 50%, although typical variations are in the 5-10% range. On multi-processor computers, each CPU (or hyperthread or core) accumulates time, so the sum of accumulated times for all connections may be greater than the elapsed time. This property is supported on Windows and Linux.

Returns one of the following values:

See Database mirroring.

Returns the types of auditing currently enabled. See auditing option.

Returns Yes if the database has been authenticated, or No if the database has not been authenticated.

Returns Yes when a backup is occurring. Otherwise, returns No.

Returns On if the database has blank padding enabled. Otherwise, it returns Off.

Returns the number of bytes received during client/server communications. This value is updated for HTTP and HTTPS connections.

Returns the number of bytes that would have been received during client/server communications if compression was disabled. This value is the same as the value for BytesReceived if compression is disabled.

Returns the number of bytes sent during client/server communications. This value is updated for HTTP and HTTPS connections.

Returns the number of bytes that would have been sent during client/server communications if compression was disabled. This value is the same as the value for BytesSent if compression is disabled.

Returns the number of database page lookups satisfied by finding the page in the cache.

Returns the number of database pages that have been looked up in the cache.

Returns the number of index internal-node pages that have been read from the cache.

Returns the number of index leaf pages that have been read from the cache.

Returns the number of table pages that have been read from the cache.

Returns the number of cache work table reads.

Returns the capability bits enabled for the database. This property is primarily for use by Technical Support.

Returns the number of heap pages used for short-term purposes such as query optimization.

Returns the status of the case sensitivity feature. Returns On if the database is case sensitive. Otherwise, it returns Off. In case sensitive databases, data comparisons are case sensitive. This setting does not affect the case sensitivity of identifiers. Passwords are always case sensitive. See Case sensitivity.

Returns the identifier for the collation used for the catalog. This property has extensions that you can specify when querying the property value. See DB_EXTENDED_PROPERTY function [System].

Returns the CHAR character set of the database.

This property has extensions that you can specify when querying the property value. See DB_EXTENDED_PROPERTY function [System].

Returns the number of checkpoint log commits to disk.

Returns the number of checkpoint log pages in use.

Returns the number of relocated checkpoint log pages.

Returns the number of checkpoint log pages that have been written.

Returns the number of preimages of database pages that are being added to the checkpoint log.

Returns the size of the checkpoint log, in pages.

Returns the number of writes to the checkpoint log.

Returns the time that has elapsed since the last checkpoint, as a percentage of the checkpoint time setting of the database.

Returns On if global checksums are enabled for the database (a checksum is created for each database page). Otherwise, returns Off. Checksums are always present for critical pages.

Returns the number of checkpoints that have been performed.

Returns the number of ranges of adjacent pages written out during a checkpoint.

Returns the number of transaction log checkpoints.

Returns the number of pages marked to be cleaned since database server startup.

Returns the number of database pages cleaned since database server startup.

Returns the number of rows marked to be deleted since database server startup.

Returns the number of shadow table rows deleted since database server startup.

Returns the number of prepares that were not required for this database because of the client statement cache. This is the number of additional prepares that would be required if client statement caching was disabled. See max_client_statements_cached option.

Returns the number of statements in the client statement cache for this database that were prepared again. This is the number of times a cached statement was considered for reuse, but could not be reused because of a schema change, a database option setting, or a DROP VARIABLE statement. See max_client_statements_cached option.

Returns the collation used by the database. For a list of available collations, see Alternate collations.

This property has extensions that you can specify when querying the property value. See DB_EXTENDED_PROPERTY function [System].

Returns the number of times the server has forced a flush of the disk cache. On Windows, the disk cache doesn't need to be flushed if unbuffered (direct) I/O is used.

Returns the number of times the server has forced a flush of the disk cache. On Windows, the disk cache doesn't need to be flushed if unbuffered (direct) I/O is used.

Returns the number of connections to the database. The property value does not include connections used for internal operations, but it does include connections used for events and external environment support.

To obtain an accurate count of the number of licensed connections in use, execute the following statement:

SELECT COUNT( * ) FROM sa_conn_info( ) WHERE number < 100000000;

Returns the total length of time, in seconds, that all connections have been connected to the database.

The value is updated only when a request completes for a connection or when a connection disconnects. As a result, the value can lag behind for connections that are idle or busy executing for a long time in the database server. The value includes time accrued by any connection, including database events and background server connections (such as the database cleaner).

Returns the number of connections disconnected by the application but cached for connection pooling.

Returns the number of reused pooled connections.

Returns the number of pooled connections which were cached but could not be reused.

Returns On if connections to the current database are disabled, otherwise, returns Off.

Returns the name of the current parent server of a copy node in a read-only scale-out configuration.

Returns the current offset in the transaction log file where the next database operation is to be logged.

Returns the current number of file I/Os that were issued by the server but haven't yet completed.

Returns the current number of file reads that were issued by the server, but haven't yet completed.

Returns the current number of file writes that were issued by the server, but haven't yet completed.

Returns the number of times the server has forced a flush of the disk cache. On Windows, the disk cache doesn't need to be flushed if unbuffered (direct) I/O is used.

Returns the number of times the server has forced a flush of the disk cache. On Windows, the disk cache doesn't need to be flushed if unbuffered (direct) I/O is used.

Returns On or Off to indicate whether the database cleaner is enabled.

Returns the number of database file fragments. This property is supported on Windows.

Returns the number of pages that have been read from disk.

Returns the number of disk read hints.

Returns the number of disk read hint pages.

Returns the number of index internal-node pages that have been read from disk.

Returns the number of index leaf pages that have been read from disk.

Returns the number of table pages that have been read from disk.

Returns the number of disk work table reads.

Returns the number of disk read retries for scattered reads.

Returns On or Off to indicate whether the read-write file operations of the database are restricted to the directory where the main database file is located. See -sbx database option.

Returns the number of disk reads issued synchronously.

Returns the number of writes issued synchronously.

Returns the number of times the database server waited for an asynchronous read.

Returns the number of times the database server waited for an asynchronous write.

Returns the number of modified pages that have been written to disk.

Returns the number of disk write hints.

Returns the number of disk gather write hints.

Returns the type of bus to which the database file is connected. The value is one of the following:

• Unknown
• SCSI
• ATAPI
• ATA
• 1394
• SSA
• Fibre
• USB
• RAID
• iSCSI
• SAS
• SATA
• SD
• MMC
• Virtual
• FileBackedVirtual

If the bus type cannot be determined, this property returns NULL.

The value of this property for the primary dbspace is recorded in the SYSHISTORY view. See SYSHISTORY system view.

Returns the model number of the drive on which the database is located. The value of this property for the primary dbspace is recorded in the SYSHISTORY view. See SYSHISTORY system view.

If the drive model cannot be determined, this property returns NULL.

Returns the type of drive on which the database file is located. The value is one of the following:

• CD
• FIXED
• RAMDISK
• REMOTE
• REMOVABLE
• UNKNOWN

On Unix, depending on the version of Unix and the type of drive, it may not be possible to determine the drive type. In these cases UNKNOWN is returned.

This property has extensions that you can specify when querying the property value. See DB_EXTENDED_PROPERTY function [System].

Returns the type of encryption used for database or table encryption: one of None, Simple, AES, AES256, AES_FIPS, or AES256_FIPS.

Returns the part of the database, if any, that can be encrypted. The value is one of the following: TABLE, DATABASE, or NONE.

TABLE indicates that table encryption is enabled. DATABASE indicates that the whole database is encrypted. NONE indicates that table encryption is not enabled, and the database is not encrypted.

Returns the number of times that the expression cache was completely abandoned because the hit rate was too low.

Returns the number of times that the expression cache dropped to read-only status because the hit rate was low.

Returns the number of evictions from the expression cache.

Returns the number of hits in the expression cache.

Returns the number of values inserted into the expression cache.

Returns the number of lookups performed in the expression cache.

Returns the number of times that the expression cache resumed read-write status because the hit rate increased.

Returns the number of times the expression cache was started.

Returns the number of pages by which the database file has been extended.

Returns the number of pages by which temporary files have been extended.

Returns the file name of the database root file, including path.

This property has extensions that you can specify when querying for property value. See DB_EXTENDED_PROPERTY function [System].

Returns the file size of the system dbspace, in pages. This property has extensions that you can specify when querying for property value. See DB_EXTENDED_PROPERTY function [System].

Returns the number of free pages in the system dbspace. The FreePages property is only supported on databases created with version 8.0.0 or later.

This property has extensions that you can specify when querying for property value. See DB_EXTENDED_PROPERTY function [System].

Returns the number of comparisons that have been performed beyond the hash value in an index.

Returns the number of GETDATA requests.

Returns the value of the global_database_id option used to generate unique primary key values in a replication environment.

Returns a value indicating whether collation tailoring was specified when the database was created. Possible values are On or Off.

Returns a value indicating whether the database supports both big-endian and little endian UTF-16 encoding on all platforms, regardless of the endianness of the platform. Possible values are On or Off.

Returns the number of times that a hash operator was forced to partition because of competition for memory.

Returns the number of probe rows rejected by bit-vector filters.

Returns the number of rows written to hash work tables.

Returns the number of work tables created for hash-based operations.

Returns one of the following values:

Returns a value that indicates whether the database has a fixed file format to allow recovery from partial writes.

Returns the number of heaps used for short-term purposes such as query optimization.

Returns number of relocatable heaps currently locked in the cache.

Returns the number of heaps used for query processing (hash and sort operations).

Returns the number of relocatable heaps.

Returns the absolute count of cached database connections within all pools.

Returns the rate of connections reused by the same service.

Returns the rate of new connections that were allocated when a connection could not be accessed from a pool. This property only counts HTTP requests to services that use connection pooling. At the time of access, a connection may not have been available due to a small pool size whose oldest connection did not fit the steal criteria.

Returns the rate of connections taken by services where the connection belonged to another service.

The service steals a connection from another service if the criteria is met for an HTTP request for a service not having any direct reusable connections and the pool size and age of the least used connection.

A connection is allocated for the service and HttpConnPoolMisses is incremented instead if the pool criteria is not met.

This property is for internal use only.

Returns the number of times that the server's idle thread has become active to do idle writes, idle checkpoints, and so on.

Returns the number of checkpoints completed by the server's idle thread. An idle checkpoint occurs whenever the idle thread writes out the last dirty page in the cache.

Returns the number in hundredths of a second spent checkpointing during idle I/O.

Returns the number of disk writes that have been issued by the server's idle thread.

Returns the number of entries that have been added to indexes.

Returns the number of entries that have been looked up in indexes.

Returns the estimated number of simultaneous I/O operations supported by the dbspace. This property has extensions that you can specify when querying the property value. See DB_EXTENDED_PROPERTY function [System].

Returns the estimated number of I/O operations required to recover the database.

This property is for internal use only.

Returns the Java VM the database server uses to execute Java in the database.

Returns a comma-separated list of languages known to be supported by the database collation. The languages are in two-letter ISO format. If the language isn't known, the return value is NULL. For a list of the two-letter ISO format language names and the language they correspond to, see Locale language.

Returns the date and time, in milliseconds, of the most recent checkpoint.

Returns the redo log position after the last COMMIT operation was written to the transaction log by the database.

Returns the last redo position for which a write was issued to disk and the data was synchronized to the physical medium. Data prior to this position is expected to be present on disk even in the event of a power failure.

Returns the number of locks held by the database.

Returns the number of pages used to store lock information.

Returns the number of log file fragments. This property is supported on Windows.

Returns the number of redo free commits. A redo free commit occurs when a commit of the transaction log is requested but the log has already been written (so the commit was done for free).

Returns the file name of the transaction log mirror, including the path.

Returns the file name of the transaction log, including path.

Returns the number of pages that have been written to the transaction log.

This property is for internal use only.

This property is for internal use only.

Returns the maximum value that CurrIO has reached.

Returns the maximum value that CurrRead has reached.

Returns the maximum value that CurrWrite has reached.

Returns NULL if database mirroring is not in use, synchronous if the mirroring mode specified with the -xp option is synchronous, and asynchronous otherwise.

Returns one of the following values:

See Database mirroring.

Returns one of the following values when used with the DB_EXTENDED_PROPERTY function:

See Database mirroring and DB_EXTENDED_PROPERTY function [System].

Returns the number of times the database server waited more than 500 milliseconds when sending log pages to copy servers.

Returns one of the following values:

See Database mirroring.

Returns On if the database uses a multibyte character set, such as UTF-8. Otherwise, returns Off. For more information, see Multibyte character sets.

Returns the database name (identical to Alias). See Alias database property.

Returns the NCHAR character set of the database.

Returns the name of the collation used for NCHAR data. This property has extensions that you can specify when querying the property value. See DB_EXTENDED_PROPERTY function [System].

Returns the next scheduled execution time for a specified event; query this property using the DB_EXTENDED_PROPERTY function. See DB_EXTENDED_PROPERTY function [System].

Returns the action that is taken when an attempt is made to set a database option that is included in the OptionWatchList property. See sa_server_option system procedure.

Returns the list of database options being monitored by the database server. See sa_server_option system procedure.

Returns the number of client/server communication packets received. This value is not updated for HTTP or HTTPS connections.

Returns the number of packets that would have been received during client/server communications if compression was disabled. (This value is the same as the value for PacketsReceived if compression is disabled.)

Returns the number of client/server communication packets sent. This value is not updated for HTTP or HTTPS connections.

Returns the number of packets that would have been sent during client/server communications if compression was disabled. (This value is the same as the value for PacketsSent if compression is disabled.)

Returns the number of relocatable heap pages that have been read from the temporary file.

Returns the page size of the database, in bytes.

Returns one of the following values:

See Database mirroring.

Returns the number of statement prepares performed for the database.

Returns the number of prepared statements currently being maintained by the database server.

Returns the number of relocatable heap pages that have been used for procedures.

Returns On if procedure profiling is turned on for the database. Otherwise, returns Off.

Returns the number of requests reused from the plan cache.

Returns the number of requests processed by the optimizer bypass using costing.

Returns the number of requests processed by the optimizer bypass using heuristics.

Returns the number of requests initially processed by the optimizer bypass and subsequently fully optimized by the SQL Anywhere optimizer.

Returns the number of cached execution plans across all connections.

Returns the number of pages used to cache execution plans.

Returns the number of describe requests processed by the optimizer bypass.

Returns the number of describe requests processed by the optimizer.

Returns the number of cache pages used for query processing (hash and sort operations).

Returns the number of times a hash join was converted to a nested loops join.

Returns the number of times the server changed its execution plan during execution as a result of low memory conditions. The strategy can change because less memory is available than the optimizer estimated, or because the execution plan required more memory than the optimizer estimated.

Returns the number of requests actively using query memory.

Returns the total number of times a request waited for query memory, but failed to get it.

Returns the number of pages currently granted to requests.

Returns the total number of times any request attempted to acquire query memory.

Returns the total number of times any request waited for query memory.

Returns the current number of requests waiting for query memory.

Returns the number of OPEN requests for execution.

Returns the number of requests fully optimized.

Returns the number of reused query plans.

Returns the number of rows that have been read from base tables, either by a sequential scan or an index scan, for this database.

Returns the number of rows written to work tables during query processing.

Returns On if the database is being run in read-only mode. Otherwise, returns Off.

Returns the name of the database from which the tracing data is coming. Returns a blank string if tracing is not attached.

Returns an estimate of the amount of time required to recover the database as a percentage of the recovery time setting of the database. See -gr database server option and How the database server decides when to checkpoint.

Returns the number of iterations for recursive unions.

Returns the number of times recursive hash join used a hash strategy.

Returns the number of times recursive hash join used a nested loops strategy.

Returns the number of index probe cache misses for recursive hash join.

Returns the number of times recursive hash join attempted an index probe.

Returns the number of pages used for relocatable heaps (cursors, statements, procedures, triggers, views, and so on.).

Returns the minimal confirmed log offset for the SQL Remote Message Agent.

Returns the number of requests processed, or NULL if the RequestTiming server property is set to Off. See -zt database server option.

Returns the number of times connections to the database waited for atomic access, or NULL if the -zt option was not specified. See -zt database server option.

Returns the number of times connections to the database waited for I/O to complete, or NULL if the -zt option was not specified. See -zt database server option.

Returns the number of times connections to the database waited for a lock, or NULL if the -zt option was not specified. See -zt database server option.

Returns the number of times connections to the database waited for scheduling, or NULL if the -zt option was not specified. See -zt database server option.

Returns the amount of time spent processing requests, or NULL if the -zt option was not specified. See -zt database server option.

Returns the amount of time spent waiting for atomic access, or NULL if the RequestTiming server property is set to Off. See -zt database server option.

Returns the amount of time spent waiting for I/O to complete, or NULL if the -zt option was not specified. See -zt database server option.

Returns the amount of time spent waiting for a lock, or NULL if the -zt option was not specified. See -zt database server option.

Returns the amount of unscheduled time, or NULL if the -zt option was not specified. See -zt database server option.

Returns the number of client/server communication requests or round trips. It is different from PacketsReceived in that multi-packet requests count as one request, and liveness packets are not included.

The number of rollback requests that have been handled.

Returns the number of pages in the rollback log.

Returns the connection string where the tracing data is being sent. Returns a blank string if tracing is not attached.

Returns the number of snapshots associated with the database.

Returns one of the following values:

See allow_snapshot_isolation option.

Returns the number of merge passes used during sorting.

Returns the number of rows written to sort work tables.

Returns the number of sorted runs written during sorting.

Returns the number of sorted runs created during run formation.

Returns the number of work tables created for sorting.

Returns the total number of statements processed by DESCRIBE requests.

Returns the number of statements processed by the semantic query transformation phase.

Returns the number of statements processed by the semantic query transformation phase, but which skipped some of the semantic transformations.

Returns the number of statements that have completely skipped the semantic query transformation phase.

Returns On if an active connection issued a START SYNCHRONIZATION SCHEMA CHANGE but has not issued a STOP SYNCHRONIZATION SCHEMA CHANGE. See START SYNCHRONIZATION SCHEMA CHANGE statement [MobiLink] and STOP SYNCHRONIZATION SCHEMA CHANGE statement [MobiLink].

Returns the minimal confirmed log offset for the MobiLink client dbmlsync executable.

Returns the file name of the database temporary file, including path.

Returns the number of pages in the temporary file used for temporary tables.

Returns the time in seconds since the last command sequence or TDS client connection. Returns 0 if there is a current connection. Returns the time since the database started if no connections have been made to the database.

Returns the number of relocatable heap pages used for triggers.

Returns the current value of the user-defined performance counter. The semantics of this property are defined by the client application. This counter can also be accessed from the Performance Monitor. The Performance Monitor displays the change in the value of the counter over time.

For more information, see User-defined properties.

Returns the current value of the user-defined performance counter. The semantics of this property are defined by the client application. This counter can also be accessed from the Performance Monitor. The Performance Monitor displays the change in the value of the counter over time.

For more information, see User-defined properties.

Returns the current value of the user-defined performance counter. The semantics of this property are defined by the client application. This counter can also be accessed from the Performance Monitor. The Performance Monitor displays the change in the value of the counter over time.

For more information, see User-defined properties.

Returns the current value of the user-defined performance counter. The semantics of this property are defined by the client application. This counter can also be accessed from the Performance Monitor. The Performance Monitor displays the change in the value of the counter over time.

For more information, see User-defined properties.

Returns the current value of the user-defined performance counter. The semantics of this property are defined by the client application. This counter can also be accessed from the Performance Monitor. The Performance Monitor displays the change in the value of the counter over time.

For more information, see User-defined properties.

Returns the current value of the user-defined performance counter. The semantics of this property are defined by the client application. This counter can also be accessed from the Performance Monitor. The Performance Monitor displays the absolute value of the counter.

For more information, see User-defined properties.

Returns the current value of the user-defined performance counter. The semantics of this property are defined by the client application. This counter can also be accessed from the Performance Monitor. The Performance Monitor displays the absolute value of the counter.

For more information, see User-defined properties.

Returns the current value of the user-defined performance counter. The semantics of this property are defined by the client application. This counter can also be accessed from the Performance Monitor. The Performance Monitor displays the absolute value of the counter.

For more information, see User-defined properties.

Returns the current value of the user-defined performance counter. The semantics of this property are defined by the client application. This counter can also be accessed from the Performance Monitor. The Performance Monitor displays the absolute value of the counter.

For more information, see User-defined properties.

Returns the current value of the user-defined performance counter. The semantics of this property are defined by the client application. This counter can also be accessed from the Performance Monitor. The Performance Monitor displays the absolute value of the counter.

For more information, see User-defined properties.

Returns On if the database is storing UTC timestamps in the system tables.

Returns the number of pages in the temporary file that are being used for the row version store when snapshot isolation is enabled.

Returns the number of relocatable heap pages used for views.

Returns On if the database server adds checksums to pages before they are written out; otherwise, returns Off. See Corruption detection using checksums.

Returns the number of times any XPath query (using the OPENXML operator) was compiled by the database server since database server startup. See OPENXML operator.