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

SQL Anywhere 12.0.1 » Context-Sensitive Help » SQL Anywhere plug-in help » SQL Anywhere properties windows

 

Database Properties window: Extended Information tab

This tab has the following components:

  • Database properties list   Lists the name and value of the properties for the database. Click Refresh to update the values. You can also press F5 to refresh the values.

    Property name Description
    AccentSensitive

    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.

    Alias

    Returns the database name.

    AlternateMirrorServerName

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

    AlternateServerName

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

    ApproximateCPUTime

    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.

    ArbiterState

    Returns one of the following values:

    • NULL   You are connected to a database that is not mirrored.

    • connected   The arbiter server is connected to the primary server.

    • disconnected   The arbiter server is not connected to the primary server.

    See Database mirroring.

    AuditingTypes

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

    Authenticated

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

    BlankPadding

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

    BytesReceived

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

    BytesReceivedUncomp

    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.

    BytesSent

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

    BytesSentUncomp

    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.

    CacheHits

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

    CacheRead

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

    CacheReadIndInt

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

    CacheReadIndLeaf

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

    CacheReadTable

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

    CacheReadWorkTable

    Returns the number of cache work table reads.

    Capabilities

    Returns the capability bits enabled for the database. This property is primarily for use by technical support.

    CarverHeapPages

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

    CaseSensitive

    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.

    CatalogCollation

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

    CharSet

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

    CheckpointLogCommitToDisk

    Returns the number of checkpoint log commits to disk.

    CheckpointLogPagesInUse

    Returns the number of checkpoint log pages in use.

    CheckpointLogPagesRelocated

    Returns the number of relocated checkpoint log pages.

    CheckpointLogPagesWritten

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

    CheckpointLogSavePreimage

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

    CheckpointLogSize

    Returns the size of the checkpoint log, in pages.

    CheckpointLogWrites

    Returns the number of writes to the checkpoint log.

    CheckpointUrgency

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

    Checksum

    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.

    Chkpt

    Returns the number of checkpoints that have been performed.

    ChkptFlush

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

    ChkptPage

    Returns the number of transaction log checkpoints.

    CleanablePagesAdded

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

    CleanablePagesCleaned

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

    CleanableRowsAdded

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

    CleanableRowsCleaned

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

    ClientStmtCacheHits

    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.

    ClientStmtCacheMisses

    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.

    Collation

    Returns the collation used by the database. For a list of available collations, see Supported and alternate collations.

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

    Commit

    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.

    CommitFile

    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.

    ConnCount

    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, run the following statement:

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

    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)

    ConnPoolCachedCount

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

    ConnPoolHits

    Returns the number of reused pooled connections.

    ConnPoolMisses

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

    ConnsDisabled

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

    CurrentRedoPos

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

    CurrIO

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

    CurrRead

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

    CurrWrite

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

    Cursor

    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.

    CursorOpen

    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.

    DatabaseCleaner

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

    DBFileFragments

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

    DiskRead

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

    DiskReadHint

    Returns the number of disk read hints.

    DiskReadHintPages

    Returns the number of disk read hint pages.

    DiskReadIndInt

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

    DiskReadIndLeaf

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

    DiskReadTable

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

    DiskReadWorkTable

    Returns the number of disk work table reads.

    DiskRetryReadScatter

    Returns the number of disk read retries for scattered reads.

    DiskSyncRead

    Returns the number of disk reads issued synchronously.

    DiskSyncWrite

    Returns the number of writes issued synchronously.

    DiskWaitRead

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

    DiskWaitWrite

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

    DiskWrite

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

    DiskWriteHint

    Returns the number of disk write hints.

    DiskWriteHintPages

    Returns the number of disk gather write hints.

    DriveBus

    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.

    DriveModel

    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.

    DriveType

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

    Encryption

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

    EncryptionScope

    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.

    ExprCacheAbandons

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

    ExprCacheDropsToReadOnly

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

    ExprCacheEvicts

    Returns the number of evictions from the expression cache.

    ExprCacheHits

    Returns the number of hits in the expression cache.

    ExprCacheInserts

    Returns the number of values inserted into the expression cache.

    ExprCacheLookups

    Returns the number of lookups performed in the expression cache.

    ExprCacheResumesOfReadWrite

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

    ExprCacheStarts

    Returns the number of times the expression cache was started.

    ExtendDB

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

    ExtendTempWrite

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

    File

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

    FileSize

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

    FreePages

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

    FullCompare

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

    GetData

    Returns the number of GETDATA requests.

    GlobalDBID

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

    HasCollationTailoring

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

    HasEndianSwapFix

    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.

    HashForcedPartitions

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

    HashRowsFiltered

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

    HashRowsPartitioned

    Returns the number of rows written to hash work tables.

    HashWorkTables

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

    HasNCHARLegacyCollationFix

    Returns one of the following values:

    • ON   For all databases created using version 11 or later, and databases created by a version 10 database server with the legacy collation fix and that use a legacy NCHAR collation.

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

    HasTornWriteFix

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

    HeapsCarver

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

    HeapsLocked

    Returns number of relocatable heaps currently locked in the cache.

    HeapsQuery

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

    HeapsRelocatable

    Returns the number of relocatable heaps.

    HttpConnPoolCachedCount

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

    HttpConnPoolHits

    Returns the rate of connections reused by the same service.

    HttpConnPoolMisses

    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.

    HttpConnPoolSteals

    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.

    IdentitySignature

    This property is for internal use only

    IdleCheck

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

    IdleChkpt

    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.

    IdleChkTime

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

    IdleWrite

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

    IndAdd

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

    IndLookup

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

    IOParallelism

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

    IOToRecover

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

    IQStore

    This property is for internal use only.

    JavaVM

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

    Language

    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.

    LastCheckpointTime

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

    LastCommitRedoPos

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

    LastSyncedRedoPos

    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.

    LastWrittenRedoPos Returns 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

    Returns the number of locks held by the database.

    LockTablePages

    Returns the number of pages used to store lock information.

    LogFileFragments

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

    LogFreeCommit

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

    LogMirrorName

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

    LogName

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

    LogWrite

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

    MaxIO

    Returns the maximum value that CurrIO has reached.

    MaxRead

    Returns the maximum value that CurrRead has reached.

    MaxWrite

    Returns the maximum value that CurrWrite has reached.

    MirrorMode

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

    MirrorRole

    Returns one of the following values:

    • primary   The primary database server or mirror server.

    • mirror   The mirror server.

    • copy   A read-only mirror server that obtains its log pages from the current primary server, the current mirror server, or another read-only node. A copy node cannot become the primary server. A copy node may also be referred to as a child node, since it has a parent from which it receives log pages.

    See Database mirroring.

    MirrorServerState

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

    • NULL   The database is not mirrored.

    • connected   There is a connection from this server to a specified server and a connection from the specified server to this server.

    • disconnected   There are no connections between this server and the specified server.

    • incoming only   There is a connection from the specified server to this server.

    • outgoing only   There is a connection from this server to the specified server.

    See Database mirroring and DB_EXTENDED_PROPERTY function [System].

    MirrorServerWaits

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

    MirrorState

    Returns one of the following values:

    • NULL   You are connected to a database that is not mirrored.

    • synchronizing   The mirror server is not connected or has not yet read all the primary server's log pages. This value is also returned if the synchronization mode is asynchronous.

    • synchronized   The mirror server is connected and has all changes that have been committed on the primary server.

    See Database mirroring.

    MultiByteCharSet

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

    Name

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

    NcharCharSet

    Returns the NCHAR character set of the database.

    NcharCollation

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

    NextScheduleTime

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

    OptionWatchAction

    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.

    OptionWatchList

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

    PacketsReceived

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

    PacketsReceivedUncomp

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

    PacketsSent

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

    PacketsSentUncomp

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

    PageRelocations

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

    PageSize

    Returns the page size of the database, in bytes.

    PartnerState

    Returns one of the following values:

    • NULL   The database is not mirrored.

    • connected   There is a connection from this server to a partner server and a connection from the partner server to this server.

    • disconnected   There are no connections between this server and the partner server.

    • incoming only   There is a connection from the partner server to this server.

    • outgoing only   There is a connection from this server to the partner server.

    See Database mirroring.

    Prepares

    Returns the number of statement prepares performed for the database.

    PrepStmt

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

    ProcedurePages

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

    ProcedureProfiling

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

    QueryBypassed

    Returns the number of requests reused from the plan cache.

    QueryBypassedCosted

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

    QueryBypassedHeuristic

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

    QueryBypassedOptimized

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

    QueryCachedPlans

    Returns the number of cached execution plans across all connections.

    QueryCachePages

    Returns the number of pages used to cache execution plans.

    QueryDescribedBypass

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

    QueryDescribedOptimizer

    Returns the number of describe requests processed by the optimizer.

    QueryHeapPages

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

    QueryJHToJNLOptUsed

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

    QueryLowMemoryStrategy

    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.

    QueryMemActiveCurr

    Returns the number of requests actively using query memory.

    QueryMemGrantFailed

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

    QueryMemGrantGranted

    Returns the number of pages currently granted to requests.

    QueryMemGrantRequested

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

    QueryMemGrantWaited

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

    QueryMemGrantWaiting

    Returns the current number of requests waiting for query memory.

    QueryOpened

    Returns the number of OPEN requests for execution.

    QueryOptimized

    Returns the number of requests fully optimized.

    QueryReused

    Returns the number of reused query plans.

    QueryRowsFetched

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

    QueryRowsMaterialized

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

    ReadOnly

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

    ReceivingTracingFrom

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

    RecoveryUrgency

    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 dbeng12/dbsrv12 server option and How the database server decides when to checkpoint.

    RecursiveIterations

    Returns the number of iterations for recursive unions.

    RecursiveIterationsHash

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

    RecursiveIterationsNested

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

    RecursiveJNLMisses

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

    RecursiveJNLProbes

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

    RelocatableHeapPages

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

    RemoteTrunc

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

    ReqCountActive

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

    ReqCountBlockContention

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

    ReqCountBlockIO

    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 dbeng12/dbsrv12 server option.

    ReqCountBlockLock

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

    ReqCountUnscheduled

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

    ReqTimeActive

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

    ReqTimeBlockContention

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

    ReqTimeBlockIO

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

    ReqTimeBlockLock

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

    ReqTimeUnscheduled

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

    RequestsReceived

    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.

    Rlbk

    The number of rollback requests that have been handled.

    RollbackLogPages

    Returns the number of pages in the rollback log.

    SendingTracingTo

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

    SnapshotCount

    Returns the number of snapshots associated with the database.

    SnapshotIsolationState

    Returns one of the following values:

    • On   snapshot isolation is enabled for the database.

    • Off   snapshot isolation is disabled for the database.

    • in_transition_to_on   snapshot isolation will be enabled once the current transactions complete.

    • in_transition_to_off   snapshot isolation will be disabled once the current transactions complete.

    See allow_snapshot_isolation option.

    SortMergePasses

    Returns the number of merge passes used during sorting.

    SortRowsMaterialized

    Returns the number of rows written to sort work tables.

    SortRunsWritten

    Returns the number of sorted runs written during sorting.

    SortSortedRuns

    Returns the number of sorted runs created during run formation.

    SortWorkTables

    Returns the number of work tables created for sorting.

    StatementDescribes

    Returns the total number of statements processed by DESCRIBE requests.

    StatementPostAnnotates

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

    StatementPostAnnotatesSimple

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

    StatementPostAnnotatesSkipped

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

    SynchronizationSchemaChangeActive

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

    SyncTrunc

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

    TempFileName

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

    TempTablePages

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

    TriggerPages

    Returns the number of relocatable heap pages used for triggers.

    UserDefinedCounterRate01

    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.

    UserDefinedCounterRate02

    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.

    UserDefinedCounterRate03

    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.

    UserDefinedCounterRate04

    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.

    UserDefinedCounterRate05

    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.

    UserDefinedCounterRaw01

    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.

    UserDefinedCounterRaw02

    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.

    UserDefinedCounterRaw03

    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.

    UserDefinedCounterRaw04

    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.

    UserDefinedCounterRaw05

    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.

    VersionStorePages

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

    ViewPages

    Returns the number of relocatable heap pages used for views.

    WriteChecksum

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

    XPathCompiles

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

  • Refresh   Click Refresh to update the values in the Database Properties list.

  • Description   Describes the selected property.

 See also