Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Connection, database, and database server properties

List of database properties

Database properties are available for each connection to a database. Use the DB_PROPERTY system function to retrieve the value for an individual database property, or the sa_db_properties system procedure to retrieve the values of all database properties.

Example

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;
Database properties

Property name

Description

AccentSensitive

Whether the database is accent sensitive (On) or not (Off). The value is FRENCH if the database uses French sensitivity rules.

Alias

The database name.

AlternateMirrorServerName

The alternate mirror server name associated with the database if one was specified.

AlternateServerName

The alternate server name associated with the database if one was specified.

ApproximateCPUTime

An estimate of the amount of CPU time accumulated by the database, in seconds. The value 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.

ArbiterState

The state of the arbiter server. When the database you are connected to is not mirrored, this property is NULL. Otherwise this property is connected when the arbiter server is connected to the primary server, or disconnected when it is not connected to the primary server.

AuditingTypes

The types of auditing currently enabled.

Authenticated

Whether the database has been authenticated.

BackupInProgress

Whether the database is currently being backed up.

BlankPadding

Whether the database has blank padding enabled.

BytesReceived

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

BytesReceivedUncomp

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.

BytesSent

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

BytesSentUncomp

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.

CacheHits

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

CacheRead

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

CacheReadIndInt

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

CacheReadIndLeaf

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

CacheReadTable

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

CacheReadWorkTable

The number of cache work table reads.

Capabilities

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

CarverHeapPages

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

CaseSensitive

Whether the database is case sensitive (On) or not (Off).

CatalogCollation

The identifier for the collation used for the catalog. This property has extensions that you can specify when querying the property value with the DB_EXTENDED_PROPERTY function.

CharSet

The CHAR character set of the database. This property has extensions that you can specify when querying the property value with the DB_EXTENDED_PROPERTY function.

CheckpointLogCommitToDisk

The number of checkpoint log commits to disk.

CheckpointLogPagesInUse

The number of checkpoint log pages in use.

CheckpointLogPagesRelocated

The number of relocated checkpoint log pages.

CheckpointLogPagesWritten

The number of checkpoint log pages that have been written.

CheckpointLogSavePreimage

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

CheckpointLogSize

The size of the checkpoint log, in pages.

CheckpointLogWrites

The number of writes to the checkpoint log.

CheckpointUrgency

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

Checksum

Whether global checksums are enabled for the database (a checksum is created for each database page). Checksums are always present for critical pages.

Chkpt

The number of checkpoints that have been performed.

ChkptFlush

The number of ranges of adjacent pages written out during a checkpoint.

ChkptPage

The number of transaction log checkpoints.

CleanablePagesAdded

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

CleanablePagesCleaned

The number of database pages cleaned since database server startup.

CleanableRowsAdded

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

CleanableRowsCleaned

The number of shadow table rows deleted since database server startup.

ClientStmtCacheHits

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.

ClientStmtCacheMisses

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.

Collation

The collation used by the database. This property has extensions that you can specify when querying the property value.

Commit

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.

CommitFile

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.

ConnCount

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;

ConnectedTime

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).

ConnPoolCachedCount

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

ConnPoolHits

The number of reused pooled connections.

ConnPoolMisses

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

ConnsDisabled

Whether connections to the current database are disabled (On) or not (Off).

CopyNodeParent

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

CurrentRedoPos

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

CurrentTimelineID

For internal use only.

CurrentTimelineSignature

For internal use only.

CurrentTimezoneOffset

The number of minutes that the database is ahead of Coordinated Universal Time (UTC).

CurrIO

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

CurrRead

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

CurrWrite

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

Cursor

The number of declared cursors that are currently being maintained by the database server.

CursorOpen

The number of open cursors that are currently being maintained by the database server.

DatabaseCleaner

Whether the database cleaner is enabled.

DBFileFragments

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

DiskRead

The number of pages that have been read from disk.

DiskReadHint

The number of disk read hints.

DiskReadHintPages

The number of disk read hint pages.

DiskReadIndInt

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

