ESE_009_Help=Database provides performance statistics for each process using the ESE high performance embedded database management system.
TableClass_009_Help=Statistics for the ESE high performance embedded database management system by Table Class
Instances_009_Help=Instances in this process
PagesConvertedSec_009_Help=Pages Converted/sec is the count of times per second a database page is converted from an older database format
PagesConvertedTotal_009_Help=Pages Converted is the count of database pages that have been converted from an older format
RecordsConvertedSec_009_Help=Records Converted/sec is the count of times per second a database record is converted from an older database format
RecordsConvertedTotal_009_Help=Records Converted is the count of database records that have been converted from an older format
OSHeapAllocPerSec_009_Help=Heap Allocs/sec is the number of memory allocations from the MP Heaps per second. [Dev Only]
OSHeapFreePerSec_009_Help=Heap Frees/sec is the number of memory frees to the MP Heaps per second. [Dev Only]
OSHeapAlloc_009_Help=Heap Allocations is the current number of memory allocations in the MP Heaps. [Dev Only]
OSHeapBytesAlloc_009_Help=Heap Bytes Allocated is the size of all memory allocations in the MP Heaps discounting heap managemnt overhead. [Dev Only]
OSPageBytesReserved_009_Help=Page Bytes Reserved is the size of all explicitly reserved virtual address space. [Dev Only]
OSPageBytesCommitted_009_Help=Page Bytes Committed is the size of all explicitly committed virtual memory backing store (page file and physical memory). [Dev Only]
FCBAsyncScan_009_Help=FCB Asynchronous Scan/sec is the number of cached schema records (FCBs) scanned during asynchronous schema record cleanup. These records are scanned to age out older schema definitions. [Dev Only]
FCBAsyncPurge_009_Help=FCB Asynchronous Purge/sec is the number of cached schema records (FCBs) purged during asynchronous schema record cleanup. These records are purged to age out older schema definitions. [Dev Only]
FCBAsyncThresholdScan_009_Help=FCB Asynchronous Threshold-Scan/sec is the number of cached schema records (FCBs) scanned during asynchronous schema record cleanup. Cleanup was triggered by a large number of schema records above the preferred limit. These records are aggressively scanned to age out older schema definitions. [Dev Only]
FCBAsyncThresholdPurge_009_Help=FCB Asynchronous Threshold-Purge/sec is the number of cached schema records (FCBs) purged during asynchronous schema record cleanup. Cleanup was triggered by a large number of schema records above the preferred limit. These records are aggressively purged to age out older schema definitions. [Dev Only]
FCBAsyncPurgeConflict_009_Help=FCB Asynchronous Purge Conflicts/sec is the number of failed purge attempts on cached schema records (FCBs) during asynchronous schema record cleanup. The purge operation failed because exclusive ownership of the schema record could not be obtained. [Dev Only]
FCBSyncPurge_009_Help=FCB Synchronous Purge/sec is the number of cached schema records (FCBs) being synchronously purged each second. [Dev Only]
FCBSyncPurgeStalls_009_Help=FCB Synchronous Purge Stalls/sec is the number of stalls encountered while waiting for exclusive ownership of cached schema records (FCBs) in order to synchronously purge them. [Dev Only]
FCBAllocWaitForVersionCleanup_009_Help=FCB Allocations Wait For Version Cleanup/sec is the number FCB allocations that must first wait for version cleanup in an attempt to free used FCBs for re-use. [Dev Only]
FCBPurgeOnClose_009_Help=FCB Purge On Cursor Close/sec is the number of cached schema records (FCBs) being synchronously purged when the cursor is closed (instead of leaving the schema record cached) each second. [Dev Only]
FCBCacheHits_009_Help=FCB Cache % Hit is the percentage of schema records (FCBs) opened directly from the schema record cache. No file operations were required. [Dev Only]
FCBCacheRequests_009_Help=No text
FCBCacheStalls_009_Help=FCB Cache Stalls/sec is the number of stalls encountered while waiting for exclusive ownership of cached schema records (FCBs) in order to update their reference count. [Dev Only]
FCBCacheMax_009_Help=FCB Cache Maximum is the absolute maximum number of the schema records (FCBs) that can exist in the cache. [Dev Only]
FCBCachePreferred_009_Help=FCB Cache Preferred is the preferred maximum number of the schema records (FCBs) that should exist in the cache. [Dev Only]
FCBCacheAlloc_009_Help=FCB Cache Allocated is the number of cached schema records (FCBs) currently allocated and in use. [Dev Only]
FCBCacheAllocAvail_009_Help=FCB Cache Available is the number of cached schema records (FCBs) currently allocated but not in use. These records will be used and/or purged as required. [Dev Only]
PIBInUse_009_Help=Sessions In Use is the number of database sessions currently open for use by client threads. [Dev Only]
PIBUsed_009_Help=Sessions % Used is the percentage of database sessions currently open for use by client threads. [Dev Only]
PIBTotal_009_Help=No text
TableOpenCacheHitRate_009_Help=Table Open Cache % Hit is the percentage of database tables opened using cached schema information. If this percentage is too low, the table cache size may be too small.
TableOpenCacheRequests_009_Help=No text
TableOpenCacheHitsPerSec_009_Help=Table Open Cache Hits/sec is the number of database tables opened using cached schema information per second. If this rate is too low, the table cache size may be too small.
TableOpenCacheMissesPerSec_009_Help=Table Open Cache Misses/sec is the number of database tables opened without using cached schema information per second. If this rate is too high, the table cache size may be too small.
TableOpensPerSec_009_Help=Table Opens/sec is the number of database tables opened per second.
LGBytesWrittenPerSec_009_Help=Log Bytes Write per second is the rate bytes are written to the log.
LGBufferBytesUsed_009_Help=Log Buffer Bytes Used is the amount of bytes in the log buffers that have not yet been flushed to the logs. [Dev only]
LGBufferBytesFree_009_Help=Log Buffer Bytes Free is the amount of free space available in the log buffers. [Dev only]
LGUsersWaiting_009_Help=Log Threads Waiting is the number of threads waiting for their data to be written to the log in order to complete an update of the database. If this number is too high, the log may be a bottleneck.
LGCheckpointDepth_009_Help=Log Checkpoint Depth represents the amount of work, in bytes, that will need to be redone or undone to the database file(s) if the process crashes. [Dev Only]
LGLogGenerationCheckpointDepth_009_Help=Log Generation Checkpoint Depth represents the amount of work, in count of log files, that will need to be redone or undone to the database file(s) if the process crashes. [Dev Only]
UserROTrxCommit0PerSec_009_Help=User Read Only Transaction Commits to Level 0/sec is the count of fully committed transactions started by the calling process that do not modify any data stored in the database engine. [Dev Only]
UserRWTrxCommit0PerSec_009_Help=User Read/Write Transaction Commits to Level 0/sec is the count of fully committed transactions started by the calling process that modify data stored in the database engine. [Dev Only]
UserTrxCommit0PerSec_009_Help=User Transaction Commits to Level 0/sec is the count of fully committed transactions started by the calling process that access data stored in the database engine. [Dev Only]
UserROTrxRollback0PerSec_009_Help=User Read Only Transaction Rollbacks to Level 0/sec is the count of aborted transactions started by the calling process that do not modify any data stored in the database engine. [Dev Only]
UserRWTrxRollback0PerSec_009_Help=User Read/Write Transaction Rollbacks to Level 0/sec is the count of aborted transactions started by the calling process that modify data stored in the database engine. [Dev Only]
UserTrxRollback0PerSec_009_Help=User Transaction Rollbacks to Level 0/sec is the count of aborted transactions started by the calling process that access data stored in the database engine. [Dev Only]
SystemROTrxCommit0PerSec_009_Help=System Read Only Transaction Commits to Level 0/sec is the count of fully committed transactions started internally that do not modify any data stored in the database engine. [Dev Only]
SystemRWTrxCommit0PerSec_009_Help=System Read/Write Transaction Commits to Level 0/sec is the count of fully committed transactions started internally that modify data stored in the database engine. [Dev Only]
SystemTrxCommit0PerSec_009_Help=System Transaction Commits to Level 0/sec is the count of fully committed transactions started internally that access data stored in the database engine. [Dev Only]
SystemROTrxRollback0PerSec_009_Help=System Read Only Transaction Rollbacks to Level 0/sec is the count of aborted transactions started internally that do not modify any data stored in the database engine. [Dev Only]
SystemRWTrxRollback0PerSec_009_Help=System Read/Write Transaction Rollbacks to Level 0/sec is the count of aborted transactions started internally that modify data stored in the database engine. [Dev Only]
SystemTrxRollback0PerSec_009_Help=System Transaction Rollbacks to Level 0/sec is the count of aborted transactions started internally that access data stored in the database engine. [Dev Only]
IODatabaseFileExtensionAsyncConsumed_009_Help=Database Page Allocation File Extension Async Consumed/sec is the rate of page allocations from a database file that must be serviced by extending the database file, but which do not stall when doing doing so. [Dev Only]
IODatabaseFileExtensionStall_009_Help=Database Page Allocation File Extension Stalls/sec is the rate of page allocations from a database file that must be serviced by extending the database file and which stall when doing so. [Dev Only]
LGRecordPerSec_009_Help=Log Records/sec is the count of records written to the database log buffers per second. [Dev Only]
LGCapacityFlushPerSec_009_Help=Log Buffer Capacity Flushes/sec is the count of times the database log buffers must be flushed per second because they are full. [Dev Only]
LGCommitFlushPerSec_009_Help=Log Buffer Commit Flushes/sec is the count of times the database log buffers must be flushed per second because a transaction is fully committing its changes. [Dev Only]
LGFlushPerSec_009_Help=Log Buffer Flushes/sec is the count of times the database log buffers must be flushed per second.
LGWritePerSec_009_Help=Log Writes/sec is the number of times the log buffers are written to the log file(s) per second. If this number approaches the maximum write rate for the media holding the log file(s), the log may be a bottleneck.
LGStallPerSec_009_Help=Log Record Stalls/sec is the number of log records that cannot be added to the log buffers per second because they are full. If this counter is non-zero most of the time, the log buffer size may be a bottleneck.
VERcbucketAllocated_009_Help=Total number of version buckets allocated
VERcbucketDeleteAllocated_009_Help=Total number of version buckets allocated for FlagDelete RCEs [Dev Only]
VERBucketAllocWaitForVersionCleanup_009_Help=VER Bucket Allocations Wait For Version Cleanup/sec is the number of version bucket allocations that must first wait for version cleanup in an attempt to free used version buckets for re-use. [Dev Only]
VERcbAverageBookmark_009_Help=Average length of bookmark in RCE [Dev Only]
VERUnnecessaryCalls_009_Help=Number of times per second we look in the version store for a node whose version bit is set but which has no versions [Dev Only]
VERAsyncCleanupTasksDispatched_009_Help=Number of times per second a version store clean task is dispatched asynchronously to be performed [Dev Only]
VERSyncCleanupTasksDispatched_009_Help=Number of times per second a version store clean task is performed synchronously [Dev Only]
VERCleanupTasksDiscarded_009_Help=Number of times per second a version store clean task was discarded due to load concerns [Dev Only]
VERCleanupTasksFailed_009_Help=Number of times per second a dispatched version store cleanup task fails [Dev Only]
RECInserts_009_Help=Record Inserts/sec is the rate at which records are being inserted into database tables. [Dev Only]
RECDeletes_009_Help=Record Deletes/sec is the rate at which records in database tables are being flagged for deletion. [Dev Only]
RECReplaces_009_Help=Record Deletes/sec is the rate at which records in database tables are being updated. [Dev Only]
RECNoOpReplaces_009_Help=Record Unnecessary Replaces/sec is the rate at which updates to records in database tables are being discarded because the update did not actually modify the contents of the record. [Dev Only]
RECRedundantReplaces_009_Help=Record Redundant Replaces/sec is the rate at which records in database tables are being updated with the exact same content of the original record. [Dev Only]
RECEscrowUpdates_009_Help=Record Escrow-Updates/sec is the rate at which records in database tables are being escrow-updated. [Dev Only]
RECIndexInserts_009_Help=Secondary Index Inserts/sec is the rate at which entries are being inserted into indexes of database tables. [Dev Only]
RECIndexDeletes_009_Help=Secondary Index Deletes/sec is the rate at which entries in indexes of database tables are being flagged for deletion. [Dev Only]
RECFalseIndexColumnUpdates_009_Help=False Index Column Updates/sec is the number of times per second an attempt was made to update an index because an update to at least one of the indexed columns was detected, only to discover that none of the indexed columns had actually changed (and therefore no index update was actually required). [Dev Only]
RECFalseTupleIndexColumnUpdates_009_Help=False Tuple Index Column Updates/sec is the number of times per second an attempt was made to update a tuple index because an update to the tuple-indexed column was detected, only to discover that the column had not actually changed (and therefore no index update was actually required). [Dev Only]
RECUpdateIntrinsicLV_009_Help=Record Intrinsic Long-Values Updated/sec is the rate at which intrinsic long-values are added to or replaced in records of database tables. [Dev Only]
RECAddSeparateLV_009_Help=Record Separated Long-Values Added/sec is the rate at which separated long-values are normally added to records of database tables. [Dev Only]
RECAddForcedSeparateLV_009_Help=Record Separated Long-Values Forced/sec is the rate at which separated long-values are added to records of a database table because they could not be accommodated in the record itself. [Dev Only]
RECForceSeparateAllLV_009_Help=Record Separated Long-Values All Forced/sec is the rate at which all intrinsic long-values are separated out of a record of a database table in order to accommodate updates to the record. [Dev Only]
RECRefAllSeparateLV_009_Help= Record Separated Long-Values Reference All/sec is the rate at which a reference is added for all the separated long-values associated with a record of a database table. [Dev Only]
RECDerefAllSeparateLV_009_Help= Record Separated Long-Values Dereference All/sec is the rate at which a reference is removed for all the separated long-values associated with a record of a database table. [Dev Only]
LVSeeks_009_Help=Separated Long-Value Seeks/sec is the rate at which seeks for a separated long-value in a database table are performed. [Dev Only]
LVRetrieves_009_Help=Separated Long-Value Retrieves/sec is the rate at which retrievals of a separated long-value in a database table are performed. [Dev Only]
LVCreates_009_Help=Separated Long-Value Creates/sec is the rate at which new separated long-values are added to a database table. [Dev Only]
LVUpdates_009_Help=Separated Long-Value Updates/sec is the rate at which existing separated long-values in a database table are modified. [Dev Only]
LVDeletes_009_Help=Separated Long-Value Deletes/sec is the rate at which separated long-values in a database table are flagged for deletion. [Dev Only]
LVCopies_009_Help=Separated Long-Value Copies/sec is the rate at which existing separated long-values in a database table are copied. [Dev Only]
LVChunkSeeks_009_Help=Separated Long-Value Chunk Seeks/sec is the rate at which seeks for a particular chunk of a separated long-value in a database table are performed. [Dev Only]
LVChunkRetrieves_009_Help=Separated Long-Value Chunk Retrieves/sec is the rate at which retrievals of a chunk of a separated long-value in a database table are performed. [Dev Only]
LVChunkAppends_009_Help=Separated Long-Value Chunk Appends/sec is the rate at which chunks are appended to separated long-values of database tables. [Dev Only]
LVChunkReplaces_009_Help=Separated Long-Value Chunk Replaces/sec is the rate at which existing separated long-value chunks in a database table are replaced. [Dev Only]
LVChunkDeletes_009_Help=Separated Long-Value Chunk Deletes/sec is the rate at which separated long-value chunks in a database table are flagged for deletion. [Dev Only]
LVChunkCopies_009_Help=Separated Long-Value Chunk Copies/sec is the rate at which existing separated long-value chunks in a database table are copied. [Dev Only]
BTAppendSplit_009_Help=B+ Tree Append Splits/sec is the count of times a page is appended to a database B+ Tree per second. [Dev Only]
BTRightSplit_009_Help=B+ Tree Right Splits/sec is the count of times a page is split right in a database B+ Tree per second. [Dev Only]
BTRightHotpointSplit_009_Help=B+ Tree Right Hotpoint Splits/sec is the count of times a page is split right in a database B+ Tree, but which is treated as an append at a local "hotpoint" in the B+ Tree per second. [Dev Only]
BTVerticalSplit_009_Help=B+ Tree Vertical Splits/sec is the count of times a page is split vertically in a database B+ Tree per second. [Dev Only]
BTSplit_009_Help=B+ Tree Splits/sec is the count of times a page is appended to or split in a database B+ Tree per second. [Dev Only]
BTEmptyPageMerge_009_Help=B+ Tree Empty Page Merges/sec is the count of empty pages removed from a database B+ Tree per second. [Dev Only]
BTRightMerge_009_Help=Right Merges/sec is the count of pages removed from a database B+ Tree per second by moving all its records to the next page to the right. [Dev Only]
BTPartialMerge_009_Help=B+ Tree Partial Merges/sec is the count of pages where some of its records are moved to a page on the right in a database B+ Tree per second. [Dev Only]
BTMerge_009_Help=B+ Tree Merges/sec is the count of pages merged in a database B+ Tree per second. [Dev Only]
BTFailedSPCWriteLatch_009_Help=B+ Tree Failed Simple Page Cleanup Attempts/sec is the rate that attempts to reclaim deleted node space on a page are unsuccessful due to a conflict when attempting to write-latch the page. The cleanup is re-tried by locking the root of the B+ Tree. [Dev Only]
BTSeekShortCircuit_009_Help=B+ Tree Seek Short Circuits/sec is the count of repeated seeks to the same record in a database B+ Tree that are saved by jumping directly to the cached physical location of that record per second. [Dev Only]
BTUnnecessarySiblingLatch_009_Help=B+ Tree Unnecessary Sibling Latches/sec is the count of sibling pages latched during a database B+ Tree Delete in the hopes of performing a merge where a merge is not possible, making that latch unnecessary. [Dev Only]
BTNext_009_Help=B+ Tree Move Nexts/sec is the count of times the database engine moves to the next record in a B+ Tree per second. [Dev Only]
BTNextNonVisibleNodesSkipped_009_Help=B+ Tree Move Nexts (Non-Visible Nodes Skipped)/sec is the count of times the database engine skips non-visible records while attempting to move to the next visible record in a B+ Tree per second. [Dev Only]
BTPrev_009_Help=B+ Tree Move Prevs/sec is the count of times the database engine moves to the previous record in a B+ Tree per second. [Dev Only]
BTPrevNonVisibleNodesSkipped_009_Help=B+ Tree Move Prevs (Non-Visible Nodes Skipped)/sec is the count of times the database engine skips non-visible records while attempting to move to the previous visible record in a B+ Tree per second. [Dev Only]
BTSeek_009_Help=B+ Tree Seeks/sec is the count of times a record is seeked to by a key in a database B+ Tree per second. [Dev Only]
BTInsert_009_Help=B+ Tree Inserts/sec is the count of times a record is inserted in a database B+ Tree per second. [Dev Only]
BTReplace_009_Help=B+ Tree Replaces/sec is the count of times a record is replaced in a database B+ Tree per second. [Dev Only]
BTFlagDelete_009_Help=B+ Tree Flag Deletes/sec is the count of times a record is flag deleted in a database B+ Tree per second. [Dev Only]
BTDelete_009_Help=B+ Tree Deletes/sec is the count of times a record is deleted in a database B+ Tree per second. [Dev Only]
BTAppend_009_Help=B+ Tree Appends/sec is the count of times a record is appended to a database B+ Tree per second. [Dev Only]
SPCreate_009_Help=B+ Tree Creates/sec is the number of B+ Trees and their corresponding space trees (if any) created per second. This can also be viewed as the number of FDP creates per second. [Dev Only]
SPCreateCum_009_Help=B+ Tree Creates (Total) is the total number of B+ Trees and their corresponding space trees (if any) created. This can also be viewed as the total number of FDP creates. [Dev Only]
SPDelete_009_Help=B+ Tree Destroys/sec is the number of B+ Trees and their corresponding space trees (if any) destroyed per second. This can also be viewed as the number of FDP destroys per second. [Dev Only]
SPDeleteCum_009_Help=B+ Tree Destroys (Total) is the total number of B+ Trees and their corresponding space trees (if any) destroyed. This can also be viewed as the total number of FDP destroys. [Dev Only]
BFCacheHits_009_Help=Database Cache % Hit is the percentage of database file page requests that were fulfilled by the database cache without causing a file operation. If this percentage is too low, the database cache size may be too small.
BFCacheRequests_009_Help=No text
BFPctClean_009_Help=Database Cache % Clean is the percentage of the database cache that does not contain modified data. [Dev Only]
BFTotalBuffers2_009_Help=No text
BFPagesReadAsyncPerSec_009_Help=Database Pages Read Async/sec is the rate that pages are asynchronously read from the database file(s) into the database cache. [Dev Only]
BFPagesReadSyncPerSec_009_Help=Database Pages Read Sync/sec is the rate that pages are synchronously read from the database file(s) into the database cache. [Dev Only]
BFPagesWrittenPerSec_009_Help=Database Pages Written/sec is the rate that pages are written to the database file (s) from the database cache. [Dev Only]
BFPagesTransferredPerSec_009_Help=Database Pages Transferred/sec is the rate that pages are transferred from the database file(s) to the database cache and vice versa. [Dev Only]
BFLatch_009_Help=Database Page Latches/sec is the rate that database pages are latched for access to their data. [Dev Only]
BFFastLatch_009_Help=Database Page Fast Latches/sec is the rate that database pages are latched for access to their data using a hint to tell the cache manager where that page might be in memory. [Dev Only]
BFBadLatchHint_009_Help=Database Page Bad Latch Hints/sec is the rate that incorrect hints to the location of a given page in the cache are given to the cache manager. These hints are used to perform fast latches. [Dev Only]
BFPctFastLatch_009_Help=Database Cache % Fast Latch is the percentage of database pages latched for access to their data using a hint to tell the cache manager where that page might be in memory. Ideally, this percentage should match Database Cache % Hit. [Dev Only]
BFTotalLatches_009_Help=No text
BFLatchConflict_009_Help=Database Page Latch Conflicts/sec is the rate that users latching a database page for access to its data fail due to a conflicting latch owned on that same page by another user. [Dev Only]
BFLatchStall_009_Help=Database Page Latch Stalls/sec is the rate that users latching a database page for access to its data must wait for another user to release a latch on that same page. [Dev Only]
BFPctAvail_009_Help=Database Cache % Available is the percentage of the database cache that can be allocated to cache database pages that are newly created or read in from the database file(s). [Dev Only]
BFTotalBuffers3_009_Help=No text
BFCacheFault_009_Help=Database Page Faults/sec is the rate that database file page requests require the database cache manager to allocate a new page from the database cache.
BFCacheEvict_009_Help=Database Page Evictions/sec is the rate that database file page requests that require the database cache manager to allocate a new page from the database cache force another database page out of the cache. The eviction count is charged when the page is allocated and not when the previous owner of that page was actually evicted from the cache. If this rate is too high, the database cache size may be too small.
BFAvailStallsPerSec_009_Help=Database Page Fault Stalls/sec is the rate of page faults that cannot be serviced because there are no pages available for allocation from the database cache. If this counter is non-zero most of the time, the clean threshold may be too low.
BFCacheSizeMB_009_Help=Database Cache Size (MB) is the amount of system memory (in MegaBytes) used by the database cache manager to hold commonly used information from the database file(s) to prevent file operations. If the database cache size seems to be too small for optimal performance and there is very little available memory on the system (see Memory/Available Bytes), adding more memory to the system may increase performance. If there is a lot of available memory on the system and the database cache size is not growing beyond a certain point, the database cache size may be capped at an artificially low limit. Increasing this limit may increase performance.
BFCacheSize_009_Help=Database Cache Size is the amount of system memory used by the database cache manager to hold commonly used information from the database file(s) to prevent file operations. If the database cache size seems to be too small for optimal performance and there is very little available memory on the system (see Memory/Available Bytes), adding more memory to the system may increase performance. If there is a lot of available memory on the system and the database cache size is not growing beyond a certain point, the database cache size may be capped at an artificially low limit. Increasing this limit may increase performance.
BFCacheSizeMin_009_Help=Database Cache Size Min is the minimum amount of system memory configured for use by the database cache manager to hold commonly used information from the database file(s) to prevent file operations. [Dev Only]
BFCacheSizeMax_009_Help=Database Cache Size Max is the maximum amount of system memory configured for use by the database cache manager to hold commonly used information from the database file(s) to prevent file operations. [Dev Only]
BFPctStartFlushThreshold_009_Help=Database Cache % Available Min is the minimum percentage of the database cache that is kept to be allocated to cache database pages that are newly created or read in from the database file(s). If the percentage of available pages drops below this minimum, pages are thrown out of the database cache until the maximum percentage of available pages is reached. This percentage should be set as low as possible without causing the actual percentage to drop to zero, causing cache fault stalls. [Dev Only]
BFTotalBuffers4_009_Help=No text
BFPctStopFlushThreshold_009_Help=Database Cache % Available Max is the maximum percentage of the database cache that is kept to be allocated to cache database pages that are newly created or read in from the database file(s). This percentage should be set as low as possible but far enough above the minimum percentage so that efficient production of availible pages is possible. [Dev Only]
BFTotalBuffers5_009_Help=No text
BFPagesPreread_009_Help=Database Pages Preread/sec is the rate that pages are read in anticipation of future use from the database file(s) into the database cache. [Dev Only]
BFCachedPagesPreread_009_Help=Database Cached Pages Preread/sec is the rate that pages are read in anticipation of future use from the database file(s) into the database cache that are already cached. This is non-ideal behavior that represents a waste of processing time. [Dev Only]
BFPagesPrereadUntouched_009_Help=Database Pages Preread Untouched/sec is the rate that pages are read in anticipation of future use from the database file(s) into the database cache that were subsequently thrown out without being used. This is non-ideal behavior that represents a waste of I/O bandwidth and processing time . [Dev Only]
BFPagesVersioned_009_Help=Database Pages Versioned / sec is the rate at which pages in the database cache are being copied into new pages in the cache for the purpose of being asynchronously written while the current version of that page in the database file is still being modified. This feature is primarily used to avoid cycles, branches, or long chains of flush order dependencies without requiring the pages involved to be synchronously written to disk. [Dev Only]
BFPctVersioned_009_Help=Database Cache % Versioned is the percentage of the database cache that contains older versions of currently cached pages that have not yet been written to disk and thrown out of the cache. [Dev Only]
BFTotalBuffers6_009_Help=No text
BFPagesOrdinarilyWritten_009_Help=Database Pages Ordinarily Written/sec is the rate that pages are written to the database file (s) from the database cache in preparation for evicting them from the cache to make room for other data. [Dev Only]
BFPagesAnomalouslyWritten_009_Help=Database Pages Anomalously Written/sec is the rate that pages are written to the database file (s) from the database cache before they would ordinarily be written. [Dev Only]
BFPagesOpportunelyWritten_009_Help=Database Pages Opportunely Written/sec is the rate that pages are written to the database file (s) from the database cache because they happen to be near other pages that must be written. These additional writes are performed before they must happen in the hope that the total number of seeks required to write all the pages is reduced. [Dev Only]
BFPagesRepeatedlyWritten_009_Help=Database Pages Repeatedly Written/sec is the rate that pages are written to the database file (s) from the database cache more than once in their lifetime in the cache. These page writes represent extra writes above the theoretical minimum and can therefore be considered overhead. [Dev Only]
BFPagesIdlyWritten_009_Help=Database Pages Idly Written/sec is the rate that pages are written to the database file (s) from the database cache because there is low disk activity. [Dev Only]
BFPagesCoalescedWritten_009_Help=Database Pages Coalesced Written/sec is the rate that pages are written to the database file (s) from the database cache coalesced with another page. [Dev Only]
BFPagesCoalescedRead_009_Help=Database Pages Coalesced Read/sec is the rate that pages are read from the database file (s) to the database cache coalesced with another page. [Dev Only]
BFPageHistory_009_Help=Database Page History Records is the current number of database page access history records retained for supporting the LRU-K page replacment algorithm. [Dev Only]
BFPageHistoryHits_009_Help=Database Page History % Hit is the percentage of database page access history record lookups that were successful. [Dev Only]
BFPageHistoryReqs_009_Help=No text
BFPageScanned_009_Help=Database Page Scans/sec is the rate at which database pages are considered for eviction from the database page cache. [Dev Only]
BFPageScannedOutOfOrder_009_Help=Database Page Scans Out-of-order/sec is the rate at which database pages are considered for eviction from the database page cache in a priority counter to the page replacement algorithm. [Dev Only]
BFPageScannedTotal_009_Help=No text
BKReadIO_009_Help=Streaming Backup Pages Read/sec is the rate of database read operations performed for the purpose of streaming backups. [Dev Only]
OLDPageReferenced_009_Help=Online Defrag Pages Referenced/sec is the rate at which online defragmentation is touching database pages. [Dev Only]
OLDPageRead_009_Help=Online Defrag Pages Read/sec is the rate of database read operations being performed by online defragmentation. [Dev Only]
OLDPagePreread_009_Help=Online Defrag Pages Preread/sec is the rate at which database pages are read in anticipation of future use by online defragmentation. [Dev Only]
OLDPageDirtied_009_Help=Online Defrag Pages Dirtied/sec is the rate at which online defragmentation is modifying clean database pages. [Dev Only]
OLDPageRedirtied_009_Help=Online Defrag Pages Re-Dirtied/sec is the rate at which online defragmentation is modifying database pages that already contained modifications. [Dev Only]
OLDLogRecord_009_Help=Online Defrag Log Records/sec is the rate at which online defragmentation is generating log records. [Dev Only]
OLDLogBytes_009_Help=Online Defrag Average Log Bytes is the average size of the log records being generated by online defragmentation. [Dev only]
OLDLogRecordsTotal1_009_Help=No text
DBTASKPageReferenced_009_Help=Database Tasks Pages Referenced/sec is the rate at which background database tasks are touching database pages. [Dev Only]
DBTASKPageRead_009_Help=Database Tasks Pages Read/sec is the rate of database read operations being performed by background database tasks. [Dev Only]
DBTASKPagePreread_009_Help=Database Tasks Pages Preread/sec is the rate at which database pages are read in anticipation of future use by background database tasks. [Dev Only]
DBTASKPageDirtied_009_Help=Database Tasks Pages Dirtied/sec is the rate at which background database tasks are modifying clean database pages. [Dev Only]
DBTASKPageRedirtied_009_Help=Database Tasks Pages Re-Dirtied/sec is the rate at which background databases tasks are modifying database pages that already contained modifications. [Dev Only]
DBTASKLogRecord_009_Help=Database Tasks Log Records/sec is the rate at which background database tasks are generating log records. [Dev Only]
DBTASKLogBytes_009_Help=Database Tasks Average Log Bytes is the average size of the log records being generated by background database tasks. [Dev only]
DBTASKLogRecordsTotal1_009_Help=No text
OSFileDbReadIO_009_Help=I/O Database Reads/sec is the rate of database read operations completed.
OSFileDbReadIOTotalTicks_009_Help=I/O Database Reads Average Latency is the average length of time, in milliseconds, per database read operation.
OSFileDbReadIOTotal1_009_Help=No text
OSFileDbReadIOTotalBytes_009_Help=I/O Database Reads Average Bytes is the average number of bytes transferred per database read operation. [Dev Only]
OSFileDbReadIOTotal2_009_Help=No text
OSFileDbReadIOInHeap_009_Help=I/O Database Reads In Heap is the number of database read operations queued in the database engine's I/O heap and waiting to be issued. [Dev Only]
OSFileDbReadIOAsyncPending_009_Help=I/O Database Reads Async Pending is the number of database read operations asynchronously pending completion. [Dev Only]
OSFileDbReadIOAbnormalLatency_009_Help=I/O Database Reads Abnormal Latency/sec is the rate of database read operations that take an abnormally long length of time (default is 1 minute) to be serviced by the OS. [Dev Only]
OSFileLogReadIO_009_Help=I/O Log Reads/sec is the rate of logfile read operations completed.
OSFileLogReadIOTotalTicks_009_Help=I/O Log Reads Average Latency is the average length of time, in milliseconds, per logfile read operation. [Dev Only]
OSFileLogReadIOTotal1_009_Help=No text
OSFileLogReadIOTotalBytes_009_Help=I/O Log Reads Average Bytes is the average number of bytes transferred per logfile read operation. [Dev Only]
OSFileLogReadIOTotal2_009_Help=No text
OSFileLogReadIOInHeap_009_Help=I/O Log Reads In Heap is the number of logfile read operations queued in the database engine's I/O heap and waiting to be issued. [Dev Only]
OSFileLogReadIOAsyncPending_009_Help=I/O Log Reads Async Pending is the number of logfile read operations asynchronously pending completion. [Dev Only]
OSFileLogReadIOAbnormalLatency_009_Help=I/O Log Reads Abnormal Latency/sec is the rate of logfile read operations that take an abnormally long length of time (default is 1 minute) to be serviced by the OS. [Dev Only]
OSFileDbWriteIO_009_Help=I/O Database Writes/sec is the rate of database write operations completed.
OSFileDbWriteIOTotalTicks_009_Help=I/O Database Writes Average Latency is the average length of time, in milliseconds, per database write operation.
OSFileDbWriteIOTotal1_009_Help=No text
OSFileDbWriteIOTotalBytes_009_Help=I/O Database Writes Average Bytes is the average number of bytes transferred per database write operation. [Dev Only]
OSFileDbWriteIOTotal2_009_Help=No text
OSFileDbWriteIOInHeap_009_Help=I/O Database Writes In Heap is the number of database write operations queued in the database engine's I/O heap and waiting to be issued. [Dev Only]
OSFileDbWriteIOAsyncPending_009_Help=I/O Database Writes Async Pending is the number of database write operations asynchronously pending completion. [Dev Only]
OSFileDbWriteIOAbnormalLatency_009_Help=I/O Database Writes Abnormal Latency/sec is the rate of database write operations that take an abnormally long length of time (default is 1 minute) to be serviced by the OS. [Dev Only]
OSFileLogWriteIO_009_Help=I/O Log Writes/sec is the rate of logfile write operations completed.
OSFileLogWriteIOTotalTicks_009_Help=I/O Log Writes Average Latency is the average length of time, in milliseconds, per logfile write operation.
OSFileLogWriteIOTotal1_009_Help=No text
OSFileLogWriteIOTotalBytes_009_Help=I/O Log Writes Average Bytes is the average number of bytes transferred per logfile write operation. [Dev Only]
OSFileLogWriteIOTotal2_009_Help=No text
OSFileLogWriteIOInHeap_009_Help=I/O Log Writes In Heap is the number of logfile write operations queued in the database engine's I/O heap and waiting to be issued. [Dev Only]
OSFileLogWriteIOAsyncPending_009_Help=I/O Log Writes Async Pending is the number of logfile write operations asynchronously pending completion. [Dev Only]
OSFileLogWriteIOAbnormalLatency_009_Help=I/O Log Writes Abnormal Latency/sec is the rate of logfile write operations that take an abnormally long length of time (default is 1 minute) to be serviced by the OS. [Dev Only]
OSSLVFileTableInserts_009_Help=SLV File Table Inserts/sec is the rate at which entries are inserted into an SLV File Table in the system. [Dev Only]
OSSLVFileTableCleans_009_Help=SLV File Table Cleans/sec is the rate at which attempta are made to delete an entry from an SLV File Table in the system. [Dev Only]
OSSLVFileTableDeletes_009_Help=SLV File Table Deletes/sec is the rate at which entries are deleted from an SLV File Table in the system. [Dev Only]
OSSLVFileTableEntries_009_Help=SLV File Table Entries is the total number of entries contained in all SLV File Tables in the system. [Dev Only]
OSSYNCThreadBlock_009_Help=Threads Blocked/sec is the rate at which the execution of threads are suspended to wait for a specific event to occur or for the acquisition of a resource currently owned by another thread. [Dev Only]
OSSYNCThreadsBlocked_009_Help=Threads Blocked is the current number of threads whose execution has been suspended to wait for a specific event to occur or for the acquisition of a resource currently owned by another thread. [Dev Only]
TRECInserts_009_Help=Record Inserts/sec is the rate at which records are being inserted into database tables. [Dev Only]
TRECDeletes_009_Help=Record Deletes/sec is the rate at which records in database tables are being flagged for deletion. [Dev Only]
TRECReplaces_009_Help=Record Deletes/sec is the rate at which records in database tables are being updated. [Dev Only]
TRECNoOpReplaces_009_Help=Record Unnecessary Replaces/sec is the rate at which updates to records in database tables are being discarded because the update did not actually modify the contents of the record. [Dev Only]
TRECRedundantReplaces_009_Help=Record Redundant Replaces/sec is the rate at which records in database tables are being updated with the exact same content of the original record. [Dev Only]
TRECEscrowUpdates_009_Help=Record Escrow-Updates/sec is the rate at which records in database tables are being escrow-updated. [Dev Only]
TRECIndexInserts_009_Help=Secondary Index Inserts/sec is the rate at which entries are being inserted into indexes of database tables. [Dev Only]
TRECIndexDeletes_009_Help=Secondary Index Deletes/sec is the rate at which entries in indexes of database tables are being flagged for deletion. [Dev Only]
TRECFalseIndexColumnUpdates_009_Help=False Index Column Updates/sec is the number of times per second an attempt was made to update an index because an update to at least one of the indexed columns was detected, only to discover that none of the indexed columns had actually changed (and therefore no index update was actually required). [Dev Only]
TRECFalseTupleIndexColumnUpdates_009_Help=False Tuple Index Column Updates/sec is the number of times per second an attempt was made to update a tuple index because an update to the tuple-indexed column was detected, only to discover that the column had not actually changed (and therefore no index update was actually required). [Dev Only]
TRECUpdateIntrinsicLV_009_Help=Record Intrinsic Long-Values Updated/sec is the rate at which intrinsic long-values are added to or replaced in records of database tables. [Dev Only]
TRECAddSeparateLV_009_Help=Record Separated Long-Values Added/sec is the rate at which separated long-values are normally added to records of database tables. [Dev Only]
TRECAddForcedSeparateLV_009_Help=Record Separated Long-Values Forced/sec is the rate at which separated long-values are added to records of a database table because they could not be accommodated in the record itself. [Dev Only]
TRECForceSeparateAllLV_009_Help=Record Separated Long-Values All Forced/sec is the rate at which all intrinsic long-values are separated out of a record of a database table in order to accommodate updates to the record. [Dev Only]
TRECRefAllSeparateLV_009_Help= Record Separated Long-Values Reference All/sec is the rate at which a reference is added for all the separated long-values associated with a record of a database table. [Dev Only]
TRECDerefAllSeparateLV_009_Help= Record Separated Long-Values Dereference All/sec is the rate at which a reference is removed for all the separated long-values associated with a record of a database table. [Dev Only]
TLVSeeks_009_Help=Separated Long-Value Seeks/sec is the rate at which seeks for a separated long-value in a database table are performed. [Dev Only]
TLVRetrieves_009_Help=Separated Long-Value Retrieves/sec is the rate at which retrievals of a separated long-value in a database table are performed. [Dev Only]
TLVCreates_009_Help=Separated Long-Value Creates/sec is the rate at which new separated long-values are added to a database table. [Dev Only]
TLVUpdates_009_Help=Separated Long-Value Updates/sec is the rate at which existing separated long-values in a database table are modified. [Dev Only]
TLVDeletes_009_Help=Separated Long-Value Deletes/sec is the rate at which separated long-values in a database table are flagged for deletion. [Dev Only]
TLVCopies_009_Help=Separated Long-Value Copies/sec is the rate at which existing separated long-values in a database table are copied. [Dev Only]
TLVChunkSeeks_009_Help=Separated Long-Value Chunk Seeks/sec is the rate at which seeks for a particular chunk of a separated long-value in a database table are performed. [Dev Only]
TLVChunkRetrieves_009_Help=Separated Long-Value Chunk Retrieves/sec is the rate at which retrievals of a chunk of a separated long-value in a database table are performed. [Dev Only]
TLVChunkAppends_009_Help=Separated Long-Value Chunk Appends/sec is the rate at which chunks are appended to separated long-values of database tables. [Dev Only]
TLVChunkReplaces_009_Help=Separated Long-Value Chunk Replaces/sec is the rate at which existing separated long-value chunks in a database table are replaced. [Dev Only]
TLVChunkDeletes_009_Help=Separated Long-Value Chunk Deletes/sec is the rate at which separated long-value chunks in a database table are flagged for deletion. [Dev Only]
TLVChunkCopies_009_Help=Separated Long-Value Chunk Copies/sec is the rate at which existing separated long-value chunks in a database table are copied. [Dev Only]
TBTAppendSplit_009_Help=B+ Tree Append Splits/sec is the count of times a page is appended to a database B+ Tree per second. [Dev Only]
TBTRightSplit_009_Help=B+ Tree Right Splits/sec is the count of times a page is split right in a database B+ Tree per second. [Dev Only]
TBTRightHotpointSplit_009_Help=B+ Tree Right Hotpoint Splits/sec is the count of times a page is split right in a database B+ Tree, but which is treated as an append at a local "hotpoint" in the B+ Tree per second. [Dev Only]
TBTVerticalSplit_009_Help=B+ Tree Vertical Splits/sec is the count of times a page is split vertically in a database B+ Tree per second. [Dev Only]
TBTSplit_009_Help=B+ Tree Splits/sec is the count of times a page is appended to or split in a database B+ Tree per second. [Dev Only]
TBTEmptyPageMerge_009_Help=B+ Tree Empty Page Merges/sec is the count of empty pages removed from a database B+ Tree per second. [Dev Only]
TBTRightMerge_009_Help=Right Merges/sec is the count of pages removed from a database B+ Tree per second by moving all its records to the next page to the right. [Dev Only]
TBTPartialMerge_009_Help=B+ Tree Partial Merges/sec is the count of pages where some of its records are moved to a page on the right in a database B+ Tree per second. [Dev Only]
TBTMerge_009_Help=B+ Tree Merges/sec is the count of pages merged in a database B+ Tree per second. [Dev Only]
TBTFailedSPCWriteLatch_009_Help=B+ Tree Failed Simple Page Cleanup Attempts/sec is the rate that attempts to reclaim deleted node space on a page are unsuccessful due to a conflict when attempting to write-latch the page. The cleanup is re-tried by locking the root of the B+ Tree. [Dev Only]
TBTSeekShortCircuit_009_Help=B+ Tree Seek Short Circuits/sec is the count of repeated seeks to the same record in a database B+ Tree that are saved by jumping directly to the cached physical location of that record per second. [Dev Only]
TBTUnnecessarySiblingLatch_009_Help=B+ Tree Unnecessary Sibling Latches/sec is the count of sibling pages latched during a database B+ Tree Delete in the hopes of performing a merge where a merge is not possible, making that latch unnecessary. [Dev Only]
TBTNext_009_Help=B+ Tree Move Nexts/sec is the count of times the database engine moves to the next record in a B+ Tree per second. [Dev Only]
TBTNextNonVisibleNodesSkipped_009_Help=B+ Tree Move Nexts (Non-Visible Nodes Skipped)/sec is the count of times the database engine skips non-visible records while attempting to move to the next visible record in a B+ Tree per second. [Dev Only]
TBTPrev_009_Help=B+ Tree Move Prevs/sec is the count of times the database engine moves to the previous record in a B+ Tree per second. [Dev Only]
TBTPrevNonVisibleNodesSkipped_009_Help=B+ Tree Move Prevs (Non-Visible Nodes Skipped)/sec is the count of times the database engine skips non-visible records while attempting to move to the previous visible record in a B+ Tree per second. [Dev Only]
TBTSeek_009_Help=B+ Tree Seeks/sec is the count of times a record is seeked to by a key in a database B+ Tree per second. [Dev Only]
TBTInsert_009_Help=B+ Tree Inserts/sec is the count of times a record is inserted in a database B+ Tree per second. [Dev Only]
TBTReplace_009_Help=B+ Tree Replaces/sec is the count of times a record is replaced in a database B+ Tree per second. [Dev Only]
TBTFlagDelete_009_Help=B+ Tree Flag Deletes/sec is the count of times a record is flag deleted in a database B+ Tree per second. [Dev Only]
TBTDelete_009_Help=B+ Tree Deletes/sec is the count of times a record is deleted in a database B+ Tree per second. [Dev Only]
TBTAppend_009_Help=B+ Tree Appends/sec is the count of times a record is appended to a database B+ Tree per second. [Dev Only]
TSPCreate_009_Help=B+ Tree Creates/sec is the number of B+ Trees and their corresponding space trees (if any) created per second. This can also be viewed as the number of FDP creates per second. [Dev Only]
TSPCreateCum_009_Help=B+ Tree Creates (Total) is the total number of B+ Trees and their corresponding space trees (if any) created. This can also be viewed as the total number of FDP creates. [Dev Only]
TSPDelete_009_Help=B+ Tree Destroys/sec is the number of B+ Trees and their corresponding space trees (if any) destroyed per second. This can also be viewed as the number of FDP destroys per second. [Dev Only]
TSPDeleteCum_009_Help=B+ Tree Destroys (Total) is the total number of B+ Trees and their corresponding space trees (if any) destroyed. This can also be viewed as the total number of FDP destroys. [Dev Only]
TBFCacheSizeMB_009_Help=Database Cache Size (MB) is the amount of system memory (in MegaBytes) used by the database cache manager to hold commonly used information from the database file(s) to prevent file operations. If the database cache size seems to be too small for optimal performance and there is very little available memory on the system (see Memory/Available Bytes), adding more memory to the system may increase performance. If there is a lot of available memory on the system and the database cache size is not growing beyond a certain point, the database cache size may be capped at an artificially low limit. Increasing this limit may increase performance.
TBFPagesReadAsyncPerSec_009_Help=Database Pages Read Async/sec is the rate that pages are asynchronously read from the database file(s) into the database cache. [Dev Only]
TBFPagesReadSyncPerSec_009_Help=Database Pages Read Sync/sec is the rate that pages are synchronously read from the database file(s) into the database cache. [Dev Only]
TBFPagesWrittenPerSec_009_Help=Database Pages Written/sec is the rate that pages are written to the database file (s) from the database cache. [Dev Only]
TBFPagesTransferredPerSec_009_Help=Database Pages Transferred/sec is the rate that pages are transferred from the database file(s) to the database cache and vice versa. [Dev Only]
TBFPagesPreread_009_Help=Database Pages Preread/sec is the rate that pages are read in anticipation of future use from the database file(s) into the database cache. [Dev Only]
TBFCachedPagesPreread_009_Help=Database Cached Pages Preread/sec is the rate that pages are read in anticipation of future use from the database file(s) into the database cache that are already cached. This is non-ideal behavior that represents a waste of processing time. [Dev Only]
TBFPagesPrereadUntouched_009_Help=Database Pages Preread Untouched/sec is the rate that pages are read in anticipation of future use from the database file(s) into the database cache that were subsequently thrown out without being used. This is non-ideal behavior that represents a waste of I/O bandwidth and processing time . [Dev Only]
TBFPagesVersioned_009_Help=Database Pages Versioned / sec is the rate at which pages in the database cache are being copied into new pages in the cache for the purpose of being asynchronously written while the current version of that page in the database file is still being modified. This feature is primarily used to avoid cycles, branches, or long chains of flush order dependencies without requiring the pages involved to be synchronously written to disk. [Dev Only]
TBFPagesOrdinarilyWritten_009_Help=Database Pages Ordinarily Written/sec is the rate that pages are written to the database file (s) from the database cache in preparation for evicting them from the cache to make room for other data. [Dev Only]
TBFPagesAnomalouslyWritten_009_Help=Database Pages Anomalously Written/sec is the rate that pages are written to the database file (s) from the database cache before they would ordinarily be written. [Dev Only]
TBFPagesOpportunelyWritten_009_Help=Database Pages Opportunely Written/sec is the rate that pages are written to the database file (s) from the database cache because they happen to be near other pages that must be written. These additional writes are performed before they must happen in the hope that the total number of seeks required to write all the pages is reduced. [Dev Only]
TBFPagesRepeatedlyWritten_009_Help=Database Pages Repeatedly Written/sec is the rate that pages are written to the database file (s) from the database cache more than once in their lifetime in the cache. These page writes represent extra writes above the theoretical minimum and can therefore be considered overhead. [Dev Only]
TBFPagesIdlyWritten_009_Help=Database Pages Idly Written/sec is the rate that pages are written to the database file (s) from the database cache because there is low disk activity. [Dev Only]
TBFPagesCoalescedWritten_009_Help=Database Pages Coalesced Written/sec is the rate that pages are written to the database file (s) from the database cache coalesced with another page. [Dev Only]
TBFPagesCoalescedRead_009_Help=Database Pages Coalesced Read/sec is the rate that pages are read from the database file (s) to the database cache coalesced with another page. [Dev Only]
IPagesConvertedSec_009_Help=Pages Converted/sec is the count of times per second a database page is converted from an older database format
IPagesConvertedTotal_009_Help=Pages Converted is the count of database pages that have been converted from an older format
IRecordsConvertedSec_009_Help=Records Converted/sec is the count of times per second a database record is converted from an older database format
IRecordsConvertedTotal_009_Help=Records Converted is the count of database records that have been converted from an older format
IFCBAsyncScan_009_Help=FCB Asynchronous Scan/sec is the number of cached schema records (FCBs) scanned during asynchronous schema record cleanup. These records are scanned to age out older schema definitions. [Dev Only]
IFCBAsyncPurge_009_Help=FCB Asynchronous Purge/sec is the number of cached schema records (FCBs) purged during asynchronous schema record cleanup. These records are purged to age out older schema definitions. [Dev Only]
IFCBAsyncThresholdScan_009_Help=FCB Asynchronous Threshold-Scan/sec is the number of cached schema records (FCBs) scanned during asynchronous schema record cleanup. Cleanup was triggered by a large number of schema records above the preferred limit. These records are aggressively scanned to age out older schema definitions. [Dev Only]
IFCBAsyncThresholdPurge_009_Help=FCB Asynchronous Threshold-Purge/sec is the number of cached schema records (FCBs) purged during asynchronous schema record cleanup. Cleanup was triggered by a large number of schema records above the preferred limit. These records are aggressively purged to age out older schema definitions. [Dev Only]
IFCBAsyncPurgeConflict_009_Help=FCB Asynchronous Purge Conflicts/sec is the number of failed purge attempts on cached schema records (FCBs) during asynchronous schema record cleanup. The purge operation failed because exclusive ownership of the schema record could not be obtained. [Dev Only]
IFCBSyncPurge_009_Help=FCB Synchronous Purge/sec is the number of cached schema records (FCBs) being synchronously purged each second. [Dev Only]
IFCBSyncPurgeStalls_009_Help=FCB Synchronous Purge Stalls/sec is the number of stalls encountered while waiting for exclusive ownership of cached schema records (FCBs) in order to synchronously purge them. [Dev Only]
IFCBAllocWaitForVersionCleanup_009_Help=FCB Allocations Wait For Version Cleanup/sec is the number of FCB allocations that must first wait for version cleanup in an attempt to free used FCBs for re-use. [Dev Only]
IFCBPurgeOnClose_009_Help=FCB Purge On Cursor Close/sec is the number of cached schema records (FCBs) being synchronously purged when the cursor is closed (instead of leaving the schema record cached) each second. [Dev Only]
IFCBCacheHits_009_Help=FCB Cache % Hit is the percentage of schema records (FCBs) opened directly from the schema record cache. No file operations were required. [Dev Only]
IFCBCacheRequests_009_Help=No text
IFCBCacheStalls_009_Help=FCB Cache Stalls/sec is the number of stalls encountered while waiting for exclusive ownership of cached schema records (FCBs) in order to update their reference count. [Dev Only]
IFCBCacheMax_009_Help=FCB Cache Maximum is the absolute maximum number of the schema records (FCBs) that can exist in the cache. [Dev Only]
IFCBCachePreferred_009_Help=FCB Cache Preferred is the preferred maximum number of the schema records (FCBs) that should exist in the cache. [Dev Only]
IFCBCacheAlloc_009_Help=FCB Cache Allocated is the number of cached schema records (FCBs) currently allocated and in use. [Dev Only]
IFCBCacheAllocAvail_009_Help=FCB Cache Available is the number of cached schema records (FCBs) currently allocated but not in use. These records will be used and/or purged as required. [Dev Only]
IPIBInUse_009_Help=Sessions In Use is the number of database sessions currently open for use by client threads. [Dev Only]
IPIBUsed_009_Help=Sessions % Used is the percentage of database sessions currently open for use by client threads. [Dev Only]
IPIBTotal_009_Help=No text
ITableOpenCacheHitRate_009_Help=Table Open Cache % Hit is the percentage of database tables opened using cached schema information. If this percentage is too low, the table cache size may be too small.
ITableOpenCacheRequests_009_Help=No text
ITableOpenCacheHitsPerSec_009_Help=Table Open Cache Hits/sec is the number of database tables opened using cached schema information per second. If this rate is too low, the table cache size may be too small.
ITableOpenCacheMissesPerSec_009_Help=Table Open Cache Misses/sec is the number of database tables opened without using cached schema information per second. If this rate is too high, the table cache size may be too small.
ITableOpensPerSec_009_Help=Table Opens/sec is the number of database tables opened per second.
ILGBytesWrittenPerSec_009_Help=Log Bytes Write per second is the rate bytes are written to the log.
ILGBufferSize_009_Help=Log Buffer Size is the amount of memory, in bytes, allocated for the database log buffers. [Dev Only]
ILGBufferBytesUsed_009_Help=Log Buffer Bytes Used is the amount of bytes in the log buffers that have not yet been flushed to the logs. [Dev only]
ILGBufferBytesFree_009_Help=Log Buffer Bytes Free is the amount of free space available in the log buffers. [Dev only]
ILGUsersWaiting_009_Help=Log Threads Waiting is the number of threads waiting for their data to be written to the log in order to complete an update of the database. If this number is too high, the log may be a bottleneck.
ILGFileSize_009_Help=Log File Size is the size, in bytes, of the database log files. [Dev Only]
ILGCheckpointDepth_009_Help=Log Checkpoint Depth represents the amount of work, in bytes, that will need to be redone or undone to the database file(s) if the process crashes. [Dev Only]
ILGLogGenerationCheckpointDepth_009_Help=Log Generation Checkpoint Depth represents the amount of work, in count of log files, that will need to be redone or undone to the database file(s) if the process crashes.
IUserROTrxCommit0PerSec_009_Help=User Read Only Transaction Commits to Level 0/sec is the count of fully committed transactions started by the calling process that do not modify any data stored in the database engine. [Dev Only]
IUserRWTrxCommit0PerSec_009_Help=User Read/Write Transaction Commits to Level 0/sec is the count of fully committed transactions started by the calling process that modify data stored in the database engine. [Dev Only]
IUserTrxCommit0PerSec_009_Help=User Transaction Commits to Level 0/sec is the count of fully committed transactions started by the calling process that access data stored in the database engine. [Dev Only]
IUserROTrxRollback0PerSec_009_Help=User Read Only Transaction Rollbacks to Level 0/sec is the count of aborted transactions started by the calling process that do not modify any data stored in the database engine. [Dev Only]
IUserRWTrxRollback0PerSec_009_Help=User Read/Write Transaction Rollbacks to Level 0/sec is the count of aborted transactions started by the calling process that modify data stored in the database engine. [Dev Only]
IUserTrxRollback0PerSec_009_Help=User Transaction Rollbacks to Level 0/sec is the count of aborted transactions started by the calling process that access data stored in the database engine. [Dev Only]
ISystemROTrxCommit0PerSec_009_Help=System Read Only Transaction Commits to Level 0/sec is the count of fully committed transactions started internally that do not modify any data stored in the database engine. [Dev Only]
ISystemRWTrxCommit0PerSec_009_Help=System Read/Write Transaction Commits to Level 0/sec is the count of fully committed transactions started internally that modify data stored in the database engine. [Dev Only]
ISystemTrxCommit0PerSec_009_Help=System Transaction Commits to Level 0/sec is the count of fully committed transactions started internally that access data stored in the database engine. [Dev Only]
ISystemROTrxRollback0PerSec_009_Help=System Read Only Transaction Rollbacks to Level 0/sec is the count of aborted transactions started internally that do not modify any data stored in the database engine. [Dev Only]
ISystemRWTrxRollback0PerSec_009_Help=System Read/Write Transaction Rollbacks to Level 0/sec is the count of aborted transactions started internally that modify data stored in the database engine. [Dev Only]
ISystemTrxRollback0PerSec_009_Help=System Transaction Rollbacks to Level 0/sec is the count of aborted transactions started internally that access data stored in the database engine. [Dev Only]
IIODatabaseFileExtensionAsyncConsumed_009_Help=Database Page Allocation File Extension Async Consumed/sec is the rate of page allocations from a database file that must be serviced by extending the database file, but which do not stall when doing doing so. [Dev Only]
IIODatabaseFileExtensionStall_009_Help=Database Page Allocation File Extension Stalls/sec is the rate of page allocations from a database file that must be serviced by extending the database file and which stall when doing so. [Dev Only]
ILGRecordPerSec_009_Help=Log Records/sec is the count of records written to the database log buffers per second. [Dev Only]
ILGCapacityFlushPerSec_009_Help=Log Buffer Capacity Flushes/sec is the count of times the database log buffers must be flushed per second because they are full. [Dev Only]
ILGCommitFlushPerSec_009_Help=Log Buffer Commit Flushes/sec is the count of times the database log buffers must be flushed per second because a transaction is fully committing its changes. [Dev Only]
ILGFlushPerSec_009_Help=Log Buffer Flushes/sec is the count of times the database log buffers must be flushed per second.
ILGWritePerSec_009_Help=Log Writes/sec is the number of times the log buffers are written to the log file(s) per second. If this number approaches the maximum write rate for the media holding the log file(s), the log may be a bottleneck.
ILGStallPerSec_009_Help=Log Record Stalls/sec is the number of log records that cannot be added to the log buffers per second because they are full. If this counter is non-zero most of the time, the log buffer size may be a bottleneck.
IVERcbucketAllocated_009_Help=Total number of version buckets allocated
IVERcbucketDeleteAllocated_009_Help=Total number of version buckets allocated for FlagDelete RCEs [Dev Only]
IVERBucketAllocWaitForVersionCleanup_009_Help=VER Bucket Allocations Wait For Version Cleanup/sec is the number of version bucket allocations that must first wait for version cleanup in an attempt to free used version buckets for re-use. [Dev Only]
IVERcbAverageBookmark_009_Help=Average length of bookmark in RCE [Dev Only]
IVERUnnecessaryCalls_009_Help=Number of times per second we look in the version store for a node whose version bit is set but which has no versions [Dev Only]
IVERAsyncCleanupDispatched_009_Help=Number of times per second a version store clean task is dispatched asynchronously to be performed [Dev Only]
IVERSyncCleanupDispatched_009_Help=Number of times per second a version store clean task is performed synchronously [Dev Only]
IVERCleanupDiscarded_009_Help=Number of times per second a version store clean task was discarded due to load concerns [Dev Only]
IVERCleanupFailed_009_Help=Number of times per second a dispatched version store cleanup task fails [Dev Only]
IRECInserts_009_Help=Record Inserts/sec is the rate at which records are being inserted into database tables. [Dev Only]
IRECDeletes_009_Help=Record Deletes/sec is the rate at which records in database tables are being flagged for deletion. [Dev Only]
IRECReplaces_009_Help=Record Deletes/sec is the rate at which records in database tables are being updated. [Dev Only]
IRECNoOpReplaces_009_Help=Record Unnecessary Replaces/sec is the rate at which updates to records in database tables are being discarded because the update did not actually modify the contents of the record. [Dev Only]
IRECRedundantReplaces_009_Help=Record Redundant Replaces/sec is the rate at which records in database tables are being updated with the exact same content of the original record. [Dev Only]
IRECEscrowUpdates_009_Help=Record Escrow-Updates/sec is the rate at which records in database tables are being escrow-updated. [Dev Only]
IRECIndexInserts_009_Help=Secondary Index Inserts/sec is the rate at which entries are being inserted into indexes of database tables. [Dev Only]
IRECIndexDeletes_009_Help=Secondary Index Deletes/sec is the rate at which entries in indexes of database tables are being flagged for deletion. [Dev Only]
IRECFalseIndexColumnUpdates_009_Help=False Index Column Updates/sec is the number of times per second an attempt was made to update an index because an update to at least one of the indexed columns was detected, only to discover that none of the indexed columns had actually changed (and therefore no index update was actually required). [Dev Only]
IRECFalseTupleIndexColumnUpdates_009_Help=False Tuple Index Column Updates/sec is the number of times per second an attempt was made to update a tuple index because an update to the tuple-indexed column was detected, only to discover that the column had not actually changed (and therefore no index update was actually required). [Dev Only]
IRECUpdateIntrinsicLV_009_Help=Record Intrinsic Long-Values Updated/sec is the rate at which intrinsic long-values are added to or replaced in records of database tables. [Dev Only]
IRECAddSeparateLV_009_Help=Record Separated Long-Values Added/sec is the rate at which separated long-values are normally added to records of database tables. [Dev Only]
IRECAddForcedSeparateLV_009_Help=Record Separated Long-Values Forced/sec is the rate at which separated long-values are added to records of a database table because they could not be accommodated in the record itself. [Dev Only]
IRECForceSeparateAllLV_009_Help=Record Separated Long-Values All Forced/sec is the rate at which all intrinsic long-values are separated out of a record of a database table in order to accommodate updates to the record. [Dev Only]
IRECRefAllSeparateLV_009_Help= Record Separated Long-Values Reference All/sec is the rate at which a reference is added for all the separated long-values associated with a record of a database table. [Dev Only]
IRECDerefAllSeparateLV_009_Help= Record Separated Long-Values Dereference All/sec is the rate at which a reference is removed for all the separated long-values associated with a record of a database table. [Dev Only]
ILVSeeks_009_Help=Separated Long-Value Seeks/sec is the rate at which seeks for a separated long-value in a database table are performed. [Dev Only]
ILVRetrieves_009_Help=Separated Long-Value Retrieves/sec is the rate at which retrievals of a separated long-value in a database table are performed. [Dev Only]
ILVCreates_009_Help=Separated Long-Value Creates/sec is the rate at which new separated long-values are added to a database table. [Dev Only]
ILVUpdates_009_Help=Separated Long-Value Updates/sec is the rate at which existing separated long-values in a database table are modified. [Dev Only]
ILVDeletes_009_Help=Separated Long-Value Deletes/sec is the rate at which separated long-values in a database table are flagged for deletion. [Dev Only]
ILVCopies_009_Help=Separated Long-Value Copies/sec is the rate at which existing separated long-values in a database table are copied. [Dev Only]
ILVChunkSeeks_009_Help=Separated Long-Value Chunk Seeks/sec is the rate at which seeks for a particular chunk of a separated long-value in a database table are performed. [Dev Only]
ILVChunkRetrieves_009_Help=Separated Long-Value Chunk Retrieves/sec is the rate at which retrievals of a chunk of a separated long-value in a database table are performed. [Dev Only]
ILVChunkAppends_009_Help=Separated Long-Value Chunk Appends/sec is the rate at which chunks are appended to separated long-values of database tables. [Dev Only]
ILVChunkReplaces_009_Help=Separated Long-Value Chunk Replaces/sec is the rate at which existing separated long-value chunks in a database table are replaced. [Dev Only]
ILVChunkDeletes_009_Help=Separated Long-Value Chunk Deletes/sec is the rate at which separated long-value chunks in a database table are flagged for deletion. [Dev Only]
ILVChunkCopies_009_Help=Separated Long-Value Chunk Copies/sec is the rate at which existing separated long-value chunks in a database table are copied. [Dev Only]
IBTAppendSplit_009_Help=B+ Tree Append Splits/sec is the count of times a page is appended to a database B+ Tree per second. [Dev Only]
IBTRightSplit_009_Help=B+ Tree Right Splits/sec is the count of times a page is split right in a database B+ Tree per second. [Dev Only]
IBTRightHotpointSplit_009_Help=B+ Tree Right Hotpoint Splits/sec is the count of times a page is split right in a database B+ Tree, but which is treated as an append at a local "hotpoint" in the B+ Tree per second. [Dev Only]
IBTVerticalSplit_009_Help=B+ Tree Vertical Splits/sec is the count of times a page is split vertically in a database B+ Tree per second. [Dev Only]
IBTSplit_009_Help=B+ Tree Splits/sec is the count of times a page is appended to or split in a database B+ Tree per second. [Dev Only]
IBTEmptyPageMerge_009_Help=B+ Tree Empty Page Merges/sec is the count of empty pages removed from a database B+ Tree per second. [Dev Only]
IBTRightMerge_009_Help=Right Merges/sec is the count of pages removed from a database B+ Tree per second by moving all its records to the next page to the right. [Dev Only]
IBTPartialMerge_009_Help=B+ Tree Partial Merges/sec is the count of pages where some of its records are moved to a page on the right in a database B+ Tree per second. [Dev Only]
IBTMerge_009_Help=B+ Tree Merges/sec is the count of pages merged in a database B+ Tree per second. [Dev Only]
IBTFailedSPCWriteLatch_009_Help=B+ Tree Failed Simple Page Cleanup Attempts/sec is the rate that attempts to reclaim deleted node space on a page are unsuccessful due to a conflict when attempting to write-latch the page. The cleanup is re-tried by locking the root of the B+ Tree. [Dev Only]
IBTSeekShortCircuit_009_Help=B+ Tree Seek Short Circuits/sec is the count of repeated seeks to the same record in a database B+ Tree that are saved by jumping directly to the cached physical location of that record per second. [Dev Only]
IBTUnnecessarySiblingLatch_009_Help=B+ Tree Unnecessary Sibling Latches/sec is the count of sibling pages latched during a database B+ Tree Delete in the hopes of performing a merge where a merge is not possible, making that latch unnecessary. [Dev Only]
IBTNext_009_Help=B+ Tree Move Nexts/sec is the count of times the database engine moves to the next record in a B+ Tree per second. [Dev Only]
IBTNextNonVisibleNodesSkipped_009_Help=B+ Tree Move Nexts (Non-Visible Nodes Skipped)/sec is the count of times the database engine skips non-visible records while attempting to move to the next visible record in a B+ Tree per second. [Dev Only]
IBTPrev_009_Help=B+ Tree Move Prevs/sec is the count of times the database engine moves to the previous record in a B+ Tree per second. [Dev Only]
IBTPrevNonVisibleNodesSkipped_009_Help=B+ Tree Move Prevs (Non-Visible Nodes Skipped)/sec is the count of times the database engine skips non-visible records while attempting to move to the previous visible record in a B+ Tree per second. [Dev Only]
IBTSeek_009_Help=B+ Tree Seeks/sec is the count of times a record is seeked to by a key in a database B+ Tree per second. [Dev Only]
IBTInsert_009_Help=B+ Tree Inserts/sec is the count of times a record is inserted in a database B+ Tree per second. [Dev Only]
IBTReplace_009_Help=B+ Tree Replaces/sec is the count of times a record is replaced in a database B+ Tree per second. [Dev Only]
IBTFlagDelete_009_Help=B+ Tree Flag Deletes/sec is the count of times a record is flag deleted in a database B+ Tree per second. [Dev Only]
IBTDelete_009_Help=B+ Tree Deletes/sec is the count of times a record is deleted in a database B+ Tree per second. [Dev Only]
IBTAppend_009_Help=B+ Tree Appends/sec is the count of times a record is appended to a database B+ Tree per second. [Dev Only]
ISPCreate_009_Help=B+ Tree Creates/sec is the number of B+ Trees and their corresponding space trees (if any) created per second. This can also be viewed as the number of FDP creates per second. [Dev Only]
ISPCreateCum_009_Help=B+ Tree Creates (Total) is the total number of B+ Trees and their corresponding space trees (if any) created. This can also be viewed as the total number of FDP creates. [Dev Only]
ISPDelete_009_Help=B+ Tree Destroys/sec is the number of B+ Trees and their corresponding space trees (if any) destroyed per second. This can also be viewed as the number of FDP destroys per second. [Dev Only]
ISPDeleteCum_009_Help=B+ Tree Destroys (Total) is the total number of B+ Trees and their corresponding space trees (if any) destroyed. This can also be viewed as the total number of FDP destroys. [Dev Only]
IBFPagesReadAsyncPerSec_009_Help=Database Pages Read Async/sec is the rate that pages are asynchronously read from the database file(s) into the database cache. [Dev Only]
IBFPagesReadSyncPerSec_009_Help=Database Pages Read Sync/sec is the rate that pages are synchronously read from the database file(s) into the database cache. [Dev Only]
IBFPagesWrittenPerSec_009_Help=Database Pages Written/sec is the rate that pages are written to the database file (s) from the database cache. [Dev Only]
IBFPagesTransferredPerSec_009_Help=Database Pages Transferred/sec is the rate that pages are transferred from the database file(s) to the database cache and vice versa. [Dev Only]
IBFPagesPreread_009_Help=Database Pages Preread/sec is the rate that pages are read in anticipation of future use from the database file(s) into the database cache. [Dev Only]
IBFCachedPagesPreread_009_Help=Database Cached Pages Preread/sec is the rate that pages are read in anticipation of future use from the database file(s) into the database cache that are already cached. This is non-ideal behavior that represents a waste of processing time. [Dev Only]
IBFPagesPrereadUntouched_009_Help=Database Pages Preread Untouched/sec is the rate that pages are read in anticipation of future use from the database file(s) into the database cache that were subsequently thrown out without being used. This is non-ideal behavior that represents a waste of I/O bandwidth and processing time . [Dev Only]
IBFPagesVersioned_009_Help=Database Pages Versioned / sec is the rate at which pages in the database cache are being copied into new pages in the cache for the purpose of being asynchronously written while the current version of that page in the database file is still being modified. This feature is primarily used to avoid cycles, branches, or long chains of flush order dependencies without requiring the pages involved to be synchronously written to disk. [Dev Only]
IBFPagesOrdinarilyWritten_009_Help=Database Pages Ordinarily Written/sec is the rate that pages are written to the database file (s) from the database cache in preparation for evicting them from the cache to make room for other data. [Dev Only]
IBFPagesAnomalouslyWritten_009_Help=Database Pages Anomalously Written/sec is the rate that pages are written to the database file (s) from the database cache before they would ordinarily be written. [Dev Only]
IBFPagesOpportunelyWritten_009_Help=Database Pages Opportunely Written/sec is the rate that pages are written to the database file (s) from the database cache because they happen to be near other pages that must be written. These additional writes are performed before they must happen in the hope that the total number of seeks required to write all the pages is reduced. [Dev Only]
IBFPagesRepeatedlyWritten_009_Help=Database Pages Repeatedly Written/sec is the rate that pages are written to the database file (s) from the database cache more than once in their lifetime in the cache. These page writes represent extra writes above the theoretical minimum and can therefore be considered overhead. [Dev Only]
IBFPagesIdlyWritten_009_Help=Database Pages Idly Written/sec is the rate that pages are written to the database file (s) from the database cache because there is low disk activity. [Dev Only]
IBFPagesCoalescedWritten_009_Help=Database Pages Coalesced Written/sec is the rate that pages are written to the database file (s) from the database cache coalesced with another page. [Dev Only]
IBFPagesCoalescedRead_009_Help=Database Pages Coalesced Read/sec is the rate that pages are read from the database file (s) to the database cache coalesced with another page. [Dev Only]
IBKReadIO_009_Help=Streaming Backup Pages Read/sec is the rate of database read operationsperformed for the purpose of streaming backups.
IOLDPageReferenced_009_Help=Online Defrag Pages Referenced/sec is the rate at which online defragmentation is touching database pages. [Dev Only]
IOLDPageRead_009_Help=Online Defrag Pages Read/sec is the rate of database read operations being performed by online defragmentation. [Dev Only]
IOLDPagePreread_009_Help=Online Defrag Pages Preread/sec is the rate at which database pages are read in anticipation of future use by online defragmentation. [Dev Only]
IOLDPageDirtied_009_Help=Online Defrag Pages Dirtied/sec is the rate at which online defragmentation is modifying clean database pages. [Dev Only]
IOLDPageRedirtied_009_Help=Online Defrag Pages Re-Dirtied/sec is the rate at which online defragmentation is modifying database pages that already contained modifications. [Dev Only]
IOLDLogRecord_009_Help=Online Defrag Log Records/sec is the rate at which online defragmentation is generating log records. [Dev Only]
IOLDLogBytes_009_Help=Online Defrag Average Log Bytes is the average size of the log records being generated by online defragmentation. [Dev only]
IOLDLogRecordsTotal1_009_Help=No text
IDBTASKPageReferenced_009_Help=Database Tasks Pages Referenced/sec is the rate at which background database tasks are touching database pages. [Dev Only]
IDBTASKPageRead_009_Help=Database Tasks Pages Read/sec is the rate of database read operations being performed by background database tasks. [Dev Only]
IDBTASKPagePreread_009_Help=Database Tasks Pages Preread/sec is the rate at which database pages are read in anticipation of future use by background database tasks. [Dev Only]
IDBTASKPageDirtied_009_Help=Database Tasks Pages Dirtied/sec is the rate at which background database tasks are modifying clean database pages. [Dev Only]
IDBTASKPageRedirtied_009_Help=Database Tasks Pages Re-Dirtied/sec is the rate at which background databases tasks are modifying database pages that already contained modifications. [Dev Only]
IDBTASKLogRecord_009_Help=Database Tasks Log Records/sec is the rate at which background database tasks are generating log records. [Dev Only]
IDBTASKLogBytes_009_Help=Database Tasks Average Log Bytes is the average size of the log records being generated by background database tasks. [Dev only]
IDBTASKLogRecordsTotal1_009_Help=No text
IOSFileDbReadIO_009_Help=I/O Database Reads/sec is the rate of database read operations completed.
IOSFileDbReadIOTotalTicks_009_Help=I/O Database Reads Average Latency is the average length of time, in milliseconds, per database read operation.
IOSFileDbReadIOTotal1_009_Help=No text
IOSFileDbReadIOTotalBytes_009_Help=I/O Database Reads Average Bytes is the average number of bytes transferred per database read operation. [Dev Only]
IOSFileDbReadIOTotal2_009_Help=No text
IOSFileDbReadIOInHeap_009_Help=I/O Database Reads In Heap is the number of database read operations queued in the database engine's I/O heap and waiting to be issued. [Dev Only]
IOSFileDbReadIOAsyncPending_009_Help=I/O Database Reads Async Pending is the number of database read operations asynchronously pending completion. [Dev Only]
IOSFileDbReadIOAbnormalLatency_009_Help=I/O Database Reads Abnormal Latency/sec is the rate of database read operations that take an abnormally long length of time (default is 1 minute) to be serviced by the OS. [Dev Only]
IOSFileLogReadIO_009_Help=I/O Log Reads/sec is the rate of logfile read operations completed.
IOSFileLogReadIOTotalTicks_009_Help=I/O Log Reads Average Latency is the average length of time, in milliseconds, per logfile read operation. [Dev Only]
IOSFileLogReadIOTotal1_009_Help=No text
IOSFileLogReadIOTotalBytes_009_Help=I/O Log Reads Average Bytes is the average number of bytes transferred per logfile read operation. [Dev Only]
IOSFileLogReadIOTotal2_009_Help=No text
IOSFileLogReadIOInHeap_009_Help=I/O Log Reads In Heap is the number of logfile read operations queued in the database engine's I/O heap and waiting to be issued. [Dev Only]
IOSFileLogReadIOAsyncPending_009_Help=I/O Log Reads Async Pending is the number of logfile read operations asynchronously pending completion. [Dev Only]
IOSFileLogReadIOAbnormalLatency_009_Help=I/O Log Reads Abnormal Latency/sec is the rate of logfile read operations that take an abnormally long length of time (default is 1 minute) to be serviced by the OS. [Dev Only]
IOSFileDbWriteIO_009_Help=I/O Database Writes/sec is the rate of database write operations completed.
IOSFileDbWriteIOTotalTicks_009_Help=I/O Database Writes Average Latency is the average length of time, in milliseconds, per database write operation.
IOSFileDbWriteIOTotal1_009_Help=No text
IOSFileDbWriteIOTotalBytes_009_Help=I/O Database Writes Average Bytes is the average number of bytes transferred per database write operation. [Dev Only]
IOSFileDbWriteIOTotal2_009_Help=No text
IOSFileDbWriteIOInHeap_009_Help=I/O Database Writes In Heap is the number of database write operations queued in the database engine's I/O heap and waiting to be issued. [Dev Only]
IOSFileDbWriteIOAsyncPending_009_Help=I/O Database Writes Async Pending is the number of database write operations asynchronously pending completion. [Dev Only]
IOSFileDbWriteIOAbnormalLatency_009_Help=I/O Database Writes Abnormal Latency/sec is the rate of database write operations that take an abnormally long length of time (default is 1 minute) to be serviced by the OS. [Dev Only]
IOSFileLogWriteIO_009_Help=I/O Log Writes/sec is the rate of logfile write operations completed.
IOSFileLogWriteIOTotalTicks_009_Help=I/O Log Writes Average Latency is the average length of time, in milliseconds, per logfile write operation.
IOSFileLogWriteIOTotal1_009_Help=No text
IOSFileLogWriteIOTotalBytes_009_Help=I/O Log Writes Average Bytes is the average number of bytes transferred per logfile write operation. [Dev Only]
IOSFileLogWriteIOTotal2_009_Help=No text
IOSFileLogWriteIOInHeap_009_Help=I/O Log Writes In Heap is the number of logfile write operations queued in the database engine's I/O heap and waiting to be issued. [Dev Only]
IOSFileLogWriteIOAsyncPending_009_Help=I/O Log Writes Async Pending is the number of logfile write operations asynchronously pending completion. [Dev Only]
IOSFileLogWriteIOAbnormalLatency_009_Help=I/O Log Writes Abnormal Latency/sec is the rate of logfile write operations that take an abnormally long length of time (default is 1 minute) to be serviced by the OS. [Dev Only]
ESE_000_Help=Database provides performance statistics for each process using the ESE high performance embedded database management system.
TableClass_000_Help=Statistics for the ESE high performance embedded database management system by Table Class
Instances_000_Help=Instances in this process
PagesConvertedSec_000_Help=Pages Converted/sec is the count of times per second a database page is converted from an older database format
PagesConvertedTotal_000_Help=Pages Converted is the count of database pages that have been converted from an older format
RecordsConvertedSec_000_Help=Records Converted/sec is the count of times per second a database record is converted from an older database format
RecordsConvertedTotal_000_Help=Records Converted is the count of database records that have been converted from an older format
OSHeapAllocPerSec_000_Help=Heap Allocs/sec is the number of memory allocations from the MP Heaps per second. [Dev Only]
OSHeapFreePerSec_000_Help=Heap Frees/sec is the number of memory frees to the MP Heaps per second. [Dev Only]
OSHeapAlloc_000_Help=Heap Allocations is the current number of memory allocations in the MP Heaps. [Dev Only]
OSHeapBytesAlloc_000_Help=Heap Bytes Allocated is the size of all memory allocations in the MP Heaps discounting heap managemnt overhead. [Dev Only]
OSPageBytesReserved_000_Help=Page Bytes Reserved is the size of all explicitly reserved virtual address space. [Dev Only]
OSPageBytesCommitted_000_Help=Page Bytes Committed is the size of all explicitly committed virtual memory backing store (page file and physical memory). [Dev Only]
FCBAsyncScan_000_Help=FCB Asynchronous Scan/sec is the number of cached schema records (FCBs) scanned during asynchronous schema record cleanup. These records are scanned to age out older schema definitions. [Dev Only]
FCBAsyncPurge_000_Help=FCB Asynchronous Purge/sec is the number of cached schema records (FCBs) purged during asynchronous schema record cleanup. These records are purged to age out older schema definitions. [Dev Only]
FCBAsyncThresholdScan_000_Help=FCB Asynchronous Threshold-Scan/sec is the number of cached schema records (FCBs) scanned during asynchronous schema record cleanup. Cleanup was triggered by a large number of schema records above the preferred limit. These records are aggressively scanned to age out older schema definitions. [Dev Only]
FCBAsyncThresholdPurge_000_Help=FCB Asynchronous Threshold-Purge/sec is the number of cached schema records (FCBs) purged during asynchronous schema record cleanup. Cleanup was triggered by a large number of schema records above the preferred limit. These records are aggressively purged to age out older schema definitions. [Dev Only]
FCBAsyncPurgeConflict_000_Help=FCB Asynchronous Purge Conflicts/sec is the number of failed purge attempts on cached schema records (FCBs) during asynchronous schema record cleanup. The purge operation failed because exclusive ownership of the schema record could not be obtained. [Dev Only]
FCBSyncPurge_000_Help=FCB Synchronous Purge/sec is the number of cached schema records (FCBs) being synchronously purged each second. [Dev Only]
FCBSyncPurgeStalls_000_Help=FCB Synchronous Purge Stalls/sec is the number of stalls encountered while waiting for exclusive ownership of cached schema records (FCBs) in order to synchronously purge them. [Dev Only]
FCBAllocWaitForVersionCleanup_000_Help=FCB Allocations Wait For Version Cleanup/sec is the number FCB allocations that must first wait for version cleanup in an attempt to free used FCBs for re-use. [Dev Only]
FCBPurgeOnClose_000_Help=FCB Purge On Cursor Close/sec is the number of cached schema records (FCBs) being synchronously purged when the cursor is closed (instead of leaving the schema record cached) each second. [Dev Only]
FCBCacheHits_000_Help=FCB Cache % Hit is the percentage of schema records (FCBs) opened directly from the schema record cache. No file operations were required. [Dev Only]
FCBCacheRequests_000_Help=No text
FCBCacheStalls_000_Help=FCB Cache Stalls/sec is the number of stalls encountered while waiting for exclusive ownership of cached schema records (FCBs) in order to update their reference count. [Dev Only]
FCBCacheMax_000_Help=FCB Cache Maximum is the absolute maximum number of the schema records (FCBs) that can exist in the cache. [Dev Only]
FCBCachePreferred_000_Help=FCB Cache Preferred is the preferred maximum number of the schema records (FCBs) that should exist in the cache. [Dev Only]
FCBCacheAlloc_000_Help=FCB Cache Allocated is the number of cached schema records (FCBs) currently allocated and in use. [Dev Only]
FCBCacheAllocAvail_000_Help=FCB Cache Available is the number of cached schema records (FCBs) currently allocated but not in use. These records will be used and/or purged as required. [Dev Only]
PIBInUse_000_Help=Sessions In Use is the number of database sessions currently open for use by client threads. [Dev Only]
PIBUsed_000_Help=Sessions % Used is the percentage of database sessions currently open for use by client threads. [Dev Only]
PIBTotal_000_Help=No text
TableOpenCacheHitRate_000_Help=Table Open Cache % Hit is the percentage of database tables opened using cached schema information. If this percentage is too low, the table cache size may be too small.
TableOpenCacheRequests_000_Help=No text
TableOpenCacheHitsPerSec_000_Help=Table Open Cache Hits/sec is the number of database tables opened using cached schema information per second. If this rate is too low, the table cache size may be too small.
TableOpenCacheMissesPerSec_000_Help=Table Open Cache Misses/sec is the number of database tables opened without using cached schema information per second. If this rate is too high, the table cache size may be too small.
TableOpensPerSec_000_Help=Table Opens/sec is the number of database tables opened per second.
LGBytesWrittenPerSec_000_Help=Log Bytes Write per second is the rate bytes are written to the log.
LGBufferBytesUsed_000_Help=Log Buffer Bytes Used is the amount of bytes in the log buffers that have not yet been flushed to the logs. [Dev only]
LGBufferBytesFree_000_Help=Log Buffer Bytes Free is the amount of free space available in the log buffers. [Dev only]
LGUsersWaiting_000_Help=Log Threads Waiting is the number of threads waiting for their data to be written to the log in order to complete an update of the database. If this number is too high, the log may be a bottleneck.
LGCheckpointDepth_000_Help=Log Checkpoint Depth represents the amount of work, in bytes, that will need to be redone or undone to the database file(s) if the process crashes. [Dev Only]
LGLogGenerationCheckpointDepth_000_Help=Log Generation Checkpoint Depth represents the amount of work, in count of log files, that will need to be redone or undone to the database file(s) if the process crashes. [Dev Only]
UserROTrxCommit0PerSec_000_Help=User Read Only Transaction Commits to Level 0/sec is the count of fully committed transactions started by the calling process that do not modify any data stored in the database engine. [Dev Only]
UserRWTrxCommit0PerSec_000_Help=User Read/Write Transaction Commits to Level 0/sec is the count of fully committed transactions started by the calling process that modify data stored in the database engine. [Dev Only]
UserTrxCommit0PerSec_000_Help=User Transaction Commits to Level 0/sec is the count of fully committed transactions started by the calling process that access data stored in the database engine. [Dev Only]
UserROTrxRollback0PerSec_000_Help=User Read Only Transaction Rollbacks to Level 0/sec is the count of aborted transactions started by the calling process that do not modify any data stored in the database engine. [Dev Only]
UserRWTrxRollback0PerSec_000_Help=User Read/Write Transaction Rollbacks to Level 0/sec is the count of aborted transactions started by the calling process that modify data stored in the database engine. [Dev Only]
UserTrxRollback0PerSec_000_Help=User Transaction Rollbacks to Level 0/sec is the count of aborted transactions started by the calling process that access data stored in the database engine. [Dev Only]
SystemROTrxCommit0PerSec_000_Help=System Read Only Transaction Commits to Level 0/sec is the count of fully committed transactions started internally that do not modify any data stored in the database engine. [Dev Only]
SystemRWTrxCommit0PerSec_000_Help=System Read/Write Transaction Commits to Level 0/sec is the count of fully committed transactions started internally that modify data stored in the database engine. [Dev Only]
SystemTrxCommit0PerSec_000_Help=System Transaction Commits to Level 0/sec is the count of fully committed transactions started internally that access data stored in the database engine. [Dev Only]
SystemROTrxRollback0PerSec_000_Help=System Read Only Transaction Rollbacks to Level 0/sec is the count of aborted transactions started internally that do not modify any data stored in the database engine. [Dev Only]
SystemRWTrxRollback0PerSec_000_Help=System Read/Write Transaction Rollbacks to Level 0/sec is the count of aborted transactions started internally that modify data stored in the database engine. [Dev Only]
SystemTrxRollback0PerSec_000_Help=System Transaction Rollbacks to Level 0/sec is the count of aborted transactions started internally that access data stored in the database engine. [Dev Only]
IODatabaseFileExtensionAsyncConsumed_000_Help=Database Page Allocation File Extension Async Consumed/sec is the rate of page allocations from a database file that must be serviced by extending the database file, but which do not stall when doing doing so. [Dev Only]
IODatabaseFileExtensionStall_000_Help=Database Page Allocation File Extension Stalls/sec is the rate of page allocations from a database file that must be serviced by extending the database file and which stall when doing so. [Dev Only]
LGRecordPerSec_000_Help=Log Records/sec is the count of records written to the database log buffers per second. [Dev Only]
LGCapacityFlushPerSec_000_Help=Log Buffer Capacity Flushes/sec is the count of times the database log buffers must be flushed per second because they are full. [Dev Only]
LGCommitFlushPerSec_000_Help=Log Buffer Commit Flushes/sec is the count of times the database log buffers must be flushed per second because a transaction is fully committing its changes. [Dev Only]
LGFlushPerSec_000_Help=Log Buffer Flushes/sec is the count of times the database log buffers must be flushed per second.
LGWritePerSec_000_Help=Log Writes/sec is the number of times the log buffers are written to the log file(s) per second. If this number approaches the maximum write rate for the media holding the log file(s), the log may be a bottleneck.
LGStallPerSec_000_Help=Log Record Stalls/sec is the number of log records that cannot be added to the log buffers per second because they are full. If this counter is non-zero most of the time, the log buffer size may be a bottleneck.
VERcbucketAllocated_000_Help=Total number of version buckets allocated
VERcbucketDeleteAllocated_000_Help=Total number of version buckets allocated for FlagDelete RCEs [Dev Only]
VERBucketAllocWaitForVersionCleanup_000_Help=VER Bucket Allocations Wait For Version Cleanup/sec is the number of version bucket allocations that must first wait for version cleanup in an attempt to free used version buckets for re-use. [Dev Only]
VERcbAverageBookmark_000_Help=Average length of bookmark in RCE [Dev Only]
VERUnnecessaryCalls_000_Help=Number of times per second we look in the version store for a node whose version bit is set but which has no versions [Dev Only]
VERAsyncCleanupTasksDispatched_000_Help=Number of times per second a version store clean task is dispatched asynchronously to be performed [Dev Only]
VERSyncCleanupTasksDispatched_000_Help=Number of times per second a version store clean task is performed synchronously [Dev Only]
VERCleanupTasksDiscarded_000_Help=Number of times per second a version store clean task was discarded due to load concerns [Dev Only]
VERCleanupTasksFailed_000_Help=Number of times per second a dispatched version store cleanup task fails [Dev Only]
RECInserts_000_Help=Record Inserts/sec is the rate at which records are being inserted into database tables. [Dev Only]
RECDeletes_000_Help=Record Deletes/sec is the rate at which records in database tables are being flagged for deletion. [Dev Only]
RECReplaces_000_Help=Record Deletes/sec is the rate at which records in database tables are being updated. [Dev Only]
RECNoOpReplaces_000_Help=Record Unnecessary Replaces/sec is the rate at which updates to records in database tables are being discarded because the update did not actually modify the contents of the record. [Dev Only]
RECRedundantReplaces_000_Help=Record Redundant Replaces/sec is the rate at which records in database tables are being updated with the exact same content of the original record. [Dev Only]
RECEscrowUpdates_000_Help=Record Escrow-Updates/sec is the rate at which records in database tables are being escrow-updated. [Dev Only]
RECIndexInserts_000_Help=Secondary Index Inserts/sec is the rate at which entries are being inserted into indexes of database tables. [Dev Only]
RECIndexDeletes_000_Help=Secondary Index Deletes/sec is the rate at which entries in indexes of database tables are being flagged for deletion. [Dev Only]
RECFalseIndexColumnUpdates_000_Help=False Index Column Updates/sec is the number of times per second an attempt was made to update an index because an update to at least one of the indexed columns was detected, only to discover that none of the indexed columns had actually changed (and therefore no index update was actually required). [Dev Only]
RECFalseTupleIndexColumnUpdates_000_Help=False Tuple Index Column Updates/sec is the number of times per second an attempt was made to update a tuple index because an update to the tuple-indexed column was detected, only to discover that the column had not actually changed (and therefore no index update was actually required). [Dev Only]
RECUpdateIntrinsicLV_000_Help=Record Intrinsic Long-Values Updated/sec is the rate at which intrinsic long-values are added to or replaced in records of database tables. [Dev Only]
RECAddSeparateLV_000_Help=Record Separated Long-Values Added/sec is the rate at which separated long-values are normally added to records of database tables. [Dev Only]
RECAddForcedSeparateLV_000_Help=Record Separated Long-Values Forced/sec is the rate at which separated long-values are added to records of a database table because they could not be accommodated in the record itself. [Dev Only]
RECForceSeparateAllLV_000_Help=Record Separated Long-Values All Forced/sec is the rate at which all intrinsic long-values are separated out of a record of a database table in order to accommodate updates to the record. [Dev Only]
RECRefAllSeparateLV_000_Help= Record Separated Long-Values Reference All/sec is the rate at which a reference is added for all the separated long-values associated with a record of a database table. [Dev Only]
RECDerefAllSeparateLV_000_Help= Record Separated Long-Values Dereference All/sec is the rate at which a reference is removed for all the separated long-values associated with a record of a database table. [Dev Only]
LVSeeks_000_Help=Separated Long-Value Seeks/sec is the rate at which seeks for a separated long-value in a database table are performed. [Dev Only]
LVRetrieves_000_Help=Separated Long-Value Retrieves/sec is the rate at which retrievals of a separated long-value in a database table are performed. [Dev Only]
LVCreates_000_Help=Separated Long-Value Creates/sec is the rate at which new separated long-values are added to a database table. [Dev Only]
LVUpdates_000_Help=Separated Long-Value Updates/sec is the rate at which existing separated long-values in a database table are modified. [Dev Only]
LVDeletes_000_Help=Separated Long-Value Deletes/sec is the rate at which separated long-values in a database table are flagged for deletion. [Dev Only]
LVCopies_000_Help=Separated Long-Value Copies/sec is the rate at which existing separated long-values in a database table are copied. [Dev Only]
LVChunkSeeks_000_Help=Separated Long-Value Chunk Seeks/sec is the rate at which seeks for a particular chunk of a separated long-value in a database table are performed. [Dev Only]
LVChunkRetrieves_000_Help=Separated Long-Value Chunk Retrieves/sec is the rate at which retrievals of a chunk of a separated long-value in a database table are performed. [Dev Only]
LVChunkAppends_000_Help=Separated Long-Value Chunk Appends/sec is the rate at which chunks are appended to separated long-values of database tables. [Dev Only]
LVChunkReplaces_000_Help=Separated Long-Value Chunk Replaces/sec is the rate at which existing separated long-value chunks in a database table are replaced. [Dev Only]
LVChunkDeletes_000_Help=Separated Long-Value Chunk Deletes/sec is the rate at which separated long-value chunks in a database table are flagged for deletion. [Dev Only]
LVChunkCopies_000_Help=Separated Long-Value Chunk Copies/sec is the rate at which existing separated long-value chunks in a database table are copied. [Dev Only]
BTAppendSplit_000_Help=B+ Tree Append Splits/sec is the count of times a page is appended to a database B+ Tree per second. [Dev Only]
BTRightSplit_000_Help=B+ Tree Right Splits/sec is the count of times a page is split right in a database B+ Tree per second. [Dev Only]
BTRightHotpointSplit_000_Help=B+ Tree Right Hotpoint Splits/sec is the count of times a page is split right in a database B+ Tree, but which is treated as an append at a local "hotpoint" in the B+ Tree per second. [Dev Only]
BTVerticalSplit_000_Help=B+ Tree Vertical Splits/sec is the count of times a page is split vertically in a database B+ Tree per second. [Dev Only]
BTSplit_000_Help=B+ Tree Splits/sec is the count of times a page is appended to or split in a database B+ Tree per second. [Dev Only]
BTEmptyPageMerge_000_Help=B+ Tree Empty Page Merges/sec is the count of empty pages removed from a database B+ Tree per second. [Dev Only]
BTRightMerge_000_Help=Right Merges/sec is the count of pages removed from a database B+ Tree per second by moving all its records to the next page to the right. [Dev Only]
BTPartialMerge_000_Help=B+ Tree Partial Merges/sec is the count of pages where some of its records are moved to a page on the right in a database B+ Tree per second. [Dev Only]
BTMerge_000_Help=B+ Tree Merges/sec is the count of pages merged in a database B+ Tree per second. [Dev Only]
BTFailedSPCWriteLatch_000_Help=B+ Tree Failed Simple Page Cleanup Attempts/sec is the rate that attempts to reclaim deleted node space on a page are unsuccessful due to a conflict when attempting to write-latch the page. The cleanup is re-tried by locking the root of the B+ Tree. [Dev Only]
BTSeekShortCircuit_000_Help=B+ Tree Seek Short Circuits/sec is the count of repeated seeks to the same record in a database B+ Tree that are saved by jumping directly to the cached physical location of that record per second. [Dev Only]
BTUnnecessarySiblingLatch_000_Help=B+ Tree Unnecessary Sibling Latches/sec is the count of sibling pages latched during a database B+ Tree Delete in the hopes of performing a merge where a merge is not possible, making that latch unnecessary. [Dev Only]
BTNext_000_Help=B+ Tree Move Nexts/sec is the count of times the database engine moves to the next record in a B+ Tree per second. [Dev Only]
BTNextNonVisibleNodesSkipped_000_Help=B+ Tree Move Nexts (Non-Visible Nodes Skipped)/sec is the count of times the database engine skips non-visible records while attempting to move to the next visible record in a B+ Tree per second. [Dev Only]
BTPrev_000_Help=B+ Tree Move Prevs/sec is the count of times the database engine moves to the previous record in a B+ Tree per second. [Dev Only]
BTPrevNonVisibleNodesSkipped_000_Help=B+ Tree Move Prevs (Non-Visible Nodes Skipped)/sec is the count of times the database engine skips non-visible records while attempting to move to the previous visible record in a B+ Tree per second. [Dev Only]
BTSeek_000_Help=B+ Tree Seeks/sec is the count of times a record is seeked to by a key in a database B+ Tree per second. [Dev Only]
BTInsert_000_Help=B+ Tree Inserts/sec is the count of times a record is inserted in a database B+ Tree per second. [Dev Only]
BTReplace_000_Help=B+ Tree Replaces/sec is the count of times a record is replaced in a database B+ Tree per second. [Dev Only]
BTFlagDelete_000_Help=B+ Tree Flag Deletes/sec is the count of times a record is flag deleted in a database B+ Tree per second. [Dev Only]
BTDelete_000_Help=B+ Tree Deletes/sec is the count of times a record is deleted in a database B+ Tree per second. [Dev Only]
BTAppend_000_Help=B+ Tree Appends/sec is the count of times a record is appended to a database B+ Tree per second. [Dev Only]
SPCreate_000_Help=B+ Tree Creates/sec is the number of B+ Trees and their corresponding space trees (if any) created per second. This can also be viewed as the number of FDP creates per second. [Dev Only]
SPCreateCum_000_Help=B+ Tree Creates (Total) is the total number of B+ Trees and their corresponding space trees (if any) created. This can also be viewed as the total number of FDP creates. [Dev Only]
SPDelete_000_Help=B+ Tree Destroys/sec is the number of B+ Trees and their corresponding space trees (if any) destroyed per second. This can also be viewed as the number of FDP destroys per second. [Dev Only]
SPDeleteCum_000_Help=B+ Tree Destroys (Total) is the total number of B+ Trees and their corresponding space trees (if any) destroyed. This can also be viewed as the total number of FDP destroys. [Dev Only]
BFCacheHits_000_Help=Database Cache % Hit is the percentage of database file page requests that were fulfilled by the database cache without causing a file operation. If this percentage is too low, the database cache size may be too small.
BFCacheRequests_000_Help=No text
BFPctClean_000_Help=Database Cache % Clean is the percentage of the database cache that does not contain modified data. [Dev Only]
BFTotalBuffers2_000_Help=No text
BFPagesReadAsyncPerSec_000_Help=Database Pages Read Async/sec is the rate that pages are asynchronously read from the database file(s) into the database cache. [Dev Only]
BFPagesReadSyncPerSec_000_Help=Database Pages Read Sync/sec is the rate that pages are synchronously read from the database file(s) into the database cache. [Dev Only]
BFPagesWrittenPerSec_000_Help=Database Pages Written/sec is the rate that pages are written to the database file (s) from the database cache. [Dev Only]
BFPagesTransferredPerSec_000_Help=Database Pages Transferred/sec is the rate that pages are transferred from the database file(s) to the database cache and vice versa. [Dev Only]
BFLatch_000_Help=Database Page Latches/sec is the rate that database pages are latched for access to their data. [Dev Only]
BFFastLatch_000_Help=Database Page Fast Latches/sec is the rate that database pages are latched for access to their data using a hint to tell the cache manager where that page might be in memory. [Dev Only]
BFBadLatchHint_000_Help=Database Page Bad Latch Hints/sec is the rate that incorrect hints to the location of a given page in the cache are given to the cache manager. These hints are used to perform fast latches. [Dev Only]
BFPctFastLatch_000_Help=Database Cache % Fast Latch is the percentage of database pages latched for access to their data using a hint to tell the cache manager where that page might be in memory. Ideally, this percentage should match Database Cache % Hit. [Dev Only]
BFTotalLatches_000_Help=No text
BFLatchConflict_000_Help=Database Page Latch Conflicts/sec is the rate that users latching a database page for access to its data fail due to a conflicting latch owned on that same page by another user. [Dev Only]
BFLatchStall_000_Help=Database Page Latch Stalls/sec is the rate that users latching a database page for access to its data must wait for another user to release a latch on that same page. [Dev Only]
BFPctAvail_000_Help=Database Cache % Available is the percentage of the database cache that can be allocated to cache database pages that are newly created or read in from the database file(s). [Dev Only]
BFTotalBuffers3_000_Help=No text
BFCacheFault_000_Help=Database Page Faults/sec is the rate that database file page requests require the database cache manager to allocate a new page from the database cache.
BFCacheEvict_000_Help=Database Page Evictions/sec is the rate that database file page requests that require the database cache manager to allocate a new page from the database cache force another database page out of the cache. The eviction count is charged when the page is allocated and not when the previous owner of that page was actually evicted from the cache. If this rate is too high, the database cache size may be too small.
BFAvailStallsPerSec_000_Help=Database Page Fault Stalls/sec is the rate of page faults that cannot be serviced because there are no pages available for allocation from the database cache. If this counter is non-zero most of the time, the clean threshold may be too low.
BFCacheSizeMB_000_Help=Database Cache Size (MB) is the amount of system memory (in MegaBytes) used by the database cache manager to hold commonly used information from the database file(s) to prevent file operations. If the database cache size seems to be too small for optimal performance and there is very little available memory on the system (see Memory/Available Bytes), adding more memory to the system may increase performance. If there is a lot of available memory on the system and the database cache size is not growing beyond a certain point, the database cache size may be capped at an artificially low limit. Increasing this limit may increase performance.
BFCacheSize_000_Help=Database Cache Size is the amount of system memory used by the database cache manager to hold commonly used information from the database file(s) to prevent file operations. If the database cache size seems to be too small for optimal performance and there is very little available memory on the system (see Memory/Available Bytes), adding more memory to the system may increase performance. If there is a lot of available memory on the system and the database cache size is not growing beyond a certain point, the database cache size may be capped at an artificially low limit. Increasing this limit may increase performance.
BFCacheSizeMin_000_Help=Database Cache Size Min is the minimum amount of system memory configured for use by the database cache manager to hold commonly used information from the database file(s) to prevent file operations. [Dev Only]
BFCacheSizeMax_000_Help=Database Cache Size Max is the maximum amount of system memory configured for use by the database cache manager to hold commonly used information from the database file(s) to prevent file operations. [Dev Only]
BFPctStartFlushThreshold_000_Help=Database Cache % Available Min is the minimum percentage of the database cache that is kept to be allocated to cache database pages that are newly created or read in from the database file(s). If the percentage of available pages drops below this minimum, pages are thrown out of the database cache until the maximum percentage of available pages is reached. This percentage should be set as low as possible without causing the actual percentage to drop to zero, causing cache fault stalls. [Dev Only]
BFTotalBuffers4_000_Help=No text
BFPctStopFlushThreshold_000_Help=Database Cache % Available Max is the maximum percentage of the database cache that is kept to be allocated to cache database pages that are newly created or read in from the database file(s). This percentage should be set as low as possible but far enough above the minimum percentage so that efficient production of availible pages is possible. [Dev Only]
BFTotalBuffers5_000_Help=No text
BFPagesPreread_000_Help=Database Pages Preread/sec is the rate that pages are read in anticipation of future use from the database file(s) into the database cache. [Dev Only]
BFCachedPagesPreread_000_Help=Database Cached Pages Preread/sec is the rate that pages are read in anticipation of future use from the database file(s) into the database cache that are already cached. This is non-ideal behavior that represents a waste of processing time. [Dev Only]
BFPagesPrereadUntouched_000_Help=Database Pages Preread Untouched/sec is the rate that pages are read in anticipation of future use from the database file(s) into the database cache that were subsequently thrown out without being used. This is non-ideal behavior that represents a waste of I/O bandwidth and processing time . [Dev Only]
BFPagesVersioned_000_Help=Database Pages Versioned / sec is the rate at which pages in the database cache are being copied into new pages in the cache for the purpose of being asynchronously written while the current version of that page in the database file is still being modified. This feature is primarily used to avoid cycles, branches, or long chains of flush order dependencies without requiring the pages involved to be synchronously written to disk. [Dev Only]
BFPctVersioned_000_Help=Database Cache % Versioned is the percentage of the database cache that contains older versions of currently cached pages that have not yet been written to disk and thrown out of the cache. [Dev Only]
BFTotalBuffers6_000_Help=No text
BFPagesOrdinarilyWritten_000_Help=Database Pages Ordinarily Written/sec is the rate that pages are written to the database file (s) from the database cache in preparation for evicting them from the cache to make room for other data. [Dev Only]
BFPagesAnomalouslyWritten_000_Help=Database Pages Anomalously Written/sec is the rate that pages are written to the database file (s) from the database cache before they would ordinarily be written. [Dev Only]
BFPagesOpportunelyWritten_000_Help=Database Pages Opportunely Written/sec is the rate that pages are written to the database file (s) from the database cache because they happen to be near other pages that must be written. These additional writes are performed before they must happen in the hope that the total number of seeks required to write all the pages is reduced. [Dev Only]
BFPagesRepeatedlyWritten_000_Help=Database Pages Repeatedly Written/sec is the rate that pages are written to the database file (s) from the database cache more than once in their lifetime in the cache. These page writes represent extra writes above the theoretical minimum and can therefore be considered overhead. [Dev Only]
BFPagesIdlyWritten_000_Help=Database Pages Idly Written/sec is the rate that pages are written to the database file (s) from the database cache because there is low disk activity. [Dev Only]
BFPagesCoalescedWritten_000_Help=Database Pages Coalesced Written/sec is the rate that pages are written to the database file (s) from the database cache coalesced with another page. [Dev Only]
BFPagesCoalescedRead_000_Help=Database Pages Coalesced Read/sec is the rate that pages are read from the database file (s) to the database cache coalesced with another page. [Dev Only]
BFPageHistory_000_Help=Database Page History Records is the current number of database page access history records retained for supporting the LRU-K page replacment algorithm. [Dev Only]
BFPageHistoryHits_000_Help=Database Page History % Hit is the percentage of database page access history record lookups that were successful. [Dev Only]
BFPageHistoryReqs_000_Help=No text
BFPageScanned_000_Help=Database Page Scans/sec is the rate at which database pages are considered for eviction from the database page cache. [Dev Only]
BFPageScannedOutOfOrder_000_Help=Database Page Scans Out-of-order/sec is the rate at which database pages are considered for eviction from the database page cache in a priority counter to the page replacement algorithm. [Dev Only]
BFPageScannedTotal_000_Help=No text
BKReadIO_000_Help=Streaming Backup Pages Read/sec is the rate of database read operations performed for the purpose of streaming backups. [Dev Only]
OLDPageReferenced_000_Help=Online Defrag Pages Referenced/sec is the rate at which online defragmentation is touching database pages. [Dev Only]
OLDPageRead_000_Help=Online Defrag Pages Read/sec is the rate of database read operations being performed by online defragmentation. [Dev Only]
OLDPagePreread_000_Help=Online Defrag Pages Preread/sec is the rate at which database pages are read in anticipation of future use by online defragmentation. [Dev Only]
OLDPageDirtied_000_Help=Online Defrag Pages Dirtied/sec is the rate at which online defragmentation is modifying clean database pages. [Dev Only]
OLDPageRedirtied_000_Help=Online Defrag Pages Re-Dirtied/sec is the rate at which online defragmentation is modifying database pages that already contained modifications. [Dev Only]
OLDLogRecord_000_Help=Online Defrag Log Records/sec is the rate at which online defragmentation is generating log records. [Dev Only]
OLDLogBytes_000_Help=Online Defrag Average Log Bytes is the average size of the log records being generated by online defragmentation. [Dev only]
OLDLogRecordsTotal1_000_Help=No text
DBTASKPageReferenced_000_Help=Database Tasks Pages Referenced/sec is the rate at which background database tasks are touching database pages. [Dev Only]
DBTASKPageRead_000_Help=Database Tasks Pages Read/sec is the rate of database read operations being performed by background database tasks. [Dev Only]
DBTASKPagePreread_000_Help=Database Tasks Pages Preread/sec is the rate at which database pages are read in anticipation of future use by background database tasks. [Dev Only]
DBTASKPageDirtied_000_Help=Database Tasks Pages Dirtied/sec is the rate at which background database tasks are modifying clean database pages. [Dev Only]
DBTASKPageRedirtied_000_Help=Database Tasks Pages Re-Dirtied/sec is the rate at which background databases tasks are modifying database pages that already contained modifications. [Dev Only]
DBTASKLogRecord_000_Help=Database Tasks Log Records/sec is the rate at which background database tasks are generating log records. [Dev Only]
DBTASKLogBytes_000_Help=Database Tasks Average Log Bytes is the average size of the log records being generated by background database tasks. [Dev only]
DBTASKLogRecordsTotal1_000_Help=No text
OSFileDbReadIO_000_Help=I/O Database Reads/sec is the rate of database read operations completed.
OSFileDbReadIOTotalTicks_000_Help=I/O Database Reads Average Latency is the average length of time, in milliseconds, per database read operation.
OSFileDbReadIOTotal1_000_Help=No text
OSFileDbReadIOTotalBytes_000_Help=I/O Database Reads Average Bytes is the average number of bytes transferred per database read operation. [Dev Only]
OSFileDbReadIOTotal2_000_Help=No text
OSFileDbReadIOInHeap_000_Help=I/O Database Reads In Heap is the number of database read operations queued in the database engine's I/O heap and waiting to be issued. [Dev Only]
OSFileDbReadIOAsyncPending_000_Help=I/O Database Reads Async Pending is the number of database read operations asynchronously pending completion. [Dev Only]
OSFileDbReadIOAbnormalLatency_000_Help=I/O Database Reads Abnormal Latency/sec is the rate of database read operations that take an abnormally long length of time (default is 1 minute) to be serviced by the OS. [Dev Only]
OSFileLogReadIO_000_Help=I/O Log Reads/sec is the rate of logfile read operations completed.
OSFileLogReadIOTotalTicks_000_Help=I/O Log Reads Average Latency is the average length of time, in milliseconds, per logfile read operation. [Dev Only]
OSFileLogReadIOTotal1_000_Help=No text
OSFileLogReadIOTotalBytes_000_Help=I/O Log Reads Average Bytes is the average number of bytes transferred per logfile read operation. [Dev Only]
OSFileLogReadIOTotal2_000_Help=No text
OSFileLogReadIOInHeap_000_Help=I/O Log Reads In Heap is the number of logfile read operations queued in the database engine's I/O heap and waiting to be issued. [Dev Only]
OSFileLogReadIOAsyncPending_000_Help=I/O Log Reads Async Pending is the number of logfile read operations asynchronously pending completion. [Dev Only]
OSFileLogReadIOAbnormalLatency_000_Help=I/O Log Reads Abnormal Latency/sec is the rate of logfile read operations that take an abnormally long length of time (default is 1 minute) to be serviced by the OS. [Dev Only]
OSFileDbWriteIO_000_Help=I/O Database Writes/sec is the rate of database write operations completed.
OSFileDbWriteIOTotalTicks_000_Help=I/O Database Writes Average Latency is the average length of time, in milliseconds, per database write operation.
OSFileDbWriteIOTotal1_000_Help=No text
OSFileDbWriteIOTotalBytes_000_Help=I/O Database Writes Average Bytes is the average number of bytes transferred per database write operation. [Dev Only]
OSFileDbWriteIOTotal2_000_Help=No text
OSFileDbWriteIOInHeap_000_Help=I/O Database Writes In Heap is the number of database write operations queued in the database engine's I/O heap and waiting to be issued. [Dev Only]
OSFileDbWriteIOAsyncPending_000_Help=I/O Database Writes Async Pending is the number of database write operations asynchronously pending completion. [Dev Only]
OSFileDbWriteIOAbnormalLatency_000_Help=I/O Database Writes Abnormal Latency/sec is the rate of database write operations that take an abnormally long length of time (default is 1 minute) to be serviced by the OS. [Dev Only]
OSFileLogWriteIO_000_Help=I/O Log Writes/sec is the rate of logfile write operations completed.
OSFileLogWriteIOTotalTicks_000_Help=I/O Log Writes Average Latency is the average length of time, in milliseconds, per logfile write operation.
OSFileLogWriteIOTotal1_000_Help=No text
OSFileLogWriteIOTotalBytes_000_Help=I/O Log Writes Average Bytes is the average number of bytes transferred per logfile write operation. [Dev Only]
OSFileLogWriteIOTotal2_000_Help=No text
OSFileLogWriteIOInHeap_000_Help=I/O Log Writes In Heap is the number of logfile write operations queued in the database engine's I/O heap and waiting to be issued. [Dev Only]
OSFileLogWriteIOAsyncPending_000_Help=I/O Log Writes Async Pending is the number of logfile write operations asynchronously pending completion. [Dev Only]
OSFileLogWriteIOAbnormalLatency_000_Help=I/O Log Writes Abnormal Latency/sec is the rate of logfile write operations that take an abnormally long length of time (default is 1 minute) to be serviced by the OS. [Dev Only]
OSSLVFileTableInserts_000_Help=SLV File Table Inserts/sec is the rate at which entries are inserted into an SLV File Table in the system. [Dev Only]
OSSLVFileTableCleans_000_Help=SLV File Table Cleans/sec is the rate at which attempta are made to delete an entry from an SLV File Table in the system. [Dev Only]
OSSLVFileTableDeletes_000_Help=SLV File Table Deletes/sec is the rate at which entries are deleted from an SLV File Table in the system. [Dev Only]
OSSLVFileTableEntries_000_Help=SLV File Table Entries is the total number of entries contained in all SLV File Tables in the system. [Dev Only]
OSSYNCThreadBlock_000_Help=Threads Blocked/sec is the rate at which the execution of threads are suspended to wait for a specific event to occur or for the acquisition of a resource currently owned by another thread. [Dev Only]
OSSYNCThreadsBlocked_000_Help=Threads Blocked is the current number of threads whose execution has been suspended to wait for a specific event to occur or for the acquisition of a resource currently owned by another thread. [Dev Only]
TRECInserts_000_Help=Record Inserts/sec is the rate at which records are being inserted into database tables. [Dev Only]
TRECDeletes_000_Help=Record Deletes/sec is the rate at which records in database tables are being flagged for deletion. [Dev Only]
TRECReplaces_000_Help=Record Deletes/sec is the rate at which records in database tables are being updated. [Dev Only]
TRECNoOpReplaces_000_Help=Record Unnecessary Replaces/sec is the rate at which updates to records in database tables are being discarded because the update did not actually modify the contents of the record. [Dev Only]
TRECRedundantReplaces_000_Help=Record Redundant Replaces/sec is the rate at which records in database tables are being updated with the exact same content of the original record. [Dev Only]
TRECEscrowUpdates_000_Help=Record Escrow-Updates/sec is the rate at which records in database tables are being escrow-updated. [Dev Only]
TRECIndexInserts_000_Help=Secondary Index Inserts/sec is the rate at which entries are being inserted into indexes of database tables. [Dev Only]
TRECIndexDeletes_000_Help=Secondary Index Deletes/sec is the rate at which entries in indexes of database tables are being flagged for deletion. [Dev Only]
TRECFalseIndexColumnUpdates_000_Help=False Index Column Updates/sec is the number of times per second an attempt was made to update an index because an update to at least one of the indexed columns was detected, only to discover that none of the indexed columns had actually changed (and therefore no index update was actually required). [Dev Only]
TRECFalseTupleIndexColumnUpdates_000_Help=False Tuple Index Column Updates/sec is the number of times per second an attempt was made to update a tuple index because an update to the tuple-indexed column was detected, only to discover that the column had not actually changed (and therefore no index update was actually required). [Dev Only]
TRECUpdateIntrinsicLV_000_Help=Record Intrinsic Long-Values Updated/sec is the rate at which intrinsic long-values are added to or replaced in records of database tables. [Dev Only]
TRECAddSeparateLV_000_Help=Record Separated Long-Values Added/sec is the rate at which separated long-values are normally added to records of database tables. [Dev Only]
TRECAddForcedSeparateLV_000_Help=Record Separated Long-Values Forced/sec is the rate at which separated long-values are added to records of a database table because they could not be accommodated in the record itself. [Dev Only]
TRECForceSeparateAllLV_000_Help=Record Separated Long-Values All Forced/sec is the rate at which all intrinsic long-values are separated out of a record of a database table in order to accommodate updates to the record. [Dev Only]
TRECRefAllSeparateLV_000_Help= Record Separated Long-Values Reference All/sec is the rate at which a reference is added for all the separated long-values associated with a record of a database table. [Dev Only]
TRECDerefAllSeparateLV_000_Help= Record Separated Long-Values Dereference All/sec is the rate at which a reference is removed for all the separated long-values associated with a record of a database table. [Dev Only]
TLVSeeks_000_Help=Separated Long-Value Seeks/sec is the rate at which seeks for a separated long-value in a database table are performed. [Dev Only]
TLVRetrieves_000_Help=Separated Long-Value Retrieves/sec is the rate at which retrievals of a separated long-value in a database table are performed. [Dev Only]
TLVCreates_000_Help=Separated Long-Value Creates/sec is the rate at which new separated long-values are added to a database table. [Dev Only]
TLVUpdates_000_Help=Separated Long-Value Updates/sec is the rate at which existing separated long-values in a database table are modified. [Dev Only]
TLVDeletes_000_Help=Separated Long-Value Deletes/sec is the rate at which separated long-values in a database table are flagged for deletion. [Dev Only]
TLVCopies_000_Help=Separated Long-Value Copies/sec is the rate at which existing separated long-values in a database table are copied. [Dev Only]
TLVChunkSeeks_000_Help=Separated Long-Value Chunk Seeks/sec is the rate at which seeks for a particular chunk of a separated long-value in a database table are performed. [Dev Only]
TLVChunkRetrieves_000_Help=Separated Long-Value Chunk Retrieves/sec is the rate at which retrievals of a chunk of a separated long-value in a database table are performed. [Dev Only]
TLVChunkAppends_000_Help=Separated Long-Value Chunk Appends/sec is the rate at which chunks are appended to separated long-values of database tables. [Dev Only]
TLVChunkReplaces_000_Help=Separated Long-Value Chunk Replaces/sec is the rate at which existing separated long-value chunks in a database table are replaced. [Dev Only]
TLVChunkDeletes_000_Help=Separated Long-Value Chunk Deletes/sec is the rate at which separated long-value chunks in a database table are flagged for deletion. [Dev Only]
TLVChunkCopies_000_Help=Separated Long-Value Chunk Copies/sec is the rate at which existing separated long-value chunks in a database table are copied. [Dev Only]
TBTAppendSplit_000_Help=B+ Tree Append Splits/sec is the count of times a page is appended to a database B+ Tree per second. [Dev Only]
TBTRightSplit_000_Help=B+ Tree Right Splits/sec is the count of times a page is split right in a database B+ Tree per second. [Dev Only]
TBTRightHotpointSplit_000_Help=B+ Tree Right Hotpoint Splits/sec is the count of times a page is split right in a database B+ Tree, but which is treated as an append at a local "hotpoint" in the B+ Tree per second. [Dev Only]
TBTVerticalSplit_000_Help=B+ Tree Vertical Splits/sec is the count of times a page is split vertically in a database B+ Tree per second. [Dev Only]
TBTSplit_000_Help=B+ Tree Splits/sec is the count of times a page is appended to or split in a database B+ Tree per second. [Dev Only]
TBTEmptyPageMerge_000_Help=B+ Tree Empty Page Merges/sec is the count of empty pages removed from a database B+ Tree per second. [Dev Only]
TBTRightMerge_000_Help=Right Merges/sec is the count of pages removed from a database B+ Tree per second by moving all its records to the next page to the right. [Dev Only]
TBTPartialMerge_000_Help=B+ Tree Partial Merges/sec is the count of pages where some of its records are moved to a page on the right in a database B+ Tree per second. [Dev Only]
TBTMerge_000_Help=B+ Tree Merges/sec is the count of pages merged in a database B+ Tree per second. [Dev Only]
TBTFailedSPCWriteLatch_000_Help=B+ Tree Failed Simple Page Cleanup Attempts/sec is the rate that attempts to reclaim deleted node space on a page are unsuccessful due to a conflict when attempting to write-latch the page. The cleanup is re-tried by locking the root of the B+ Tree. [Dev Only]
TBTSeekShortCircuit_000_Help=B+ Tree Seek Short Circuits/sec is the count of repeated seeks to the same record in a database B+ Tree that are saved by jumping directly to the cached physical location of that record per second. [Dev Only]
TBTUnnecessarySiblingLatch_000_Help=B+ Tree Unnecessary Sibling Latches/sec is the count of sibling pages latched during a database B+ Tree Delete in the hopes of performing a merge where a merge is not possible, making that latch unnecessary. [Dev Only]
TBTNext_000_Help=B+ Tree Move Nexts/sec is the count of times the database engine moves to the next record in a B+ Tree per second. [Dev Only]
TBTNextNonVisibleNodesSkipped_000_Help=B+ Tree Move Nexts (Non-Visible Nodes Skipped)/sec is the count of times the database engine skips non-visible records while attempting to move to the next visible record in a B+ Tree per second. [Dev Only]
TBTPrev_000_Help=B+ Tree Move Prevs/sec is the count of times the database engine moves to the previous record in a B+ Tree per second. [Dev Only]
TBTPrevNonVisibleNodesSkipped_000_Help=B+ Tree Move Prevs (Non-Visible Nodes Skipped)/sec is the count of times the database engine skips non-visible records while attempting to move to the previous visible record in a B+ Tree per second. [Dev Only]
TBTSeek_000_Help=B+ Tree Seeks/sec is the count of times a record is seeked to by a key in a database B+ Tree per second. [Dev Only]
TBTInsert_000_Help=B+ Tree Inserts/sec is the count of times a record is inserted in a database B+ Tree per second. [Dev Only]
TBTReplace_000_Help=B+ Tree Replaces/sec is the count of times a record is replaced in a database B+ Tree per second. [Dev Only]
TBTFlagDelete_000_Help=B+ Tree Flag Deletes/sec is the count of times a record is flag deleted in a database B+ Tree per second. [Dev Only]
TBTDelete_000_Help=B+ Tree Deletes/sec is the count of times a record is deleted in a database B+ Tree per second. [Dev Only]
TBTAppend_000_Help=B+ Tree Appends/sec is the count of times a record is appended to a database B+ Tree per second. [Dev Only]
TSPCreate_000_Help=B+ Tree Creates/sec is the number of B+ Trees and their corresponding space trees (if any) created per second. This can also be viewed as the number of FDP creates per second. [Dev Only]
TSPCreateCum_000_Help=B+ Tree Creates (Total) is the total number of B+ Trees and their corresponding space trees (if any) created. This can also be viewed as the total number of FDP creates. [Dev Only]
TSPDelete_000_Help=B+ Tree Destroys/sec is the number of B+ Trees and their corresponding space trees (if any) destroyed per second. This can also be viewed as the number of FDP destroys per second. [Dev Only]
TSPDeleteCum_000_Help=B+ Tree Destroys (Total) is the total number of B+ Trees and their corresponding space trees (if any) destroyed. This can also be viewed as the total number of FDP destroys. [Dev Only]
TBFCacheSizeMB_000_Help=Database Cache Size (MB) is the amount of system memory (in MegaBytes) used by the database cache manager to hold commonly used information from the database file(s) to prevent file operations. If the database cache size seems to be too small for optimal performance and there is very little available memory on the system (see Memory/Available Bytes), adding more memory to the system may increase performance. If there is a lot of available memory on the system and the database cache size is not growing beyond a certain point, the database cache size may be capped at an artificially low limit. Increasing this limit may increase performance.
TBFPagesReadAsyncPerSec_000_Help=Database Pages Read Async/sec is the rate that pages are asynchronously read from the database file(s) into the database cache. [Dev Only]
TBFPagesReadSyncPerSec_000_Help=Database Pages Read Sync/sec is the rate that pages are synchronously read from the database file(s) into the database cache. [Dev Only]
TBFPagesWrittenPerSec_000_Help=Database Pages Written/sec is the rate that pages are written to the database file (s) from the database cache. [Dev Only]
TBFPagesTransferredPerSec_000_Help=Database Pages Transferred/sec is the rate that pages are transferred from the database file(s) to the database cache and vice versa. [Dev Only]
TBFPagesPreread_000_Help=Database Pages Preread/sec is the rate that pages are read in anticipation of future use from the database file(s) into the database cache. [Dev Only]
TBFCachedPagesPreread_000_Help=Database Cached Pages Preread/sec is the rate that pages are read in anticipation of future use from the database file(s) into the database cache that are already cached. This is non-ideal behavior that represents a waste of processing time. [Dev Only]
TBFPagesPrereadUntouched_000_Help=Database Pages Preread Untouched/sec is the rate that pages are read in anticipation of future use from the database file(s) into the database cache that were subsequently thrown out without being used. This is non-ideal behavior that represents a waste of I/O bandwidth and processing time . [Dev Only]
TBFPagesVersioned_000_Help=Database Pages Versioned / sec is the rate at which pages in the database cache are being copied into new pages in the cache for the purpose of being asynchronously written while the current version of that page in the database file is still being modified. This feature is primarily used to avoid cycles, branches, or long chains of flush order dependencies without requiring the pages involved to be synchronously written to disk. [Dev Only]
TBFPagesOrdinarilyWritten_000_Help=Database Pages Ordinarily Written/sec is the rate that pages are written to the database file (s) from the database cache in preparation for evicting them from the cache to make room for other data. [Dev Only]
TBFPagesAnomalouslyWritten_000_Help=Database Pages Anomalously Written/sec is the rate that pages are written to the database file (s) from the database cache before they would ordinarily be written. [Dev Only]
TBFPagesOpportunelyWritten_000_Help=Database Pages Opportunely Written/sec is the rate that pages are written to the database file (s) from the database cache because they happen to be near other pages that must be written. These additional writes are performed before they must happen in the hope that the total number of seeks required to write all the pages is reduced. [Dev Only]
TBFPagesRepeatedlyWritten_000_Help=Database Pages Repeatedly Written/sec is the rate that pages are written to the database file (s) from the database cache more than once in their lifetime in the cache. These page writes represent extra writes above the theoretical minimum and can therefore be considered overhead. [Dev Only]
TBFPagesIdlyWritten_000_Help=Database Pages Idly Written/sec is the rate that pages are written to the database file (s) from the database cache because there is low disk activity. [Dev Only]
TBFPagesCoalescedWritten_000_Help=Database Pages Coalesced Written/sec is the rate that pages are written to the database file (s) from the database cache coalesced with another page. [Dev Only]
TBFPagesCoalescedRead_000_Help=Database Pages Coalesced Read/sec is the rate that pages are read from the database file (s) to the database cache coalesced with another page. [Dev Only]
IPagesConvertedSec_000_Help=Pages Converted/sec is the count of times per second a database page is converted from an older database format
IPagesConvertedTotal_000_Help=Pages Converted is the count of database pages that have been converted from an older format
IRecordsConvertedSec_000_Help=Records Converted/sec is the count of times per second a database record is converted from an older database format
IRecordsConvertedTotal_000_Help=Records Converted is the count of database records that have been converted from an older format
IFCBAsyncScan_000_Help=FCB Asynchronous Scan/sec is the number of cached schema records (FCBs) scanned during asynchronous schema record cleanup. These records are scanned to age out older schema definitions. [Dev Only]
IFCBAsyncPurge_000_Help=FCB Asynchronous Purge/sec is the number of cached schema records (FCBs) purged during asynchronous schema record cleanup. These records are purged to age out older schema definitions. [Dev Only]
IFCBAsyncThresholdScan_000_Help=FCB Asynchronous Threshold-Scan/sec is the number of cached schema records (FCBs) scanned during asynchronous schema record cleanup. Cleanup was triggered by a large number of schema records above the preferred limit. These records are aggressively scanned to age out older schema definitions. [Dev Only]
IFCBAsyncThresholdPurge_000_Help=FCB Asynchronous Threshold-Purge/sec is the number of cached schema records (FCBs) purged during asynchronous schema record cleanup. Cleanup was triggered by a large number of schema records above the preferred limit. These records are aggressively purged to age out older schema definitions. [Dev Only]
IFCBAsyncPurgeConflict_000_Help=FCB Asynchronous Purge Conflicts/sec is the number of failed purge attempts on cached schema records (FCBs) during asynchronous schema record cleanup. The purge operation failed because exclusive ownership of the schema record could not be obtained. [Dev Only]
IFCBSyncPurge_000_Help=FCB Synchronous Purge/sec is the number of cached schema records (FCBs) being synchronously purged each second. [Dev Only]
IFCBSyncPurgeStalls_000_Help=FCB Synchronous Purge Stalls/sec is the number of stalls encountered while waiting for exclusive ownership of cached schema records (FCBs) in order to synchronously purge them. [Dev Only]
IFCBAllocWaitForVersionCleanup_000_Help=FCB Allocations Wait For Version Cleanup/sec is the number of FCB allocations that must first wait for version cleanup in an attempt to free used FCBs for re-use. [Dev Only]
IFCBPurgeOnClose_000_Help=FCB Purge On Cursor Close/sec is the number of cached schema records (FCBs) being synchronously purged when the cursor is closed (instead of leaving the schema record cached) each second. [Dev Only]
IFCBCacheHits_000_Help=FCB Cache % Hit is the percentage of schema records (FCBs) opened directly from the schema record cache. No file operations were required. [Dev Only]
IFCBCacheRequests_000_Help=No text
IFCBCacheStalls_000_Help=FCB Cache Stalls/sec is the number of stalls encountered while waiting for exclusive ownership of cached schema records (FCBs) in order to update their reference count. [Dev Only]
IFCBCacheMax_000_Help=FCB Cache Maximum is the absolute maximum number of the schema records (FCBs) that can exist in the cache. [Dev Only]
IFCBCachePreferred_000_Help=FCB Cache Preferred is the preferred maximum number of the schema records (FCBs) that should exist in the cache. [Dev Only]
IFCBCacheAlloc_000_Help=FCB Cache Allocated is the number of cached schema records (FCBs) currently allocated and in use. [Dev Only]
IFCBCacheAllocAvail_000_Help=FCB Cache Available is the number of cached schema records (FCBs) currently allocated but not in use. These records will be used and/or purged as required. [Dev Only]
IPIBInUse_000_Help=Sessions In Use is the number of database sessions currently open for use by client threads. [Dev Only]
IPIBUsed_000_Help=Sessions % Used is the percentage of database sessions currently open for use by client threads. [Dev Only]
IPIBTotal_000_Help=No text
ITableOpenCacheHitRate_000_Help=Table Open Cache % Hit is the percentage of database tables opened using cached schema information. If this percentage is too low, the table cache size may be too small.
ITableOpenCacheRequests_000_Help=No text
ITableOpenCacheHitsPerSec_000_Help=Table Open Cache Hits/sec is the number of database tables opened using cached schema information per second. If this rate is too low, the table cache size may be too small.
ITableOpenCacheMissesPerSec_000_Help=Table Open Cache Misses/sec is the number of database tables opened without using cached schema information per second. If this rate is too high, the table cache size may be too small.
ITableOpensPerSec_000_Help=Table Opens/sec is the number of database tables opened per second.
ILGBytesWrittenPerSec_000_Help=Log Bytes Write per second is the rate bytes are written to the log.
ILGBufferSize_000_Help=Log Buffer Size is the amount of memory, in bytes, allocated for the database log buffers. [Dev Only]
ILGBufferBytesUsed_000_Help=Log Buffer Bytes Used is the amount of bytes in the log buffers that have not yet been flushed to the logs. [Dev only]
ILGBufferBytesFree_000_Help=Log Buffer Bytes Free is the amount of free space available in the log buffers. [Dev only]
ILGUsersWaiting_000_Help=Log Threads Waiting is the number of threads waiting for their data to be written to the log in order to complete an update of the database. If this number is too high, the log may be a bottleneck.
ILGFileSize_000_Help=Log File Size is the size, in bytes, of the database log files. [Dev Only]
ILGCheckpointDepth_000_Help=Log Checkpoint Depth represents the amount of work, in bytes, that will need to be redone or undone to the database file(s) if the process crashes. [Dev Only]
ILGLogGenerationCheckpointDepth_000_Help=Log Generation Checkpoint Depth represents the amount of work, in count of log files, that will need to be redone or undone to the database file(s) if the process crashes.
IUserROTrxCommit0PerSec_000_Help=User Read Only Transaction Commits to Level 0/sec is the count of fully committed transactions started by the calling process that do not modify any data stored in the database engine. [Dev Only]
IUserRWTrxCommit0PerSec_000_Help=User Read/Write Transaction Commits to Level 0/sec is the count of fully committed transactions started by the calling process that modify data stored in the database engine. [Dev Only]
IUserTrxCommit0PerSec_000_Help=User Transaction Commits to Level 0/sec is the count of fully committed transactions started by the calling process that access data stored in the database engine. [Dev Only]
IUserROTrxRollback0PerSec_000_Help=User Read Only Transaction Rollbacks to Level 0/sec is the count of aborted transactions started by the calling process that do not modify any data stored in the database engine. [Dev Only]
IUserRWTrxRollback0PerSec_000_Help=User Read/Write Transaction Rollbacks to Level 0/sec is the count of aborted transactions started by the calling process that modify data stored in the database engine. [Dev Only]
IUserTrxRollback0PerSec_000_Help=User Transaction Rollbacks to Level 0/sec is the count of aborted transactions started by the calling process that access data stored in the database engine. [Dev Only]
ISystemROTrxCommit0PerSec_000_Help=System Read Only Transaction Commits to Level 0/sec is the count of fully committed transactions started internally that do not modify any data stored in the database engine. [Dev Only]
ISystemRWTrxCommit0PerSec_000_Help=System Read/Write Transaction Commits to Level 0/sec is the count of fully committed transactions started internally that modify data stored in the database engine. [Dev Only]
ISystemTrxCommit0PerSec_000_Help=System Transaction Commits to Level 0/sec is the count of fully committed transactions started internally that access data stored in the database engine. [Dev Only]
ISystemROTrxRollback0PerSec_000_Help=System Read Only Transaction Rollbacks to Level 0/sec is the count of aborted transactions started internally that do not modify any data stored in the database engine. [Dev Only]
ISystemRWTrxRollback0PerSec_000_Help=System Read/Write Transaction Rollbacks to Level 0/sec is the count of aborted transactions started internally that modify data stored in the database engine. [Dev Only]
ISystemTrxRollback0PerSec_000_Help=System Transaction Rollbacks to Level 0/sec is the count of aborted transactions started internally that access data stored in the database engine. [Dev Only]
IIODatabaseFileExtensionAsyncConsumed_000_Help=Database Page Allocation File Extension Async Consumed/sec is the rate of page allocations from a database file that must be serviced by extending the database file, but which do not stall when doing doing so. [Dev Only]
IIODatabaseFileExtensionStall_000_Help=Database Page Allocation File Extension Stalls/sec is the rate of page allocations from a database file that must be serviced by extending the database file and which stall when doing so. [Dev Only]
ILGRecordPerSec_000_Help=Log Records/sec is the count of records written to the database log buffers per second. [Dev Only]
ILGCapacityFlushPerSec_000_Help=Log Buffer Capacity Flushes/sec is the count of times the database log buffers must be flushed per second because they are full. [Dev Only]
ILGCommitFlushPerSec_000_Help=Log Buffer Commit Flushes/sec is the count of times the database log buffers must be flushed per second because a transaction is fully committing its changes. [Dev Only]
ILGFlushPerSec_000_Help=Log Buffer Flushes/sec is the count of times the database log buffers must be flushed per second.
ILGWritePerSec_000_Help=Log Writes/sec is the number of times the log buffers are written to the log file(s) per second. If this number approaches the maximum write rate for the media holding the log file(s), the log may be a bottleneck.
ILGStallPerSec_000_Help=Log Record Stalls/sec is the number of log records that cannot be added to the log buffers per second because they are full. If this counter is non-zero most of the time, the log buffer size may be a bottleneck.
IVERcbucketAllocated_000_Help=Total number of version buckets allocated
IVERcbucketDeleteAllocated_000_Help=Total number of version buckets allocated for FlagDelete RCEs [Dev Only]
IVERBucketAllocWaitForVersionCleanup_000_Help=VER Bucket Allocations Wait For Version Cleanup/sec is the number of version bucket allocations that must first wait for version cleanup in an attempt to free used version buckets for re-use. [Dev Only]
IVERcbAverageBookmark_000_Help=Average length of bookmark in RCE [Dev Only]
IVERUnnecessaryCalls_000_Help=Number of times per second we look in the version store for a node whose version bit is set but which has no versions [Dev Only]
IVERAsyncCleanupDispatched_000_Help=Number of times per second a version store clean task is dispatched asynchronously to be performed [Dev Only]
IVERSyncCleanupDispatched_000_Help=Number of times per second a version store clean task is performed synchronously [Dev Only]
IVERCleanupDiscarded_000_Help=Number of times per second a version store clean task was discarded due to load concerns [Dev Only]
IVERCleanupFailed_000_Help=Number of times per second a dispatched version store cleanup task fails [Dev Only]
IRECInserts_000_Help=Record Inserts/sec is the rate at which records are being inserted into database tables. [Dev Only]
IRECDeletes_000_Help=Record Deletes/sec is the rate at which records in database tables are being flagged for deletion. [Dev Only]
IRECReplaces_000_Help=Record Deletes/sec is the rate at which records in database tables are being updated. [Dev Only]
IRECNoOpReplaces_000_Help=Record Unnecessary Replaces/sec is the rate at which updates to records in database tables are being discarded because the update did not actually modify the contents of the record. [Dev Only]
IRECRedundantReplaces_000_Help=Record Redundant Replaces/sec is the rate at which records in database tables are being updated with the exact same content of the original record. [Dev Only]
IRECEscrowUpdates_000_Help=Record Escrow-Updates/sec is the rate at which records in database tables are being escrow-updated. [Dev Only]
IRECIndexInserts_000_Help=Secondary Index Inserts/sec is the rate at which entries are being inserted into indexes of database tables. [Dev Only]
IRECIndexDeletes_000_Help=Secondary Index Deletes/sec is the rate at which entries in indexes of database tables are being flagged for deletion. [Dev Only]
IRECFalseIndexColumnUpdates_000_Help=False Index Column Updates/sec is the number of times per second an attempt was made to update an index because an update to at least one of the indexed columns was detected, only to discover that none of the indexed columns had actually changed (and therefore no index update was actually required). [Dev Only]
IRECFalseTupleIndexColumnUpdates_000_Help=False Tuple Index Column Updates/sec is the number of times per second an attempt was made to update a tuple index because an update to the tuple-indexed column was detected, only to discover that the column had not actually changed (and therefore no index update was actually required). [Dev Only]
IRECUpdateIntrinsicLV_000_Help=Record Intrinsic Long-Values Updated/sec is the rate at which intrinsic long-values are added to or replaced in records of database tables. [Dev Only]
IRECAddSeparateLV_000_Help=Record Separated Long-Values Added/sec is the rate at which separated long-values are normally added to records of database tables. [Dev Only]
IRECAddForcedSeparateLV_000_Help=Record Separated Long-Values Forced/sec is the rate at which separated long-values are added to records of a database table because they could not be accommodated in the record itself. [Dev Only]
IRECForceSeparateAllLV_000_Help=Record Separated Long-Values All Forced/sec is the rate at which all intrinsic long-values are separated out of a record of a database table in order to accommodate updates to the record. [Dev Only]
IRECRefAllSeparateLV_000_Help= Record Separated Long-Values Reference All/sec is the rate at which a reference is added for all the separated long-values associated with a record of a database table. [Dev Only]
IRECDerefAllSeparateLV_000_Help= Record Separated Long-Values Dereference All/sec is the rate at which a reference is removed for all the separated long-values associated with a record of a database table. [Dev Only]
ILVSeeks_000_Help=Separated Long-Value Seeks/sec is the rate at which seeks for a separated long-value in a database table are performed. [Dev Only]
ILVRetrieves_000_Help=Separated Long-Value Retrieves/sec is the rate at which retrievals of a separated long-value in a database table are performed. [Dev Only]
ILVCreates_000_Help=Separated Long-Value Creates/sec is the rate at which new separated long-values are added to a database table. [Dev Only]
ILVUpdates_000_Help=Separated Long-Value Updates/sec is the rate at which existing separated long-values in a database table are modified. [Dev Only]
ILVDeletes_000_Help=Separated Long-Value Deletes/sec is the rate at which separated long-values in a database table are flagged for deletion. [Dev Only]
ILVCopies_000_Help=Separated Long-Value Copies/sec is the rate at which existing separated long-values in a database table are copied. [Dev Only]
ILVChunkSeeks_000_Help=Separated Long-Value Chunk Seeks/sec is the rate at which seeks for a particular chunk of a separated long-value in a database table are performed. [Dev Only]
ILVChunkRetrieves_000_Help=Separated Long-Value Chunk Retrieves/sec is the rate at which retrievals of a chunk of a separated long-value in a database table are performed. [Dev Only]
ILVChunkAppends_000_Help=Separated Long-Value Chunk Appends/sec is the rate at which chunks are appended to separated long-values of database tables. [Dev Only]
ILVChunkReplaces_000_Help=Separated Long-Value Chunk Replaces/sec is the rate at which existing separated long-value chunks in a database table are replaced. [Dev Only]
ILVChunkDeletes_000_Help=Separated Long-Value Chunk Deletes/sec is the rate at which separated long-value chunks in a database table are flagged for deletion. [Dev Only]
ILVChunkCopies_000_Help=Separated Long-Value Chunk Copies/sec is the rate at which existing separated long-value chunks in a database table are copied. [Dev Only]
IBTAppendSplit_000_Help=B+ Tree Append Splits/sec is the count of times a page is appended to a database B+ Tree per second. [Dev Only]
IBTRightSplit_000_Help=B+ Tree Right Splits/sec is the count of times a page is split right in a database B+ Tree per second. [Dev Only]
IBTRightHotpointSplit_000_Help=B+ Tree Right Hotpoint Splits/sec is the count of times a page is split right in a database B+ Tree, but which is treated as an append at a local "hotpoint" in the B+ Tree per second. [Dev Only]
IBTVerticalSplit_000_Help=B+ Tree Vertical Splits/sec is the count of times a page is split vertically in a database B+ Tree per second. [Dev Only]
IBTSplit_000_Help=B+ Tree Splits/sec is the count of times a page is appended to or split in a database B+ Tree per second. [Dev Only]
IBTEmptyPageMerge_000_Help=B+ Tree Empty Page Merges/sec is the count of empty pages removed from a database B+ Tree per second. [Dev Only]
IBTRightMerge_000_Help=Right Merges/sec is the count of pages removed from a database B+ Tree per second by moving all its records to the next page to the right. [Dev Only]
IBTPartialMerge_000_Help=B+ Tree Partial Merges/sec is the count of pages where some of its records are moved to a page on the right in a database B+ Tree per second. [Dev Only]
IBTMerge_000_Help=B+ Tree Merges/sec is the count of pages merged in a database B+ Tree per second. [Dev Only]
IBTFailedSPCWriteLatch_000_Help=B+ Tree Failed Simple Page Cleanup Attempts/sec is the rate that attempts to reclaim deleted node space on a page are unsuccessful due to a conflict when attempting to write-latch the page. The cleanup is re-tried by locking the root of the B+ Tree. [Dev Only]
IBTSeekShortCircuit_000_Help=B+ Tree Seek Short Circuits/sec is the count of repeated seeks to the same record in a database B+ Tree that are saved by jumping directly to the cached physical location of that record per second. [Dev Only]
IBTUnnecessarySiblingLatch_000_Help=B+ Tree Unnecessary Sibling Latches/sec is the count of sibling pages latched during a database B+ Tree Delete in the hopes of performing a merge where a merge is not possible, making that latch unnecessary. [Dev Only]
IBTNext_000_Help=B+ Tree Move Nexts/sec is the count of times the database engine moves to the next record in a B+ Tree per second. [Dev Only]
IBTNextNonVisibleNodesSkipped_000_Help=B+ Tree Move Nexts (Non-Visible Nodes Skipped)/sec is the count of times the database engine skips non-visible records while attempting to move to the next visible record in a B+ Tree per second. [Dev Only]
IBTPrev_000_Help=B+ Tree Move Prevs/sec is the count of times the database engine moves to the previous record in a B+ Tree per second. [Dev Only]
IBTPrevNonVisibleNodesSkipped_000_Help=B+ Tree Move Prevs (Non-Visible Nodes Skipped)/sec is the count of times the database engine skips non-visible records while attempting to move to the previous visible record in a B+ Tree per second. [Dev Only]
IBTSeek_000_Help=B+ Tree Seeks/sec is the count of times a record is seeked to by a key in a database B+ Tree per second. [Dev Only]
IBTInsert_000_Help=B+ Tree Inserts/sec is the count of times a record is inserted in a database B+ Tree per second. [Dev Only]
IBTReplace_000_Help=B+ Tree Replaces/sec is the count of times a record is replaced in a database B+ Tree per second. [Dev Only]
IBTFlagDelete_000_Help=B+ Tree Flag Deletes/sec is the count of times a record is flag deleted in a database B+ Tree per second. [Dev Only]
IBTDelete_000_Help=B+ Tree Deletes/sec is the count of times a record is deleted in a database B+ Tree per second. [Dev Only]
IBTAppend_000_Help=B+ Tree Appends/sec is the count of times a record is appended to a database B+ Tree per second. [Dev Only]
ISPCreate_000_Help=B+ Tree Creates/sec is the number of B+ Trees and their corresponding space trees (if any) created per second. This can also be viewed as the number of FDP creates per second. [Dev Only]
ISPCreateCum_000_Help=B+ Tree Creates (Total) is the total number of B+ Trees and their corresponding space trees (if any) created. This can also be viewed as the total number of FDP creates. [Dev Only]
ISPDelete_000_Help=B+ Tree Destroys/sec is the number of B+ Trees and their corresponding space trees (if any) destroyed per second. This can also be viewed as the number of FDP destroys per second. [Dev Only]
ISPDeleteCum_000_Help=B+ Tree Destroys (Total) is the total number of B+ Trees and their corresponding space trees (if any) destroyed. This can also be viewed as the total number of FDP destroys. [Dev Only]
IBFPagesReadAsyncPerSec_000_Help=Database Pages Read Async/sec is the rate that pages are asynchronously read from the database file(s) into the database cache. [Dev Only]
IBFPagesReadSyncPerSec_000_Help=Database Pages Read Sync/sec is the rate that pages are synchronously read from the database file(s) into the database cache. [Dev Only]
IBFPagesWrittenPerSec_000_Help=Database Pages Written/sec is the rate that pages are written to the database file (s) from the database cache. [Dev Only]
IBFPagesTransferredPerSec_000_Help=Database Pages Transferred/sec is the rate that pages are transferred from the database file(s) to the database cache and vice versa. [Dev Only]
IBFPagesPreread_000_Help=Database Pages Preread/sec is the rate that pages are read in anticipation of future use from the database file(s) into the database cache. [Dev Only]
IBFCachedPagesPreread_000_Help=Database Cached Pages Preread/sec is the rate that pages are read in anticipation of future use from the database file(s) into the database cache that are already cached. This is non-ideal behavior that represents a waste of processing time. [Dev Only]
IBFPagesPrereadUntouched_000_Help=Database Pages Preread Untouched/sec is the rate that pages are read in anticipation of future use from the database file(s) into the database cache that were subsequently thrown out without being used. This is non-ideal behavior that represents a waste of I/O bandwidth and processing time . [Dev Only]
IBFPagesVersioned_000_Help=Database Pages Versioned / sec is the rate at which pages in the database cache are being copied into new pages in the cache for the purpose of being asynchronously written while the current version of that page in the database file is still being modified. This feature is primarily used to avoid cycles, branches, or long chains of flush order dependencies without requiring the pages involved to be synchronously written to disk. [Dev Only]
IBFPagesOrdinarilyWritten_000_Help=Database Pages Ordinarily Written/sec is the rate that pages are written to the database file (s) from the database cache in preparation for evicting them from the cache to make room for other data. [Dev Only]
IBFPagesAnomalouslyWritten_000_Help=Database Pages Anomalously Written/sec is the rate that pages are written to the database file (s) from the database cache before they would ordinarily be written. [Dev Only]
IBFPagesOpportunelyWritten_000_Help=Database Pages Opportunely Written/sec is the rate that pages are written to the database file (s) from the database cache because they happen to be near other pages that must be written. These additional writes are performed before they must happen in the hope that the total number of seeks required to write all the pages is reduced. [Dev Only]
IBFPagesRepeatedlyWritten_000_Help=Database Pages Repeatedly Written/sec is the rate that pages are written to the database file (s) from the database cache more than once in their lifetime in the cache. These page writes represent extra writes above the theoretical minimum and can therefore be considered overhead. [Dev Only]
IBFPagesIdlyWritten_000_Help=Database Pages Idly Written/sec is the rate that pages are written to the database file (s) from the database cache because there is low disk activity. [Dev Only]
IBFPagesCoalescedWritten_000_Help=Database Pages Coalesced Written/sec is the rate that pages are written to the database file (s) from the database cache coalesced with another page. [Dev Only]
IBFPagesCoalescedRead_000_Help=Database Pages Coalesced Read/sec is the rate that pages are read from the database file (s) to the database cache coalesced with another page. [Dev Only]
IBKReadIO_000_Help=Streaming Backup Pages Read/sec is the rate of database read operationsperformed for the purpose of streaming backups.
IOLDPageReferenced_000_Help=Online Defrag Pages Referenced/sec is the rate at which online defragmentation is touching database pages. [Dev Only]
IOLDPageRead_000_Help=Online Defrag Pages Read/sec is the rate of database read operations being performed by online defragmentation. [Dev Only]
IOLDPagePreread_000_Help=Online Defrag Pages Preread/sec is the rate at which database pages are read in anticipation of future use by online defragmentation. [Dev Only]
IOLDPageDirtied_000_Help=Online Defrag Pages Dirtied/sec is the rate at which online defragmentation is modifying clean database pages. [Dev Only]
IOLDPageRedirtied_000_Help=Online Defrag Pages Re-Dirtied/sec is the rate at which online defragmentation is modifying database pages that already contained modifications. [Dev Only]
IOLDLogRecord_000_Help=Online Defrag Log Records/sec is the rate at which online defragmentation is generating log records. [Dev Only]
IOLDLogBytes_000_Help=Online Defrag Average Log Bytes is the average size of the log records being generated by online defragmentation. [Dev only]
IOLDLogRecordsTotal1_000_Help=No text
IDBTASKPageReferenced_000_Help=Database Tasks Pages Referenced/sec is the rate at which background database tasks are touching database pages. [Dev Only]
IDBTASKPageRead_000_Help=Database Tasks Pages Read/sec is the rate of database read operations being performed by background database tasks. [Dev Only]
IDBTASKPagePreread_000_Help=Database Tasks Pages Preread/sec is the rate at which database pages are read in anticipation of future use by background database tasks. [Dev Only]
IDBTASKPageDirtied_000_Help=Database Tasks Pages Dirtied/sec is the rate at which background database tasks are modifying clean database pages. [Dev Only]
IDBTASKPageRedirtied_000_Help=Database Tasks Pages Re-Dirtied/sec is the rate at which background databases tasks are modifying database pages that already contained modifications. [Dev Only]
IDBTASKLogRecord_000_Help=Database Tasks Log Records/sec is the rate at which background database tasks are generating log records. [Dev Only]
IDBTASKLogBytes_000_Help=Database Tasks Average Log Bytes is the average size of the log records being generated by background database tasks. [Dev only]
IDBTASKLogRecordsTotal1_000_Help=No text
IOSFileDbReadIO_000_Help=I/O Database Reads/sec is the rate of database read operations completed.
IOSFileDbReadIOTotalTicks_000_Help=I/O Database Reads Average Latency is the average length of time, in milliseconds, per database read operation.
IOSFileDbReadIOTotal1_000_Help=No text
IOSFileDbReadIOTotalBytes_000_Help=I/O Database Reads Average Bytes is the average number of bytes transferred per database read operation. [Dev Only]
IOSFileDbReadIOTotal2_000_Help=No text
IOSFileDbReadIOInHeap_000_Help=I/O Database Reads In Heap is the number of database read operations queued in the database engine's I/O heap and waiting to be issued. [Dev Only]
IOSFileDbReadIOAsyncPending_000_Help=I/O Database Reads Async Pending is the number of database read operations asynchronously pending completion. [Dev Only]
IOSFileDbReadIOAbnormalLatency_000_Help=I/O Database Reads Abnormal Latency/sec is the rate of database read operations that take an abnormally long length of time (default is 1 minute) to be serviced by the OS. [Dev Only]
IOSFileLogReadIO_000_Help=I/O Log Reads/sec is the rate of logfile read operations completed.
IOSFileLogReadIOTotalTicks_000_Help=I/O Log Reads Average Latency is the average length of time, in milliseconds, per logfile read operation. [Dev Only]
IOSFileLogReadIOTotal1_000_Help=No text
IOSFileLogReadIOTotalBytes_000_Help=I/O Log Reads Average Bytes is the average number of bytes transferred per logfile read operation. [Dev Only]
IOSFileLogReadIOTotal2_000_Help=No text
IOSFileLogReadIOInHeap_000_Help=I/O Log Reads In Heap is the number of logfile read operations queued in the database engine's I/O heap and waiting to be issued. [Dev Only]
IOSFileLogReadIOAsyncPending_000_Help=I/O Log Reads Async Pending is the number of logfile read operations asynchronously pending completion. [Dev Only]
IOSFileLogReadIOAbnormalLatency_000_Help=I/O Log Reads Abnormal Latency/sec is the rate of logfile read operations that take an abnormally long length of time (default is 1 minute) to be serviced by the OS. [Dev Only]
IOSFileDbWriteIO_000_Help=I/O Database Writes/sec is the rate of database write operations completed.
IOSFileDbWriteIOTotalTicks_000_Help=I/O Database Writes Average Latency is the average length of time, in milliseconds, per database write operation.
IOSFileDbWriteIOTotal1_000_Help=No text
IOSFileDbWriteIOTotalBytes_000_Help=I/O Database Writes Average Bytes is the average number of bytes transferred per database write operation. [Dev Only]
IOSFileDbWriteIOTotal2_000_Help=No text
IOSFileDbWriteIOInHeap_000_Help=I/O Database Writes In Heap is the number of database write operations queued in the database engine's I/O heap and waiting to be issued. [Dev Only]
IOSFileDbWriteIOAsyncPending_000_Help=I/O Database Writes Async Pending is the number of database write operations asynchronously pending completion. [Dev Only]
IOSFileDbWriteIOAbnormalLatency_000_Help=I/O Database Writes Abnormal Latency/sec is the rate of database write operations that take an abnormally long length of time (default is 1 minute) to be serviced by the OS. [Dev Only]
IOSFileLogWriteIO_000_Help=I/O Log Writes/sec is the rate of logfile write operations completed.
IOSFileLogWriteIOTotalTicks_000_Help=I/O Log Writes Average Latency is the average length of time, in milliseconds, per logfile write operation.
IOSFileLogWriteIOTotal1_000_Help=No text
IOSFileLogWriteIOTotalBytes_000_Help=I/O Log Writes Average Bytes is the average number of bytes transferred per logfile write operation. [Dev Only]
IOSFileLogWriteIOTotal2_000_Help=No text
IOSFileLogWriteIOInHeap_000_Help=I/O Log Writes In Heap is the number of logfile write operations queued in the database engine's I/O heap and waiting to be issued. [Dev Only]
IOSFileLogWriteIOAsyncPending_000_Help=I/O Log Writes Async Pending is the number of logfile write operations asynchronously pending completion. [Dev Only]
IOSFileLogWriteIOAbnormalLatency_000_Help=I/O Log Writes Abnormal Latency/sec is the rate of logfile write operations that take an abnormally long length of time (default is 1 minute) to be serviced by the OS. [Dev Only]