DiskReadIndLeaf

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

DiskReadTable

The number of table pages that have been read from disk.

DiskReadWorkTable

The number of disk work table reads.

DiskRetryReadScatter

The number of disk read retries for scattered reads.

DiskSandbox

Whether the read-write file operations of the database are restricted to the directory where the main database file is located.

DiskSyncRead

The number of disk reads issued synchronously.

DiskSyncWrite

The number of writes issued synchronously.

DiskWaitRead

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

DiskWaitWrite

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

DiskWrite

The number of modified pages that have been written to disk.

DiskWriteHint

The number of disk write hints.

DiskWriteHintPages

The number of disk gather write hints.

DriveBus

The type of bus to which the database file is connected: one of 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 is NULL. The value of this property for the primary dbspace is recorded in the SYSHISTORY view.

DriveModel

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. If the drive model cannot be determined, this property is NULL.

DriveType

The type of drive on which the database file is located: one of CD, FIXED, RAMDISK, REMOTE, REMOVABLE, UNKNOWN. This property has extensions that you can specify when querying the property value with the DB_EXTENDED_PROPERTY function. 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 the value is UNKNOWN.

Encryption

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

EncryptionScope

The part of the database, if any, that can be encrypted. 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.

ExprCacheAbandons

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

ExprCacheDropsToReadOnly

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

ExprCacheEvicts

The number of evictions from the expression cache.

ExprCacheHits

The number of hits in the expression cache.

ExprCacheInserts

The number of values inserted into the expression cache.

ExprCacheLookups

The number of lookups performed in the expression cache.

ExprCacheResumesOfReadWrite

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

ExprCacheStarts

The number of times the expression cache was started.

ExtendDB

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

ExtendTempWrite

The number of pages by which temporary files have been extended.

File

The file name of the database root file, including path. This property has extensions that you can specify when querying the property value with the DB_EXTENDED_PROPERTY function.

FileSize

The file size of the system dbspace, in pages. This property has extensions that you can specify when querying the property value with the DB_EXTENDED_PROPERTY function.

FreePages

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 the property value with the DB_EXTENDED_PROPERTY function.

FullCompare

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

GetData

The number of GETDATA requests.

GlobalDBID

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

HasCollationTailoring

Whether collation tailoring was specified when the database was created. Possible values are On or Off.

HasEndianSwapFix

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.

HashForcedPartitions

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

HashRowsFiltered

The number of probe rows rejected by bit-vector filters.

HashRowsPartitioned

The number of rows written to hash work tables.

HashWorkTables

The number of work tables created for hash-based operations.

HasNCHARLegacyCollationFix

Whether the database was created by using version 11 or later software, or by using a version 10 database server with the legacy collation fix and that uses a legacy NCHAR collation (On). The value is Off for databases created using a version 10 database server without the legacy collation fix, or databases created using a version 10 database server that do not use a legacy NCHAR collation.

HasQDADTTFeature

Whether the queue depth checking feature is available (On) or not (Off).

HasTornWriteFix

Whether the database has a fixed file format to allow recovery from partial writes.

HeapsCarver

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

HeapsLocked

The number of relocatable heaps currently locked in the cache.

HeapsQuery

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

HeapsRelocatable

The number of relocatable heaps.

HttpClientMultipleHeaders

Whether the database supports multiple headers with the same name in an HTTP result set.

HttpConnPoolCachedCount

The absolute count of cached database connections within all pools.

HttpConnPoolHits

The rate of connections reused by the same service.

HttpConnPoolMisses

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.

HttpConnPoolSteals

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.

IdentitySignature

This property is for internal use only.

IdentitySignatureUUID

This property is for internal use only.

IdleCheck

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

IdleChkpt

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.

IdleChkTime

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

IdleWrite

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

IndAdd

The number of entries that have been added to indexes.

IndLookup

The number of entries that have been looked up in indexes.

IOParallelism

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 with the DB_EXTENDED_PROPERTY function.

IOToRecover

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

IQStore

This property is for internal use only.

JavaVM

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

KeyDerivationIterations

The number of times that the database encryption key was hashed when the database was created.

Language

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.

LastCheckpointTime

The date and time, in milliseconds, of the most recent checkpoint. If the database has the time_zone option set, then the value is returned using the database's time zone.

LastCommitRedoPos

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

LastSyncedRedoPos

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.

LastWrittenRedoPos

The last redo position for which a write was issued to disk. The write is not necessarily synchronized to the physical medium as it may still be cached by the operating system, disk controller, or disk drive.

LockCount

The number of locks held by the database.

LockTablePages

The number of pages used to store lock information.

LogFileFragments

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

LogFreeCommit

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).

LogMirrorName

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

LogName

The file name of the transaction log, including path.

LogWrite

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

LTMGeneration

This property is for internal use only.

LTMTrunc

This property is for internal use only.

MaxConnections

The maximum number of concurrent connections that are allowed to the database. This property corresponds to the max_connections database option.

MaxIO

The maximum value that CurrIO has reached.

MaxRead

The maximum value that CurrRead has reached.

MaxWrite

The maximum value that CurrWrite has reached.

MirrorMode

Whether database mirroring is not in use (NULL), or if the mirroring mode specified with the -xp option is synchronous or asynchronous.

MirrorRole

The role of the database server in a mirroring configuration. The value is Primary when the database is the primary database server or the mirror server. The value is Mirror when the database server is the mirror server. The value is Copy when the database server is a read-only mirror server that obtains its log pages from the current primary server, the current mirror server, or another read-only node.

MirrorServerState

The state of the mirror server. This property has extensions that you can specify when querying the property value with the DB_EXTENDED_PROPERTY function.

MirrorServerWaits

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

MirrorState

Information about the database's status in a mirroring configuration. This property has extensions that you can specify when querying the property value with the DB_EXTENDED_PROPERTY function.

MultiByteCharSet

Whether the database uses a multibyte character set, such as UTF-8, (On), or not (Off).

Name

The database name (identical to Alias).

NcharCharSet

The NCHAR character set of the database.

NcharCollation

The name of the collation used for NCHAR data. This property has extensions that you can specify when querying the property value.

NextScheduleTime

The next scheduled execution time for a specified event.This property has extensions that you can specify when querying the property value.

OptionWatchAction

The action that is taken when an attempt is made to set a database option that is included in the OptionWatchList property.

OptionWatchList

The list of database options being monitored by the database server.

PacketsReceived

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

PacketsReceivedUncomp

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.)

PacketsSent

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

PacketsSentUncomp

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.)

PageRelocations

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

PageSize

The page size of the database, in bytes.

ParameterizationPrepareCount

The number of prepares for statements that have been automatically parameterized.

PartnerState

Information about the database server's status in a mirroring configuration. Values include: Connected, when there is a connection from this server to a partner server and a connection from the partner server to this server; Disconnected when there are no connections between this server and the partner server; Incoming only when there is a there is a connection from the partner server to this server; and Outgoing only when there is a connection from this server to the partner server. The value is NULL when the database server is not involved in a mirroring configuration.

PlanStatisticsStored

For internal use only.

Prepares

The number of statement prepares performed for the database.

PrepStmt

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

PreviousTimelineID

For internal use only.

ProcedurePages

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

ProcedureProfiling

Whether procedure profiling is turned on for the database.

PropertyHistoryList

The current set of properties being tracked for this database.

QueryBypassed

The number of requests reused from the plan cache.

QueryBypassedCosted

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

QueryBypassedHeuristic

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

QueryBypassedOptimized

The number of requests initially processed by the optimizer bypass and subsequently fully optimized by the optimizer.

QueryCachedPlans

The number of cached execution plans across all connections.

QueryCachePages

The number of pages used to cache execution plans.

QueryDescribedBypass

The number of describe requests processed by the optimizer bypass.

QueryDescribedOptimizer

The number of describe requests processed by the optimizer.

QueryHeapPages

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

QueryJHToJNLOptUsed

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

QueryLowMemoryStrategy

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.

QueryMemActiveCurr

The number of requests actively using query memory.

QueryMemGrantFailed

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

QueryMemGrantGranted

The number of pages currently granted to requests.

QueryMemGrantRequested

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

QueryMemGrantWaited

The total number of times any request waited for query memory.

QueryMemGrantWaiting

The current number of requests waiting for query memory.

QueryOpened

The number of OPEN requests for execution.

QueryOptimized

The number of requests fully optimized.

QueryReused

The number of reused query plans.

QueryRowsFetched

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

QueryRowsMaterialized

The number of rows written to work tables during query processing.

ReadOnly

Whether the database is being run in read-only mode (On) or not (Off).

ReceivingTracingFrom

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

RecoveryUrgency

An estimate of the amount of time required to recover the database as a percentage of the recovery time setting of the database.

RecursiveIterations

The number of iterations for recursive unions.

RecursiveIterationsHash

The number of times recursive hash join used a hash strategy.

RecursiveIterationsNested

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

RecursiveJNLMisses

The number of index probe cache misses for recursive hash join.

RecursiveJNLProbes

The number of times recursive hash join attempted an index probe.

RelocatableHeapPages

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

RemoteTrunc

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

ReqCountActive

The number of requests processed, or NULL if the RequestTiming server property is set to Off.

ReqCountBlockContention

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

ReqCountBlockIO

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

ReqCountBlockLock

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

ReqCountUnscheduled

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

ReqTimeActive

The amount of time spent processing requests, or NULL if the -zt option was not specified.

ReqTimeBlockContention

The amount of time spent waiting for atomic access, or NULL if the RequestTiming server property is set to Off.

ReqTimeBlockIO

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

ReqTimeBlockLock

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

ReqTimeUnscheduled

The amount of unscheduled time, or NULL if the -zt option was not specified.

RequestsReceived

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

Rlbk

The number of rollback requests that have been handled.

RollbackLogPages

The number of pages in the rollback log.

SendingTracingTo

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

SnapshotCount

The number of snapshots associated with the database.

SnapshotIsolationState

Whether snapshot isolation is enabled for the database (On) or not (Off), or whether it will be enabled (in_transition_to_on) or disabled (in_transition_to_off ) once the current transactions complete.

SortMergePasses

The number of merge passes used during sorting.

SortRowsMaterialized

The number of rows written to sort work tables.

SortRunsWritten

The number of sorted runs written during sorting.

SortSortedRuns

The number of sorted runs created during run formation.

SortWorkTables

The number of work tables created for sorting.

StatementDescribes

The total number of statements processed by DESCRIBE requests.

StatementPostAnnotates

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

StatementPostAnnotatesSimple

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

StatementPostAnnotatesSkipped

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

SynchronizationSchemaChangeActive

Whether an active connection executed a START SYNCHRONIZATION SCHEMA CHANGE statement but has not executed a STOP SYNCHRONIZATION SCHEMA CHANGE statement (On) or not (Off).

SyncTrunc

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

TempFileName

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

TempTablePages

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

TimelineBranchOffset

For internal use only.

TimeWithoutClientConnection

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

TimeZone

The time zone that the database uses for time zone calculations. The value is NULL if the Timezone database option is not set.

TriggerPages

The number of relocatable heap pages used for triggers.

UserDefinedCounterRate01

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.

UserDefinedCounterRate02

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.

UserDefinedCounterRate03

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.

UserDefinedCounterRate04

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.

UserDefinedCounterRate05

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.

UserDefinedCounterRaw01

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.

UserDefinedCounterRaw02

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.

UserDefinedCounterRaw03

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.

UserDefinedCounterRaw04

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.

UserDefinedCounterRaw05

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.

UTCTimestampCatalog

Whether the database is storing UTC timestamps in the system tables (On) or not (Off).

VersionStorePages

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

ViewPages

The number of relocatable heap pages used for views.

WriteChecksum

Whether the database server adds checksums to pages before they are written out (On) or not (Off).

XPathCompiles

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