;Machine generated INI file "esentprf.ini" from "perfdata.txt" [info] drivername=ESENT symbolfile=esentprf.hxx [languages] 009=U.S. English 000=Neutral [objects] ESE_009_Name=Database TableClass_009_Name=Database ==> TableClasses Instances_009_Name=Database ==> Instances [text] ESE_009_Name=Database TableClass_009_Name=Database ==> TableClasses Instances_009_Name=Database ==> Instances PagesConvertedSec_009_Name=Pages Converted/sec PagesConvertedTotal_009_Name=Pages Converted RecordsConvertedSec_009_Name=Records Converted/sec RecordsConvertedTotal_009_Name=Records Converted OLDTasksRunning_009_Name=Defragmentation Tasks OLDTasksPending_009_Name=Defragmentation Tasks Pending OLDTasksDiscarded_009_Name=Defragmentation Tasks Discarded OLDTasksPostedPerSec_009_Name=Defragmentation Tasks Scheduled/sec OLDTasksCompletedPerSec_009_Name=Defragmentation Tasks Completed/sec OSHeapAllocPerSec_009_Name=Heap Allocs/sec OSHeapFreePerSec_009_Name=Heap Frees/sec OSHeapAlloc_009_Name=Heap Allocations OSHeapBytesAlloc_009_Name=Heap Bytes Allocated OSPageBytesReserved_009_Name=Page Bytes Reserved OSPageBytesCommitted_009_Name=Page Bytes Committed FCBAsyncScan_009_Name=FCB Asynchronous Scan/sec FCBAsyncPurge_009_Name=FCB Asynchronous Purge/sec FCBAsyncThresholdScan_009_Name=FCB Asynchronous Threshold-Scan/sec FCBAsyncThresholdPurge_009_Name=FCB Asynchronous Threshold-Purge/sec FCBAsyncPurgeConflict_009_Name=FCB Asynchronous Purge Conflicts/sec FCBSyncPurge_009_Name=FCB Synchronous Purge/sec FCBSyncPurgeStalls_009_Name=FCB Synchronous Purge Stalls/sec FCBAllocWaitForVersionCleanup_009_Name=FCB Allocations Wait For Version Cleanup/sec FCBPurgeOnClose_009_Name=FCB Purge On Cursor Close/sec FCBCacheHits_009_Name=FCB Cache % Hit FCBCacheRequests_009_Name=No name FCBCacheStalls_009_Name=FCB Cache Stalls/sec FCBCacheMax_009_Name=FCB Cache Maximum FCBCachePreferred_009_Name=FCB Cache Preferred FCBCacheAlloc_009_Name=FCB Cache Allocated FCBCacheAllocAvail_009_Name=FCB Cache Available PIBInUse_009_Name=Sessions In Use PIBUsed_009_Name=Sessions % Used PIBTotal_009_Name=No name TableOpenCacheHitRate_009_Name=Table Open Cache % Hit TableOpenCacheRequests_009_Name=No name TableOpenCacheHitsPerSec_009_Name=Table Open Cache Hits/sec TableOpenCacheMissesPerSec_009_Name=Table Open Cache Misses/sec TableOpensPerSec_009_Name=Table Opens/sec LGBytesWrittenPerSec_009_Name=Log Bytes Write/sec LGBytesGeneratedPerSec_009_Name=Log Bytes Generated/sec LGBufferBytesUsed_009_Name=Log Buffer Bytes Used LGBufferBytesFree_009_Name=Log Buffer Bytes Free LGUsersWaiting_009_Name=Log Threads Waiting LGCheckpointDepth_009_Name=Log Checkpoint Depth LGLogGenerationCheckpointDepth_009_Name=Log Generation Checkpoint Depth UserROTrxCommit0PerSec_009_Name=User Read Only Transaction Commits to Level 0/sec UserRWTrxCommit0PerSec_009_Name=User Read/Write Transaction Commits to Level 0/sec UserTrxCommit0PerSec_009_Name=User Transaction Commits to Level 0/sec UserROTrxRollback0PerSec_009_Name=User Read Only Transaction Rollbacks to Level 0/sec UserRWTrxRollback0PerSec_009_Name=User Read/Write Transaction Rollbacks to Level 0/sec UserTrxRollback0PerSec_009_Name=User Transaction Rollbacks to Level 0/sec SystemROTrxCommit0PerSec_009_Name=System Read Only Transaction Commits to Level 0/sec SystemRWTrxCommit0PerSec_009_Name=System Read/Write Transaction Commits to Level 0/sec SystemTrxCommit0PerSec_009_Name=System Transaction Commits to Level 0/sec SystemROTrxRollback0PerSec_009_Name=System Read Only Transaction Rollbacks to Level 0/sec SystemRWTrxRollback0PerSec_009_Name=System Read/Write Transaction Rollbacks to Level 0/sec SystemTrxRollback0PerSec_009_Name=System Transaction Rollbacks to Level 0/sec IODatabaseFileExtensionAsyncConsumed_009_Name=Database Page Allocation File Extension Async Consumed/sec IODatabaseFileExtensionStall_009_Name=Database Page Allocation File Extension Stalls/sec LGRecordPerSec_009_Name=Log Records/sec LGCapacityFlushPerSec_009_Name=Log Buffer Capacity Flushes/sec LGCommitFlushPerSec_009_Name=Log Buffer Commit Flushes/sec LGFlushPerSec_009_Name=Log Buffer Flushes/sec LGWritePerSec_009_Name=Log Writes/sec LGStallPerSec_009_Name=Log Record Stalls/sec VERcbucketAllocated_009_Name=Version buckets allocated VERcbucketDeleteAllocated_009_Name=Version buckets allocated for deletes VERBucketAllocWaitForVersionCleanup_009_Name=VER Bucket Allocations Wait For Version Cleanup/sec VERcbAverageBookmark_009_Name=Version store average RCE bookmark length VERUnnecessaryCalls_009_Name=Version store unnecessary calls/sec VERAsyncCleanupTasksDispatched_009_Name=Version store cleanup tasks asynchronously dispatched/sec VERSyncCleanupTasksDispatched_009_Name=Version store cleanup tasks synchronously dispatched/sec VERCleanupTasksDiscarded_009_Name=Version store cleanup tasks discarded/sec VERCleanupTasksFailed_009_Name=Version store cleanup tasks failures/sec RECInserts_009_Name=Record Inserts/sec RECDeletes_009_Name=Record Deletes/sec RECReplaces_009_Name=Record Replaces/sec RECNoOpReplaces_009_Name=Record Unnecessary Replaces/sec RECRedundantReplaces_009_Name=Record Redundant Replaces/sec RECEscrowUpdates_009_Name=Record Escrow-Updates/sec RECIndexInserts_009_Name=Secondary Index Inserts/sec RECIndexDeletes_009_Name=Secondary Index Deletes/sec RECFalseIndexColumnUpdates_009_Name=False Index Column Updates/sec RECFalseTupleIndexColumnUpdates_009_Name=False Tuple Index Column Updates/sec RECUpdateIntrinsicLV_009_Name=Record Intrinsic Long-Values Updated/sec RECAddSeparateLV_009_Name=Record Separated Long-Values Added/sec RECAddForcedSeparateLV_009_Name=Record Separated Long-Values Forced/sec RECForceSeparateAllLV_009_Name=Record Separated Long-Values All Forced/sec RECRefAllSeparateLV_009_Name=Record Separated Long-Values Reference All/sec RECDerefAllSeparateLV_009_Name=Record Separated Long-Values Dereference All/sec LVSeeks_009_Name=Separated Long-Value Seeks/sec LVRetrieves_009_Name=Separated Long-Value Retrieves/sec LVCreates_009_Name=Separated Long-Value Creates/sec LVUpdates_009_Name=Separated Long-Value Updates/sec LVDeletes_009_Name=Separated Long-Value Deletes/sec LVCopies_009_Name=Separated Long-Value Copies/sec LVChunkSeeks_009_Name=Separated Long-Value Chunk Seeks/sec LVChunkRetrieves_009_Name=Separated Long-Value Chunk Retrieves/sec LVChunkAppends_009_Name=Separated Long-Value Chunk Appends/sec LVChunkReplaces_009_Name=Separated Long-Value Chunk Replaces/sec LVChunkDeletes_009_Name=Separated Long-Value Chunk Deletes/sec LVChunkCopies_009_Name=Separated Long-Value Chunk Copies/sec BTAppendSplit_009_Name=B+ Tree Append Splits/sec BTRightSplit_009_Name=B+ Tree Right Splits/sec BTRightHotpointSplit_009_Name=B+ Tree Right Hotpoint Splits/sec BTVerticalSplit_009_Name=B+ Tree Vertical Splits/sec BTSplit_009_Name=B+ Tree Splits/sec BTEmptyPageMerge_009_Name=B+ Tree Empty Page Merges/sec BTRightMerge_009_Name=B+ Tree Right Merges/sec BTPartialMerge_009_Name=B+ Tree Partial Merges/sec BTLeftMerge_009_Name=B+ Tree Left Merges/sec BTPartialLeftMerge_009_Name=B+ Tree Partial Left Merges/sec BTPageMove_009_Name=B+ Tree Page Moves/sec BTMerge_009_Name=B+ Tree Merges/sec BTFailedSPCWriteLatch_009_Name=B+ Tree Failed Simple Page Cleanup Attempts/sec BTSeekShortCircuit_009_Name=B+ Tree Seek Short Circuits/sec BTOpportunePrereads_009_Name=B+ Tree Opportune Prereads/sec BTUnnecessarySiblingLatch_009_Name=B+ Tree Unnecessary Sibling Latches/sec BTNext_009_Name=B+ Tree Move Nexts/sec BTNextNonVisibleNodesSkipped_009_Name=B+ Tree Move Nexts (Non-Visible Nodes Skipped)/sec BTPrev_009_Name=B+ Tree Move Prevs/sec BTPrevNonVisibleNodesSkipped_009_Name=B+ Tree Move Prevs (Non-Visible Nodes Skipped)/sec BTSeek_009_Name=B+ Tree Seeks/sec BTInsert_009_Name=B+ Tree Inserts/sec BTReplace_009_Name=B+ Tree Replaces/sec BTFlagDelete_009_Name=B+ Tree Flag Deletes/sec BTDelete_009_Name=B+ Tree Deletes/sec BTAppend_009_Name=B+ Tree Appends/sec SPCreate_009_Name=B+ Tree Creates/sec SPCreateCum_009_Name=B+ Tree Creates (Total) SPDelete_009_Name=B+ Tree Destroys/sec SPDeleteCum_009_Name=B+ Tree Destroys (Total) BFCacheMisses_009_Name=Database Cache Misses/sec BFCacheHits_009_Name=Database Cache % Hit BFCacheRequests_009_Name=No name BFCacheRequestsPerSec_009_Name=Database Cache Requests/sec BFPctPinned_009_Name=Database Cache % Pinned BFTotalBuffers1_009_Name=No name BFPctClean_009_Name=Database Cache % Clean BFTotalBuffers2_009_Name=No name BFPagesReadAsyncPerSec_009_Name=Database Pages Read Async/sec BFPagesReadSyncPerSec_009_Name=Database Pages Read Sync/sec BFPagesWrittenPerSec_009_Name=Database Pages Written/sec BFCleanPagesWrittenPerSec_009_Name=Database Clean Pages Written/sec BFOpportuneWriteIssued_009_Name=Database Opportune Write Issued (Total) BFPagesTransferredPerSec_009_Name=Database Pages Transferred/sec BFLatch_009_Name=Database Page Latches/sec BFFastLatch_009_Name=Database Page Fast Latches/sec BFBadLatchHint_009_Name=Database Page Bad Latch Hints/sec BFPctFastLatch_009_Name=Database Cache % Fast Latch BFTotalLatches_009_Name=No name BFLatchConflict_009_Name=Database Page Latch Conflicts/sec BFLatchStall_009_Name=Database Page Latch Stalls/sec BFPctAvail_009_Name=Database Cache % Available BFTotalBuffers3_009_Name=No name BFCacheFault_009_Name=Database Page Faults/sec BFCacheEvict_009_Name=Database Page Evictions/sec BFAvailStallsPerSec_009_Name=Database Page Fault Stalls/sec BFCacheSizeMB_009_Name=Database Cache Size (MB) BFCacheSize_009_Name=Database Cache Size BFCacheSizeMin_009_Name=Database Cache Size Min BFCacheSizeMax_009_Name=Database Cache Size Max BFCacheSizeResident_009_Name=Database Cache Size Resident BFCacheSizeResidentMB_009_Name=Database Cache Size Resident (MB) BFPctStartFlushThreshold_009_Name=Database Cache % Available Min BFTotalBuffers4_009_Name=No name BFPctStopFlushThreshold_009_Name=Database Cache % Available Max BFTotalBuffers5_009_Name=No name BFPagesPreread_009_Name=Database Pages Preread/sec BFCachedPagesPreread_009_Name=Database Cached Pages Preread/sec BFPagesPrereadUntouched_009_Name=Database Pages Preread Untouched/sec BFPagesVersioned_009_Name=Database Pages Versioned/sec BFPagesVersionCopied_009_Name=Database Pages Version Copied/sec BFPctVersioned_009_Name=Database Cache % Versioned BFTotalBuffers6_009_Name=No name BFPagesOrdinarilyWritten_009_Name=Database Pages Ordinarily Written/sec BFPagesAnomalouslyWritten_009_Name=Database Pages Anomalously Written/sec BFPagesOpportunelyWritten_009_Name=Database Pages Opportunely Written/sec BFPagesRepeatedlyWritten_009_Name=Database Pages Repeatedly Written/sec BFPagesIdlyWritten_009_Name=Database Pages Idly Written/sec BFPagesCoalescedWritten_009_Name=Database Pages Coalesced Written/sec BFPagesCoalescedRead_009_Name=Database Pages Coalesced Read/sec BFPageHistory_009_Name=Database Page History Records BFPageHistoryHits_009_Name=Database Page History % Hit BFPageHistoryReqs_009_Name=No name BFPageScanned_009_Name=Database Page Scans/sec BFPageScannedOutOfOrder_009_Name=Database Page Scans Out-of-order/sec BFPageScannedTotal_009_Name=No name BFPctResident_009_Name=Database Cache % Resident BFTotalBuffers7_009_Name=No name BKReadIO_009_Name=Streaming Backup Pages Read/sec OLDPageReferenced_009_Name=Online Defrag Pages Referenced/sec OLDPageRead_009_Name=Online Defrag Pages Read/sec OLDPagePreread_009_Name=Online Defrag Pages Preread/sec OLDPageDirtied_009_Name=Online Defrag Pages Dirtied/sec OLDPageRedirtied_009_Name=Online Defrag Pages Re-Dirtied/sec OLDPagesFreed_009_Name=Online Defrag Pages Freed/sec OLDPagesMerged_009_Name=Online Defrag Data Moves/sec OLDPagesMoved_009_Name=Online Defrag Page Moves/sec OLDLogRecord_009_Name=Online Defrag Log Records/sec OLDLogBytes_009_Name=Online Defrag Average Log Bytes OLDLogRecordsTotal1_009_Name=No name PagesScannedSec_009_Name=Online Maintenance (DB Scan) Pages Read/sec PagesScannedTotal_009_Name=Online Maintenance (DB Scan) Pages Read PagesZeroedSec_009_Name=Online Maintenance (DB Scan) Pages Zeroed/sec PagesZeroedTotal_009_Name=Online Maintenance (DB Scan) Pages Zeroed DBTASKPageReferenced_009_Name=Database Tasks Pages Referenced/sec DBTASKPageRead_009_Name=Database Tasks Pages Read/sec DBTASKPagePreread_009_Name=Database Tasks Pages Preread/sec DBTASKPageDirtied_009_Name=Database Tasks Pages Dirtied/sec DBTASKPageRedirtied_009_Name=Database Tasks Pages Re-Dirtied/sec DBTASKLogRecord_009_Name=Database Tasks Log Records/sec DBTASKLogBytes_009_Name=Database Tasks Average Log Bytes DBTASKLogRecordsTotal1_009_Name=No name OSFileDbReadIO_009_Name=I/O Database Reads/sec OSFileDbReadIOTotalTicks_009_Name=I/O Database Reads Average Latency OSFileDbReadIOTotal1_009_Name=No name OSFileDbReadIOTotalBytes_009_Name=I/O Database Reads Average Bytes OSFileDbReadIOTotal2_009_Name=No name OSFileDbReadIOInHeap_009_Name=I/O Database Reads In Heap OSFileDbReadIOAsyncPending_009_Name=I/O Database Reads Async Pending OSFileDbReadIOAbnormalLatency_009_Name=I/O Database Reads Abnormal Latency/sec OSFileLogReadIO_009_Name=I/O Log Reads/sec OSFileLogReadIOTotalTicks_009_Name=I/O Log Reads Average Latency OSFileLogReadIOTotal1_009_Name=No name OSFileLogReadIOTotalBytes_009_Name=I/O Log Reads Average Bytes OSFileLogReadIOTotal2_009_Name=No name OSFileLogReadIOInHeap_009_Name=I/O Log Reads In Heap OSFileLogReadIOAsyncPending_009_Name=I/O Log Reads Async Pending OSFileLogReadIOAbnormalLatency_009_Name=I/O Log Reads Abnormal Latency/sec OSFileDbWriteIO_009_Name=I/O Database Writes/sec OSFileDbWriteIOTotalTicks_009_Name=I/O Database Writes Average Latency OSFileDbWriteIOTotal1_009_Name=No name OSFileDbWriteIOTotalBytes_009_Name=I/O Database Writes Average Bytes OSFileDbWriteIOTotal2_009_Name=No name OSFileDbWriteIOInHeap_009_Name=I/O Database Writes In Heap OSFileDbWriteIOAsyncPending_009_Name=I/O Database Writes Async Pending OSFileDbWriteIOAbnormalLatency_009_Name=I/O Database Writes Abnormal Latency/sec OSFileLogWriteIO_009_Name=I/O Log Writes/sec OSFileLogWriteIOTotalTicks_009_Name=I/O Log Writes Average Latency OSFileLogWriteIOTotal1_009_Name=No name OSFileLogWriteIOTotalBytes_009_Name=I/O Log Writes Average Bytes OSFileLogWriteIOTotal2_009_Name=No name OSFileLogWriteIOInHeap_009_Name=I/O Log Writes In Heap OSFileLogWriteIOAsyncPending_009_Name=I/O Log Writes Async Pending OSFileLogWriteIOAbnormalLatency_009_Name=I/O Log Writes Abnormal Latency/sec OSSYNCThreadBlock_009_Name=Threads Blocked/sec OSSYNCThreadsBlocked_009_Name=Threads Blocked FailedXpressCompressionBytesPerSec_009_Name=Record Failed Compression Bytes/sec TRECInserts_009_Name=Record Inserts/sec TRECDeletes_009_Name=Record Deletes/sec TRECReplaces_009_Name=Record Replaces/sec TRECNoOpReplaces_009_Name=Record Unnecessary Replaces/sec TRECRedundantReplaces_009_Name=Record Redundant Replaces/sec TRECEscrowUpdates_009_Name=Record Escrow-Updates/sec TRECIndexInserts_009_Name=Secondary Index Inserts/sec TRECIndexDeletes_009_Name=Secondary Index Deletes/sec TRECFalseIndexColumnUpdates_009_Name=False Index Column Updates/sec TRECFalseTupleIndexColumnUpdates_009_Name=False Tuple Index Column Updates/sec TRECUpdateIntrinsicLV_009_Name=Record Intrinsic Long-Values Updated/sec TRECAddSeparateLV_009_Name=Record Separated Long-Values Added/sec TRECAddForcedSeparateLV_009_Name=Record Separated Long-Values Forced/sec TRECForceSeparateAllLV_009_Name=Record Separated Long-Values All Forced/sec TRECRefAllSeparateLV_009_Name=Record Separated Long-Values Reference All/sec TRECDerefAllSeparateLV_009_Name=Record Separated Long-Values Dereference All/sec TLVSeeks_009_Name=Separated Long-Value Seeks/sec TLVRetrieves_009_Name=Separated Long-Value Retrieves/sec TLVCreates_009_Name=Separated Long-Value Creates/sec TLVUpdates_009_Name=Separated Long-Value Updates/sec TLVDeletes_009_Name=Separated Long-Value Deletes/sec TLVCopies_009_Name=Separated Long-Value Copies/sec TLVChunkSeeks_009_Name=Separated Long-Value Chunk Seeks/sec TLVChunkRetrieves_009_Name=Separated Long-Value Chunk Retrieves/sec TLVChunkAppends_009_Name=Separated Long-Value Chunk Appends/sec TLVChunkReplaces_009_Name=Separated Long-Value Chunk Replaces/sec TLVChunkDeletes_009_Name=Separated Long-Value Chunk Deletes/sec TLVChunkCopies_009_Name=Separated Long-Value Chunk Copies/sec TBTAppendSplit_009_Name=B+ Tree Append Splits/sec TBTRightSplit_009_Name=B+ Tree Right Splits/sec TBTRightHotpointSplit_009_Name=B+ Tree Right Hotpoint Splits/sec TBTVerticalSplit_009_Name=B+ Tree Vertical Splits/sec TBTSplit_009_Name=B+ Tree Splits/sec TBTEmptyPageMerge_009_Name=B+ Tree Empty Page Merges/sec TBTRightMerge_009_Name=B+ Tree Right Merges/sec TBTPartialMerge_009_Name=B+ Tree Partial Merges/sec TBTLeftMerge_009_Name=B+ Tree Left Merges/sec TBTPartialLeftMerge_009_Name=B+ Tree Partial Left Merges/sec TBTPageMove_009_Name=B+ Tree Page Moves/sec TBTMerge_009_Name=B+ Tree Merges/sec TBTFailedSPCWriteLatch_009_Name=B+ Tree Failed Simple Page Cleanup Attempts/sec TBTSeekShortCircuit_009_Name=B+ Tree Seek Short Circuits/sec TBTOpportunePrereads_009_Name=B+ Tree Opportune Prereads/sec TBTUnnecessarySiblingLatch_009_Name=B+ Tree Unnecessary Sibling Latches/sec TBTNext_009_Name=B+ Tree Move Nexts/sec TBTNextNonVisibleNodesSkipped_009_Name=B+ Tree Move Nexts (Non-Visible Nodes Skipped)/sec TBTPrev_009_Name=B+ Tree Move Prevs/sec TBTPrevNonVisibleNodesSkipped_009_Name=B+ Tree Move Prevs (Non-Visible Nodes Skipped)/sec TBTSeek_009_Name=B+ Tree Seeks/sec TBTInsert_009_Name=B+ Tree Inserts/sec TBTReplace_009_Name=B+ Tree Replaces/sec TBTFlagDelete_009_Name=B+ Tree Flag Deletes/sec TBTDelete_009_Name=B+ Tree Deletes/sec TBTAppend_009_Name=B+ Tree Appends/sec TSPCreate_009_Name=B+ Tree Creates/sec TSPCreateCum_009_Name=B+ Tree Creates (Total) TSPDelete_009_Name=B+ Tree Destroys/sec TSPDeleteCum_009_Name=B+ Tree Destroys (Total) TBFCacheSizeMB_009_Name=Database Cache Size (MB) TBFCacheMisses_009_Name=Database Cache Misses/sec TBFCacheHits_009_Name=Database Cache % Hit TBFCacheRequests_009_Name=No name TBFCacheRequestsPerSec_009_Name=Database Cache Requests/sec TBFPagesReadAsyncPerSec_009_Name=Database Pages Read Async/sec TBFPagesReadSyncPerSec_009_Name=Database Pages Read Sync/sec TBFPagesWrittenPerSec_009_Name=Database Pages Written/sec TBFCleanPagesWrittenPerSec_009_Name=Database Clean Pages Written/sec TBFPagesTransferredPerSec_009_Name=Database Pages Transferred/sec TBFPagesPreread_009_Name=Database Pages Preread/sec TBFCachedPagesPreread_009_Name=Database Cached Pages Preread/sec TBFPagesPrereadUntouched_009_Name=Database Pages Preread Untouched/sec TBFPagesVersioned_009_Name=Database Pages Versioned/sec TBFPagesVersionCopied_009_Name=Database Pages Version Copied/sec TBFPagesOrdinarilyWritten_009_Name=Database Pages Ordinarily Written/sec TBFPagesAnomalouslyWritten_009_Name=Database Pages Anomalously Written/sec TBFPagesOpportunelyWritten_009_Name=Database Pages Opportunely Written/sec TBFPagesRepeatedlyWritten_009_Name=Database Pages Repeatedly Written/sec TBFPagesIdlyWritten_009_Name=Database Pages Idly Written/sec TBFPagesCoalescedWritten_009_Name=Database Pages Coalesced Written/sec TBFPagesCoalescedRead_009_Name=Database Pages Coalesced Read/sec IPagesConvertedSec_009_Name=Pages Converted/sec IPagesConvertedTotal_009_Name=Pages Converted IRecordsConvertedSec_009_Name=Records Converted/sec IRecordsConvertedTotal_009_Name=Records Converted IOLDTasksRunning_009_Name=Defragmentation Tasks IOLDTasksPending_009_Name=Defragmentation Tasks Pending IOLDTasksDiscarded_009_Name=Defragmentation Tasks Discarded IOLDTasksPostedPerSec_009_Name=Defragmentation Tasks Scheduled/sec IOLDTasksCompletedPerSec_009_Name=Defragmentation Tasks Completed/sec IFCBAsyncScan_009_Name=FCB Asynchronous Scan/sec IFCBAsyncPurge_009_Name=FCB Asynchronous Purge/sec IFCBAsyncThresholdScan_009_Name=FCB Asynchronous Threshold-Scan/sec IFCBAsyncThresholdPurge_009_Name=FCB Asynchronous Threshold-Purge/sec IFCBAsyncPurgeConflict_009_Name=FCB Asynchronous Purge Conflicts/sec IFCBSyncPurge_009_Name=FCB Synchronous Purge/sec IFCBSyncPurgeStalls_009_Name=FCB Synchronous Purge Stalls/sec IFCBAllocWaitForVersionCleanup_009_Name=FCB Allocations Wait For Version Cleanup/sec IFCBPurgeOnClose_009_Name=FCB Purge On Cursor Close/sec IFCBCacheHits_009_Name=FCB Cache % Hit IFCBCacheRequests_009_Name=No name IFCBCacheStalls_009_Name=FCB Cache Stalls/sec IFCBCacheMax_009_Name=FCB Cache Maximum IFCBCachePreferred_009_Name=FCB Cache Preferred IFCBCacheAlloc_009_Name=FCB Cache Allocated IFCBCacheAllocAvail_009_Name=FCB Cache Available IPIBInUse_009_Name=Sessions In Use IPIBUsed_009_Name=Sessions % Used IPIBTotal_009_Name=No name ITableOpenCacheHitRate_009_Name=Table Open Cache % Hit ITableOpenCacheRequests_009_Name=No name ITableOpenCacheHitsPerSec_009_Name=Table Open Cache Hits/sec ITableOpenCacheMissesPerSec_009_Name=Table Open Cache Misses/sec ITableOpensPerSec_009_Name=Table Opens/sec ILGBytesWrittenPerSec_009_Name=Log Bytes Write/sec ILGBytesGeneratedPerSec_009_Name=Log Bytes Generated/sec ILGBufferSize_009_Name=Log Buffer Size ILGBufferBytesUsed_009_Name=Log Buffer Bytes Used ILGBufferBytesFree_009_Name=Log Buffer Bytes Free ILGUsersWaiting_009_Name=Log Threads Waiting ILGFileSize_009_Name=Log File Size ILGCheckpointDepth_009_Name=Log Checkpoint Depth ILGLogGenerationCheckpointDepth_009_Name=Log Generation Checkpoint Depth ILGLogGenerationCheckpointDepthTarget_009_Name=Log Generation Checkpoint Depth Target ILGLogCheckpointDepthAsAPctOfTarget_009_Name=Log Checkpoint Depth as a % of Target ILGLogGenerationCheckpointDepthTarget2_009_Name=No name ILGLogGenerationCheckpointDepthMax_009_Name=Log Generation Checkpoint Depth Max ILGLogGenerationWaypointDepth_009_Name=Log Generation Loss Resiliency Depth ILGLogFileGenerated_009_Name=Log Files Generated ILGLogFileGeneratedPrematurely_009_Name=Log Files Generated Prematurely ILGLogFileCurrentGeneration_009_Name=Log File Current Generation IUserROTrxCommit0PerSec_009_Name=User Read Only Transaction Commits to Level 0/sec IUserRWTrxCommit0PerSec_009_Name=User Read/Write Transaction Commits to Level 0/sec IUserTrxCommit0PerSec_009_Name=User Transaction Commits to Level 0/sec IUserROTrxRollback0PerSec_009_Name=User Read Only Transaction Rollbacks to Level 0/sec IUserRWTrxRollback0PerSec_009_Name=User Read/Write Transaction Rollbacks to Level 0/sec IUserTrxRollback0PerSec_009_Name=User Transaction Rollbacks to Level 0/sec ISystemROTrxCommit0PerSec_009_Name=System Read Only Transaction Commits to Level 0/sec ISystemRWTrxCommit0PerSec_009_Name=System Read/Write Transaction Commits to Level 0/sec ISystemTrxCommit0PerSec_009_Name=System Transaction Commits to Level 0/sec ISystemROTrxRollback0PerSec_009_Name=System Read Only Transaction Rollbacks to Level 0/sec ISystemRWTrxRollback0PerSec_009_Name=System Read/Write Transaction Rollbacks to Level 0/sec ISystemTrxRollback0PerSec_009_Name=System Transaction Rollbacks to Level 0/sec IIODatabaseFileExtensionAsyncConsumed_009_Name=Database Page Allocation File Extension Async Consumed/sec IIODatabaseFileExtensionStall_009_Name=Database Page Allocation File Extension Stalls/sec ILGRecordPerSec_009_Name=Log Records/sec ILGCapacityFlushPerSec_009_Name=Log Buffer Capacity Flushes/sec ILGCommitFlushPerSec_009_Name=Log Buffer Commit Flushes/sec ILGFlushPerSec_009_Name=Log Buffer Flushes/sec ILGWritePerSec_009_Name=Log Writes/sec ILGStallPerSec_009_Name=Log Record Stalls/sec IVERcbucketAllocated_009_Name=Version buckets allocated IVERcbucketDeleteAllocated_009_Name=Version buckets allocated for deletes IVERBucketAllocWaitForVersionCleanup_009_Name=VER Bucket Allocations Wait For Version Cleanup/sec IVERcbAverageBookmark_009_Name=Version store average RCE bookmark length IVERUnnecessaryCalls_009_Name=Version store unnecessary calls/sec IVERAsyncCleanupDispatched_009_Name=Version store cleanup tasks asynchronously dispatched/sec IVERSyncCleanupDispatched_009_Name=Version store cleanup tasks synchronously dispatched/sec IVERCleanupDiscarded_009_Name=Version store cleanup tasks discarded/sec IVERCleanupFailed_009_Name=Version store cleanup tasks failures/sec IRECInserts_009_Name=Record Inserts/sec IRECDeletes_009_Name=Record Deletes/sec IRECReplaces_009_Name=Record Replaces/sec IRECNoOpReplaces_009_Name=Record Unnecessary Replaces/sec IRECRedundantReplaces_009_Name=Record Redundant Replaces/sec IRECEscrowUpdates_009_Name=Record Escrow-Updates/sec IRECIndexInserts_009_Name=Secondary Index Inserts/sec IRECIndexDeletes_009_Name=Secondary Index Deletes/sec IRECFalseIndexColumnUpdates_009_Name=False Index Column Updates/sec IRECFalseTupleIndexColumnUpdates_009_Name=False Tuple Index Column Updates/sec IRECUpdateIntrinsicLV_009_Name=Record Intrinsic Long-Values Updated/sec IRECAddSeparateLV_009_Name=Record Separated Long-Values Added/sec IRECAddForcedSeparateLV_009_Name=Record Separated Long-Values Forced/sec IRECForceSeparateAllLV_009_Name=Record Separated Long-Values All Forced/sec IRECRefAllSeparateLV_009_Name=Record Separated Long-Values Reference All/sec IRECDerefAllSeparateLV_009_Name=Record Separated Long-Values Dereference All/sec ILVSeeks_009_Name=Separated Long-Value Seeks/sec ILVRetrieves_009_Name=Separated Long-Value Retrieves/sec ILVCreates_009_Name=Separated Long-Value Creates/sec ILVUpdates_009_Name=Separated Long-Value Updates/sec ILVDeletes_009_Name=Separated Long-Value Deletes/sec ILVCopies_009_Name=Separated Long-Value Copies/sec ILVChunkSeeks_009_Name=Separated Long-Value Chunk Seeks/sec ILVChunkRetrieves_009_Name=Separated Long-Value Chunk Retrieves/sec ILVChunkAppends_009_Name=Separated Long-Value Chunk Appends/sec ILVChunkReplaces_009_Name=Separated Long-Value Chunk Replaces/sec ILVChunkDeletes_009_Name=Separated Long-Value Chunk Deletes/sec ILVChunkCopies_009_Name=Separated Long-Value Chunk Copies/sec IBTAppendSplit_009_Name=B+ Tree Append Splits/sec IBTRightSplit_009_Name=B+ Tree Right Splits/sec IBTRightHotpointSplit_009_Name=B+ Tree Right Hotpoint Splits/sec IBTVerticalSplit_009_Name=B+ Tree Vertical Splits/sec IBTSplit_009_Name=B+ Tree Splits/sec IBTEmptyPageMerge_009_Name=B+ Tree Empty Page Merges/sec IBTRightMerge_009_Name=B+ Tree Right Merges/sec IBTPartialMerge_009_Name=B+ Tree Partial Merges/sec IBTLeftMerge_009_Name=B+ Tree Left Merges/sec IBTPartialLeftMerge_009_Name=B+ Tree Partial Left Merges/sec IBTPageMove_009_Name=B+ Tree Page Moves/sec IBTMerge_009_Name=B+ Tree Merges/sec IBTFailedSPCWriteLatch_009_Name=B+ Tree Failed Simple Page Cleanup Attempts/sec IBTSeekShortCircuit_009_Name=B+ Tree Seek Short Circuits/sec IBTOpportunePrereads_009_Name=B+ Tree Opportune Prereads/sec IBTUnnecessarySiblingLatch_009_Name=B+ Tree Unnecessary Sibling Latches/sec IBTNext_009_Name=B+ Tree Move Nexts/sec IBTNextNonVisibleNodesSkipped_009_Name=B+ Tree Move Nexts (Non-Visible Nodes Skipped)/sec IBTPrev_009_Name=B+ Tree Move Prevs/sec IBTPrevNonVisibleNodesSkipped_009_Name=B+ Tree Move Prevs (Non-Visible Nodes Skipped)/sec IBTSeek_009_Name=B+ Tree Seeks/sec IBTInsert_009_Name=B+ Tree Inserts/sec IBTReplace_009_Name=B+ Tree Replaces/sec IBTFlagDelete_009_Name=B+ Tree Flag Deletes/sec IBTDelete_009_Name=B+ Tree Deletes/sec IBTAppend_009_Name=B+ Tree Appends/sec ISPCreate_009_Name=B+ Tree Creates/sec ISPCreateCum_009_Name=B+ Tree Creates (Total) ISPDelete_009_Name=B+ Tree Destroys/sec ISPDeleteCum_009_Name=B+ Tree Destroys (Total) IBFCacheSizeMB_009_Name=Database Cache Size (MB) IBFCacheMisses_009_Name=Database Cache Misses/sec IBFCacheHits_009_Name=Database Cache % Hit IBFCacheRequests_009_Name=No name IBFCacheRequestsPerSec_009_Name=Database Cache Requests/sec IBFPagesReadAsyncPerSec_009_Name=Database Pages Read Async/sec IBFPagesReadSyncPerSec_009_Name=Database Pages Read Sync/sec IBFPagesWrittenPerSec_009_Name=Database Pages Written/sec IBFCleanPagesWrittenPerSec_009_Name=Database Clean Pages Written/sec IBFPagesTransferredPerSec_009_Name=Database Pages Transferred/sec IBFPagesPreread_009_Name=Database Pages Preread/sec IBFCachedPagesPreread_009_Name=Database Cached Pages Preread/sec IBFPagesPrereadUntouched_009_Name=Database Pages Preread Untouched/sec IBFPagesVersioned_009_Name=Database Pages Versioned/sec IBFPagesVersionCopied_009_Name=Database Pages Version Copied/sec IBFPagesOrdinarilyWritten_009_Name=Database Pages Ordinarily Written/sec IBFPagesAnomalouslyWritten_009_Name=Database Pages Anomalously Written/sec IBFPagesOpportunelyWritten_009_Name=Database Pages Opportunely Written/sec IBFPagesRepeatedlyWritten_009_Name=Database Pages Repeatedly Written/sec IBFPagesIdlyWritten_009_Name=Database Pages Idly Written/sec IBFPagesCoalescedWritten_009_Name=Database Pages Coalesced Written/sec IBFPagesCoalescedRead_009_Name=Database Pages Coalesced Read/sec IBKReadIO_009_Name=Streaming Backup Pages Read/sec IOLDPageReferenced_009_Name=Online Defrag Pages Referenced/sec IOLDPageRead_009_Name=Online Defrag Pages Read/sec IOLDPagePreread_009_Name=Online Defrag Pages Preread/sec IOLDPageDirtied_009_Name=Online Defrag Pages Dirtied/sec IOLDPageRedirtied_009_Name=Online Defrag Pages Re-Dirtied/sec IOLDPagesFreed_009_Name=Online Defrag Pages Freed/sec IOLDPagesMerged_009_Name=Online Defrag Data Moves/sec IOLDPagesMoved_009_Name=Online Defrag Page Moves/sec IOLDLogRecord_009_Name=Online Defrag Log Records/sec IOLDLogBytes_009_Name=Online Defrag Average Log Bytes IOLDLogRecordsTotal1_009_Name=No name IPagesScannedSec_009_Name=Online Maintenance (DB Scan) Pages Read/sec IPagesScannedTotal_009_Name=Online Maintenance (DB Scan) Pages Read IPagesZeroedSec_009_Name=Online Maintenance (DB Scan) Pages Zeroed/sec IPagesZeroedTotal_009_Name=Online Maintenance (DB Scan) Pages Zeroed IDBTASKPageReferenced_009_Name=Database Tasks Pages Referenced/sec IDBTASKPageRead_009_Name=Database Tasks Pages Read/sec IDBTASKPagePreread_009_Name=Database Tasks Pages Preread/sec IDBTASKPageDirtied_009_Name=Database Tasks Pages Dirtied/sec IDBTASKPageRedirtied_009_Name=Database Tasks Pages Re-Dirtied/sec IDBTASKLogRecord_009_Name=Database Tasks Log Records/sec IDBTASKLogBytes_009_Name=Database Tasks Average Log Bytes IDBTASKLogRecordsTotal1_009_Name=No name IOSFileDbReadIO_009_Name=I/O Database Reads/sec IOSFileDbReadIOTotalTicks_009_Name=I/O Database Reads Average Latency IOSFileDbReadIOTotal1_009_Name=No name IOSFileDbReadIOTotalBytes_009_Name=I/O Database Reads Average Bytes IOSFileDbReadIOTotal2_009_Name=No name IOSFileDbReadIOInHeap_009_Name=I/O Database Reads In Heap IOSFileDbReadIOAsyncPending_009_Name=I/O Database Reads Async Pending IOSFileDbReadIOAbnormalLatency_009_Name=I/O Database Reads Abnormal Latency/sec IOSFileLogReadIO_009_Name=I/O Log Reads/sec IOSFileLogReadIOTotalTicks_009_Name=I/O Log Reads Average Latency IOSFileLogReadIOTotal1_009_Name=No name IOSFileLogReadIOTotalBytes_009_Name=I/O Log Reads Average Bytes IOSFileLogReadIOTotal2_009_Name=No name IOSFileLogReadIOInHeap_009_Name=I/O Log Reads In Heap IOSFileLogReadIOAsyncPending_009_Name=I/O Log Reads Async Pending IOSFileLogReadIOAbnormalLatency_009_Name=I/O Log Reads Abnormal Latency/sec IOSFileDbWriteIO_009_Name=I/O Database Writes/sec IOSFileDbWriteIOTotalTicks_009_Name=I/O Database Writes Average Latency IOSFileDbWriteIOTotal1_009_Name=No name IOSFileDbWriteIOTotalBytes_009_Name=I/O Database Writes Average Bytes IOSFileDbWriteIOTotal2_009_Name=No name IOSFileDbWriteIOInHeap_009_Name=I/O Database Writes In Heap IOSFileDbWriteIOAsyncPending_009_Name=I/O Database Writes Async Pending IOSFileDbWriteIOAbnormalLatency_009_Name=I/O Database Writes Abnormal Latency/sec IOSFileLogWriteIO_009_Name=I/O Log Writes/sec IOSFileLogWriteIOTotalTicks_009_Name=I/O Log Writes Average Latency IOSFileLogWriteIOTotal1_009_Name=No name IOSFileLogWriteIOTotalBytes_009_Name=I/O Log Writes Average Bytes IOSFileLogWriteIOTotal2_009_Name=No name IOSFileLogWriteIOInHeap_009_Name=I/O Log Writes In Heap IOSFileLogWriteIOAsyncPending_009_Name=I/O Log Writes Async Pending IOSFileLogWriteIOAbnormalLatency_009_Name=I/O Log Writes Abnormal Latency/sec IFailedXpressCompressionBytesPerSec_009_Name=Record Failed Compression Bytes/sec 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 OLDTasksRunning_009_Help=Defragmentation Tasks is the count of background database defragmentation tasks that are currently executing. OLDTasksPending_009_Help=Defragmentation Tasks Pending is the count of background database defragmentation tasks that are currently pending. OLDTasksDiscarded_009_Help=Defragmentation Tasks Discarded is the count of background database defragmentation tasks that could not be registered. [Dev Only] OLDTasksPostedPerSec_009_Help=Defragmentation Tasks Scheduled/sec is the number of background database defragmentation tasks scheduled for execution per second. [Dev Only] OLDTasksCompletedPerSec_009_Help=Defragmentation Tasks Completed/sec is the number of background database defragmentation tasks completing execution per second. [Dev Only] 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. PIBUsed_009_Help=Sessions % Used is the percentage of database sessions currently open for use by client threads. 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. LGBytesGeneratedPerSec_009_Help=Log Bytes Generated per second is the rate at which data is added to the log. This is different from Log Bytes Write per second in that each byte is generated only once whereas each byte may be written many times. 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. [Dev Only] 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] BTLeftMerge_009_Help=B+ Tree Left Merges/sec is the count of pages removed from a database B+ Tree per second by moving all its records to the previous page to the left. [Dev Only] BTPartialLeftMerge_009_Help=B+ Tree Partial Left Merges/sec is the count of pages where some of its records are moved to a page on the left in a database B+ Tree per second. [Dev Only] BTPageMove_009_Help=B+ Tree Page Moves/sec is the count of B+ Tree pages per second where all the records are moved to a new page. [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] BTOpportunePrereads_009_Help=B+ Tree Opportune Prereads/sec is the number of pages per second that are preread because they are adjacent to a page read by a seek. [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] BFCacheMisses_009_Help=Database Cache Misses per second is the rate at which database file page requests were fulfilled by the database cache by causing a file operation. If this rate is high then the database cache size may be too small. 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 BFCacheRequestsPerSec_009_Help=Database Cache Requests/sec is the rate that pages are requested from the database cache. BFPctPinned_009_Help=Database Cache % Pinned is the percentage of the database cache that pinned in the memory. [Dev Only] BFTotalBuffers1_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] BFCleanPagesWrittenPerSec_009_Help=Database Clean Pages Written/sec is the rate that pages are written to the database file (s) from the database cache. [Dev Only] BFOpportuneWriteIssued_009_Help=Database Opportune Write Issued (Total) is the count of IO operationshas been issued for opportune write. [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] BFCacheSizeResident_009_Help=Database Cache Size Resident is the amount of system memory used by the database cache that is currently part of the working set of the process. If Database Cache Size Resident is ever significantly smaller than Database Cache Size then the operating system has chosen to reclaim that system memory for use in other parts of the system. The database cache will recover from this event but if this is a common occurrence then it can lead to significant performance problems. BFCacheSizeResidentMB_009_Help=Database Cache Size Resident (MB) is the amount of system memory (in MegaBytes) used by the database cache that is currently part of the working set of the process. If Database Cache Size Resident (MB) is ever significantly smaller than Database Cache Size (MB) then the operating system has chosen to reclaim that system memory for use in other parts of the system. The database cache will recover from this event but if this is a common occurrence then it can lead to significant performance problems. 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] BFPagesVersionCopied_009_Help=Database Pages Version Copied/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 BFPctResident_009_Help=Database Cache % Resident is the percentage of the database cache that are currently in the process's working set. [Dev Only] BFTotalBuffers7_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] OLDPagesFreed_009_Help=Pages Freed/sec is the number of pages per second that are freed from the database by the online defragmentation process [Dev Only] OLDPagesMerged_009_Help=Data Moves/sec is the number of times per second that data is moved from one page to another by the online defragmentation process [Dev Only] OLDPagesMoved_009_Help=Page Moves/sec is the number of times per second that data is moved from one page to a new page by the online defragmentation process [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 PagesScannedSec_009_Help=Pages Read/sec is the number of pages per second that are read from the database by the scanning process [Dev Only] PagesScannedTotal_009_Help=Pages Read is the number of pages that have been read from the database by the scanning process [Dev Only] PagesZeroedSec_009_Help=Pages Read/sec is the number of pages per second that are zeroed in the database by the scanning process [Dev Only] PagesZeroedTotal_009_Help=Pages Read is the number of pages that have been zeroed in the database by the scanning process [Dev Only] 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] 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] FailedXpressCompressionBytesPerSec_009_Help=Record Failed Compression Bytes/sec is the rate of record bytes that either failed Xpress compression or did not significantly reduce the insert/replace size (10% or less). High results are indicative of wasted cpu resources. [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] TBTLeftMerge_009_Help=B+ Tree Left Merges/sec is the count of pages removed from a database B+ Tree per second by moving all its records to the previous page to the left. [Dev Only] TBTPartialLeftMerge_009_Help=B+ Tree Partial Left Merges/sec is the count of pages where some of its records are moved to a page on the left in a database B+ Tree per second. [Dev Only] TBTPageMove_009_Help=B+ Tree Page Moves/sec is the count of B+ Tree pages per second where all the records are moved to a new page. [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] TBTOpportunePrereads_009_Help=B+ Tree Opportune Prereads/sec is the number of pages per second that are preread because they are adjacent to a page read by a seek. [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. TBFCacheMisses_009_Help=Database Cache Misses per second is the rate at which database file page requests were fulfilled by the database cache by causing a file operation. If this rate is high then the database cache size may be too small. TBFCacheHits_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. TBFCacheRequests_009_Help=No text TBFCacheRequestsPerSec_009_Help=Database Cache Requests/sec is the rate that pages are requested from the database cache. 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] TBFCleanPagesWrittenPerSec_009_Help=Database Clean 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] TBFPagesVersionCopied_009_Help=Database Pages Version Copied/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 IOLDTasksRunning_009_Help=Defragmentation Tasks is the count of background database defragmentation tasks that are currently executing. IOLDTasksPending_009_Help=Defragmentation Tasks Pending is the count of background database defragmentation tasks that are currently pending. IOLDTasksDiscarded_009_Help=Defragmentation Tasks Discarded is the count of background database defragmentation tasks that could not be registered. [Dev Only] IOLDTasksPostedPerSec_009_Help=Defragmentation Tasks Scheduled/sec is the number of background database defragmentation tasks scheduled for execution per second. [Dev Only] IOLDTasksCompletedPerSec_009_Help=Defragmentation Tasks Completed/sec is the number of background database defragmentation tasks completing execution per second. [Dev Only] 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. IPIBUsed_009_Help=Sessions % Used is the percentage of database sessions currently open for use by client threads. 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. ILGBytesGeneratedPerSec_009_Help=Log Bytes Generated per second is the rate at which data is added to the log. This is different from Log Bytes Write per second in that each byte is generated only once whereas each byte may be written many times. 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. ILGLogGenerationCheckpointDepthTarget_009_Help=Log Generation Checkpoint Depth Target represents the ideal target for the amount of work, in count of log files, that may be redone or undone to the database file(s) if the process crashes. ILGLogCheckpointDepthAsAPctOfTarget_009_Help=Log Checkpoint Depth as a % of Target is an expression of the current checkpoint depth in terms of a percentage of the checkpoint depth target. For example, if the current checkpoint depth is 5 generations and the checkpoint depth target is 4 generations then this will be reported as 125% of target. ILGLogGenerationCheckpointDepthTarget2_009_Help=No text ILGLogGenerationCheckpointDepthMax_009_Help=Log Generation Checkpoint Depth Max represents the maximum allowable amount of work, in count of log files, that may be redone or undone to the database file(s) if the process crashes. ILGLogGenerationWaypointDepth_009_Help=Log Generation Loss Resiliency Depth represents the amount of work, in count of log files, that may be lost while still allowing the database file(s) to recover (with data loss) if the process crashes. ILGLogFileGenerated_009_Help=Log Files Generated represents the total number of log files generated by an instance since that instance was last initialized. ILGLogFileGeneratedPrematurely_009_Help=Log Files Generated Prematurely represents the total number of log files generated by an instance since that instance was last initialized and that have not been entirely filled with useful data. Under certain conditions the database engine will choose to switch to a new log file before it has been completely filled with useful data. ILGLogFileCurrentGeneration_009_Help=Log File Current Generation gives the generation number of the current log file of an instance. 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. [Dev Only] 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] IBTLeftMerge_009_Help=B+ Tree Left Merges/sec is the count of pages removed from a database B+ Tree per second by moving all its records to the previous page to the left. [Dev Only] IBTPartialLeftMerge_009_Help=B+ Tree Partial Left Merges/sec is the count of pages where some of its records are moved to a page on the left in a database B+ Tree per second. [Dev Only] IBTPageMove_009_Help=B+ Tree Page Moves/sec is the count of B+ Tree pages per second where all the records are moved to a new page. [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] IBTOpportunePrereads_009_Help=B+ Tree Opportune Prereads/sec is the number of pages per second that are preread because they are adjacent to a page read by a seek. [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] IBFCacheSizeMB_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. IBFCacheMisses_009_Help=Database Cache Misses per second is the rate at which database file page requests were fulfilled by the database cache by causing a file operation. If this rate is high then the database cache size may be too small. IBFCacheHits_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. IBFCacheRequests_009_Help=No text IBFCacheRequestsPerSec_009_Help=Database Cache Requests/sec is the rate that pages are requested from the database cache. 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] IBFCleanPagesWrittenPerSec_009_Help=Database Clean 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] IBFPagesVersionCopied_009_Help=Database Pages Version Copied/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 operations performed 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] IOLDPagesFreed_009_Help=Pages Freed/sec is the number of pages per second that are freed from the database by the online defragmentation process [Dev Only] IOLDPagesMerged_009_Help=Data Moves/sec is the number of times per second that data is moved from one page to another by the online defragmentation process [Dev Only] IOLDPagesMoved_009_Help=Page Moves/sec is the number of times per second that data is moved from one page to a new page by the online defragmentation process [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 IPagesScannedSec_009_Help=Pages Read/sec is the number of pages per second that are read from the database by the scanning process [Dev Only] IPagesScannedTotal_009_Help=Pages Read is the number of pages that have been read from the database by the scanning process [Dev Only] IPagesZeroedSec_009_Help=Pages Read/sec is the number of pages per second that are zeroed in the database by the scanning process [Dev Only] IPagesZeroedTotal_009_Help=Pages Read is the number of pages that have been zeroed in the database by the scanning process [Dev Only] 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] IFailedXpressCompressionBytesPerSec_009_Help=Record Failed Compression Bytes/sec is the rate of record bytes that either failed Xpress compression or did not significantly reduce the insert/replace size (10% or less). High results are indicative of wasted cpu resources. [Dev Only] ESE_000_Name=Database TableClass_000_Name=Database ==> TableClasses Instances_000_Name=Database ==> Instances PagesConvertedSec_000_Name=Pages Converted/sec PagesConvertedTotal_000_Name=Pages Converted RecordsConvertedSec_000_Name=Records Converted/sec RecordsConvertedTotal_000_Name=Records Converted OLDTasksRunning_000_Name=Defragmentation Tasks OLDTasksPending_000_Name=Defragmentation Tasks Pending OLDTasksDiscarded_000_Name=Defragmentation Tasks Discarded OLDTasksPostedPerSec_000_Name=Defragmentation Tasks Scheduled/sec OLDTasksCompletedPerSec_000_Name=Defragmentation Tasks Completed/sec OSHeapAllocPerSec_000_Name=Heap Allocs/sec OSHeapFreePerSec_000_Name=Heap Frees/sec OSHeapAlloc_000_Name=Heap Allocations OSHeapBytesAlloc_000_Name=Heap Bytes Allocated OSPageBytesReserved_000_Name=Page Bytes Reserved OSPageBytesCommitted_000_Name=Page Bytes Committed FCBAsyncScan_000_Name=FCB Asynchronous Scan/sec FCBAsyncPurge_000_Name=FCB Asynchronous Purge/sec FCBAsyncThresholdScan_000_Name=FCB Asynchronous Threshold-Scan/sec FCBAsyncThresholdPurge_000_Name=FCB Asynchronous Threshold-Purge/sec FCBAsyncPurgeConflict_000_Name=FCB Asynchronous Purge Conflicts/sec FCBSyncPurge_000_Name=FCB Synchronous Purge/sec FCBSyncPurgeStalls_000_Name=FCB Synchronous Purge Stalls/sec FCBAllocWaitForVersionCleanup_000_Name=FCB Allocations Wait For Version Cleanup/sec FCBPurgeOnClose_000_Name=FCB Purge On Cursor Close/sec FCBCacheHits_000_Name=FCB Cache % Hit FCBCacheRequests_000_Name=No name FCBCacheStalls_000_Name=FCB Cache Stalls/sec FCBCacheMax_000_Name=FCB Cache Maximum FCBCachePreferred_000_Name=FCB Cache Preferred FCBCacheAlloc_000_Name=FCB Cache Allocated FCBCacheAllocAvail_000_Name=FCB Cache Available PIBInUse_000_Name=Sessions In Use PIBUsed_000_Name=Sessions % Used PIBTotal_000_Name=No name TableOpenCacheHitRate_000_Name=Table Open Cache % Hit TableOpenCacheRequests_000_Name=No name TableOpenCacheHitsPerSec_000_Name=Table Open Cache Hits/sec TableOpenCacheMissesPerSec_000_Name=Table Open Cache Misses/sec TableOpensPerSec_000_Name=Table Opens/sec LGBytesWrittenPerSec_000_Name=Log Bytes Write/sec LGBytesGeneratedPerSec_000_Name=Log Bytes Generated/sec LGBufferBytesUsed_000_Name=Log Buffer Bytes Used LGBufferBytesFree_000_Name=Log Buffer Bytes Free LGUsersWaiting_000_Name=Log Threads Waiting LGCheckpointDepth_000_Name=Log Checkpoint Depth LGLogGenerationCheckpointDepth_000_Name=Log Generation Checkpoint Depth UserROTrxCommit0PerSec_000_Name=User Read Only Transaction Commits to Level 0/sec UserRWTrxCommit0PerSec_000_Name=User Read/Write Transaction Commits to Level 0/sec UserTrxCommit0PerSec_000_Name=User Transaction Commits to Level 0/sec UserROTrxRollback0PerSec_000_Name=User Read Only Transaction Rollbacks to Level 0/sec UserRWTrxRollback0PerSec_000_Name=User Read/Write Transaction Rollbacks to Level 0/sec UserTrxRollback0PerSec_000_Name=User Transaction Rollbacks to Level 0/sec SystemROTrxCommit0PerSec_000_Name=System Read Only Transaction Commits to Level 0/sec SystemRWTrxCommit0PerSec_000_Name=System Read/Write Transaction Commits to Level 0/sec SystemTrxCommit0PerSec_000_Name=System Transaction Commits to Level 0/sec SystemROTrxRollback0PerSec_000_Name=System Read Only Transaction Rollbacks to Level 0/sec SystemRWTrxRollback0PerSec_000_Name=System Read/Write Transaction Rollbacks to Level 0/sec SystemTrxRollback0PerSec_000_Name=System Transaction Rollbacks to Level 0/sec IODatabaseFileExtensionAsyncConsumed_000_Name=Database Page Allocation File Extension Async Consumed/sec IODatabaseFileExtensionStall_000_Name=Database Page Allocation File Extension Stalls/sec LGRecordPerSec_000_Name=Log Records/sec LGCapacityFlushPerSec_000_Name=Log Buffer Capacity Flushes/sec LGCommitFlushPerSec_000_Name=Log Buffer Commit Flushes/sec LGFlushPerSec_000_Name=Log Buffer Flushes/sec LGWritePerSec_000_Name=Log Writes/sec LGStallPerSec_000_Name=Log Record Stalls/sec VERcbucketAllocated_000_Name=Version buckets allocated VERcbucketDeleteAllocated_000_Name=Version buckets allocated for deletes VERBucketAllocWaitForVersionCleanup_000_Name=VER Bucket Allocations Wait For Version Cleanup/sec VERcbAverageBookmark_000_Name=Version store average RCE bookmark length VERUnnecessaryCalls_000_Name=Version store unnecessary calls/sec VERAsyncCleanupTasksDispatched_000_Name=Version store cleanup tasks asynchronously dispatched/sec VERSyncCleanupTasksDispatched_000_Name=Version store cleanup tasks synchronously dispatched/sec VERCleanupTasksDiscarded_000_Name=Version store cleanup tasks discarded/sec VERCleanupTasksFailed_000_Name=Version store cleanup tasks failures/sec RECInserts_000_Name=Record Inserts/sec RECDeletes_000_Name=Record Deletes/sec RECReplaces_000_Name=Record Replaces/sec RECNoOpReplaces_000_Name=Record Unnecessary Replaces/sec RECRedundantReplaces_000_Name=Record Redundant Replaces/sec RECEscrowUpdates_000_Name=Record Escrow-Updates/sec RECIndexInserts_000_Name=Secondary Index Inserts/sec RECIndexDeletes_000_Name=Secondary Index Deletes/sec RECFalseIndexColumnUpdates_000_Name=False Index Column Updates/sec RECFalseTupleIndexColumnUpdates_000_Name=False Tuple Index Column Updates/sec RECUpdateIntrinsicLV_000_Name=Record Intrinsic Long-Values Updated/sec RECAddSeparateLV_000_Name=Record Separated Long-Values Added/sec RECAddForcedSeparateLV_000_Name=Record Separated Long-Values Forced/sec RECForceSeparateAllLV_000_Name=Record Separated Long-Values All Forced/sec RECRefAllSeparateLV_000_Name=Record Separated Long-Values Reference All/sec RECDerefAllSeparateLV_000_Name=Record Separated Long-Values Dereference All/sec LVSeeks_000_Name=Separated Long-Value Seeks/sec LVRetrieves_000_Name=Separated Long-Value Retrieves/sec LVCreates_000_Name=Separated Long-Value Creates/sec LVUpdates_000_Name=Separated Long-Value Updates/sec LVDeletes_000_Name=Separated Long-Value Deletes/sec LVCopies_000_Name=Separated Long-Value Copies/sec LVChunkSeeks_000_Name=Separated Long-Value Chunk Seeks/sec LVChunkRetrieves_000_Name=Separated Long-Value Chunk Retrieves/sec LVChunkAppends_000_Name=Separated Long-Value Chunk Appends/sec LVChunkReplaces_000_Name=Separated Long-Value Chunk Replaces/sec LVChunkDeletes_000_Name=Separated Long-Value Chunk Deletes/sec LVChunkCopies_000_Name=Separated Long-Value Chunk Copies/sec BTAppendSplit_000_Name=B+ Tree Append Splits/sec BTRightSplit_000_Name=B+ Tree Right Splits/sec BTRightHotpointSplit_000_Name=B+ Tree Right Hotpoint Splits/sec BTVerticalSplit_000_Name=B+ Tree Vertical Splits/sec BTSplit_000_Name=B+ Tree Splits/sec BTEmptyPageMerge_000_Name=B+ Tree Empty Page Merges/sec BTRightMerge_000_Name=B+ Tree Right Merges/sec BTPartialMerge_000_Name=B+ Tree Partial Merges/sec BTLeftMerge_000_Name=B+ Tree Left Merges/sec BTPartialLeftMerge_000_Name=B+ Tree Partial Left Merges/sec BTPageMove_000_Name=B+ Tree Page Moves/sec BTMerge_000_Name=B+ Tree Merges/sec BTFailedSPCWriteLatch_000_Name=B+ Tree Failed Simple Page Cleanup Attempts/sec BTSeekShortCircuit_000_Name=B+ Tree Seek Short Circuits/sec BTOpportunePrereads_000_Name=B+ Tree Opportune Prereads/sec BTUnnecessarySiblingLatch_000_Name=B+ Tree Unnecessary Sibling Latches/sec BTNext_000_Name=B+ Tree Move Nexts/sec BTNextNonVisibleNodesSkipped_000_Name=B+ Tree Move Nexts (Non-Visible Nodes Skipped)/sec BTPrev_000_Name=B+ Tree Move Prevs/sec BTPrevNonVisibleNodesSkipped_000_Name=B+ Tree Move Prevs (Non-Visible Nodes Skipped)/sec BTSeek_000_Name=B+ Tree Seeks/sec BTInsert_000_Name=B+ Tree Inserts/sec BTReplace_000_Name=B+ Tree Replaces/sec BTFlagDelete_000_Name=B+ Tree Flag Deletes/sec BTDelete_000_Name=B+ Tree Deletes/sec BTAppend_000_Name=B+ Tree Appends/sec SPCreate_000_Name=B+ Tree Creates/sec SPCreateCum_000_Name=B+ Tree Creates (Total) SPDelete_000_Name=B+ Tree Destroys/sec SPDeleteCum_000_Name=B+ Tree Destroys (Total) BFCacheMisses_000_Name=Database Cache Misses/sec BFCacheHits_000_Name=Database Cache % Hit BFCacheRequests_000_Name=No name BFCacheRequestsPerSec_000_Name=Database Cache Requests/sec BFPctPinned_000_Name=Database Cache % Pinned BFTotalBuffers1_000_Name=No name BFPctClean_000_Name=Database Cache % Clean BFTotalBuffers2_000_Name=No name BFPagesReadAsyncPerSec_000_Name=Database Pages Read Async/sec BFPagesReadSyncPerSec_000_Name=Database Pages Read Sync/sec BFPagesWrittenPerSec_000_Name=Database Pages Written/sec BFCleanPagesWrittenPerSec_000_Name=Database Clean Pages Written/sec BFOpportuneWriteIssued_000_Name=Database Opportune Write Issued (Total) BFPagesTransferredPerSec_000_Name=Database Pages Transferred/sec BFLatch_000_Name=Database Page Latches/sec BFFastLatch_000_Name=Database Page Fast Latches/sec BFBadLatchHint_000_Name=Database Page Bad Latch Hints/sec BFPctFastLatch_000_Name=Database Cache % Fast Latch BFTotalLatches_000_Name=No name BFLatchConflict_000_Name=Database Page Latch Conflicts/sec BFLatchStall_000_Name=Database Page Latch Stalls/sec BFPctAvail_000_Name=Database Cache % Available BFTotalBuffers3_000_Name=No name BFCacheFault_000_Name=Database Page Faults/sec BFCacheEvict_000_Name=Database Page Evictions/sec BFAvailStallsPerSec_000_Name=Database Page Fault Stalls/sec BFCacheSizeMB_000_Name=Database Cache Size (MB) BFCacheSize_000_Name=Database Cache Size BFCacheSizeMin_000_Name=Database Cache Size Min BFCacheSizeMax_000_Name=Database Cache Size Max BFCacheSizeResident_000_Name=Database Cache Size Resident BFCacheSizeResidentMB_000_Name=Database Cache Size Resident (MB) BFPctStartFlushThreshold_000_Name=Database Cache % Available Min BFTotalBuffers4_000_Name=No name BFPctStopFlushThreshold_000_Name=Database Cache % Available Max BFTotalBuffers5_000_Name=No name BFPagesPreread_000_Name=Database Pages Preread/sec BFCachedPagesPreread_000_Name=Database Cached Pages Preread/sec BFPagesPrereadUntouched_000_Name=Database Pages Preread Untouched/sec BFPagesVersioned_000_Name=Database Pages Versioned/sec BFPagesVersionCopied_000_Name=Database Pages Version Copied/sec BFPctVersioned_000_Name=Database Cache % Versioned BFTotalBuffers6_000_Name=No name BFPagesOrdinarilyWritten_000_Name=Database Pages Ordinarily Written/sec BFPagesAnomalouslyWritten_000_Name=Database Pages Anomalously Written/sec BFPagesOpportunelyWritten_000_Name=Database Pages Opportunely Written/sec BFPagesRepeatedlyWritten_000_Name=Database Pages Repeatedly Written/sec BFPagesIdlyWritten_000_Name=Database Pages Idly Written/sec BFPagesCoalescedWritten_000_Name=Database Pages Coalesced Written/sec BFPagesCoalescedRead_000_Name=Database Pages Coalesced Read/sec BFPageHistory_000_Name=Database Page History Records BFPageHistoryHits_000_Name=Database Page History % Hit BFPageHistoryReqs_000_Name=No name BFPageScanned_000_Name=Database Page Scans/sec BFPageScannedOutOfOrder_000_Name=Database Page Scans Out-of-order/sec BFPageScannedTotal_000_Name=No name BFPctResident_000_Name=Database Cache % Resident BFTotalBuffers7_000_Name=No name BKReadIO_000_Name=Streaming Backup Pages Read/sec OLDPageReferenced_000_Name=Online Defrag Pages Referenced/sec OLDPageRead_000_Name=Online Defrag Pages Read/sec OLDPagePreread_000_Name=Online Defrag Pages Preread/sec OLDPageDirtied_000_Name=Online Defrag Pages Dirtied/sec OLDPageRedirtied_000_Name=Online Defrag Pages Re-Dirtied/sec OLDPagesFreed_000_Name=Online Defrag Pages Freed/sec OLDPagesMerged_000_Name=Online Defrag Data Moves/sec OLDPagesMoved_000_Name=Online Defrag Page Moves/sec OLDLogRecord_000_Name=Online Defrag Log Records/sec OLDLogBytes_000_Name=Online Defrag Average Log Bytes OLDLogRecordsTotal1_000_Name=No name PagesScannedSec_000_Name=Online Maintenance (DB Scan) Pages Read/sec PagesScannedTotal_000_Name=Online Maintenance (DB Scan) Pages Read PagesZeroedSec_000_Name=Online Maintenance (DB Scan) Pages Zeroed/sec PagesZeroedTotal_000_Name=Online Maintenance (DB Scan) Pages Zeroed DBTASKPageReferenced_000_Name=Database Tasks Pages Referenced/sec DBTASKPageRead_000_Name=Database Tasks Pages Read/sec DBTASKPagePreread_000_Name=Database Tasks Pages Preread/sec DBTASKPageDirtied_000_Name=Database Tasks Pages Dirtied/sec DBTASKPageRedirtied_000_Name=Database Tasks Pages Re-Dirtied/sec DBTASKLogRecord_000_Name=Database Tasks Log Records/sec DBTASKLogBytes_000_Name=Database Tasks Average Log Bytes DBTASKLogRecordsTotal1_000_Name=No name OSFileDbReadIO_000_Name=I/O Database Reads/sec OSFileDbReadIOTotalTicks_000_Name=I/O Database Reads Average Latency OSFileDbReadIOTotal1_000_Name=No name OSFileDbReadIOTotalBytes_000_Name=I/O Database Reads Average Bytes OSFileDbReadIOTotal2_000_Name=No name OSFileDbReadIOInHeap_000_Name=I/O Database Reads In Heap OSFileDbReadIOAsyncPending_000_Name=I/O Database Reads Async Pending OSFileDbReadIOAbnormalLatency_000_Name=I/O Database Reads Abnormal Latency/sec OSFileLogReadIO_000_Name=I/O Log Reads/sec OSFileLogReadIOTotalTicks_000_Name=I/O Log Reads Average Latency OSFileLogReadIOTotal1_000_Name=No name OSFileLogReadIOTotalBytes_000_Name=I/O Log Reads Average Bytes OSFileLogReadIOTotal2_000_Name=No name OSFileLogReadIOInHeap_000_Name=I/O Log Reads In Heap OSFileLogReadIOAsyncPending_000_Name=I/O Log Reads Async Pending OSFileLogReadIOAbnormalLatency_000_Name=I/O Log Reads Abnormal Latency/sec OSFileDbWriteIO_000_Name=I/O Database Writes/sec OSFileDbWriteIOTotalTicks_000_Name=I/O Database Writes Average Latency OSFileDbWriteIOTotal1_000_Name=No name OSFileDbWriteIOTotalBytes_000_Name=I/O Database Writes Average Bytes OSFileDbWriteIOTotal2_000_Name=No name OSFileDbWriteIOInHeap_000_Name=I/O Database Writes In Heap OSFileDbWriteIOAsyncPending_000_Name=I/O Database Writes Async Pending OSFileDbWriteIOAbnormalLatency_000_Name=I/O Database Writes Abnormal Latency/sec OSFileLogWriteIO_000_Name=I/O Log Writes/sec OSFileLogWriteIOTotalTicks_000_Name=I/O Log Writes Average Latency OSFileLogWriteIOTotal1_000_Name=No name OSFileLogWriteIOTotalBytes_000_Name=I/O Log Writes Average Bytes OSFileLogWriteIOTotal2_000_Name=No name OSFileLogWriteIOInHeap_000_Name=I/O Log Writes In Heap OSFileLogWriteIOAsyncPending_000_Name=I/O Log Writes Async Pending OSFileLogWriteIOAbnormalLatency_000_Name=I/O Log Writes Abnormal Latency/sec OSSYNCThreadBlock_000_Name=Threads Blocked/sec OSSYNCThreadsBlocked_000_Name=Threads Blocked FailedXpressCompressionBytesPerSec_000_Name=Record Failed Compression Bytes/sec TRECInserts_000_Name=Record Inserts/sec TRECDeletes_000_Name=Record Deletes/sec TRECReplaces_000_Name=Record Replaces/sec TRECNoOpReplaces_000_Name=Record Unnecessary Replaces/sec TRECRedundantReplaces_000_Name=Record Redundant Replaces/sec TRECEscrowUpdates_000_Name=Record Escrow-Updates/sec TRECIndexInserts_000_Name=Secondary Index Inserts/sec TRECIndexDeletes_000_Name=Secondary Index Deletes/sec TRECFalseIndexColumnUpdates_000_Name=False Index Column Updates/sec TRECFalseTupleIndexColumnUpdates_000_Name=False Tuple Index Column Updates/sec TRECUpdateIntrinsicLV_000_Name=Record Intrinsic Long-Values Updated/sec TRECAddSeparateLV_000_Name=Record Separated Long-Values Added/sec TRECAddForcedSeparateLV_000_Name=Record Separated Long-Values Forced/sec TRECForceSeparateAllLV_000_Name=Record Separated Long-Values All Forced/sec TRECRefAllSeparateLV_000_Name=Record Separated Long-Values Reference All/sec TRECDerefAllSeparateLV_000_Name=Record Separated Long-Values Dereference All/sec TLVSeeks_000_Name=Separated Long-Value Seeks/sec TLVRetrieves_000_Name=Separated Long-Value Retrieves/sec TLVCreates_000_Name=Separated Long-Value Creates/sec TLVUpdates_000_Name=Separated Long-Value Updates/sec TLVDeletes_000_Name=Separated Long-Value Deletes/sec TLVCopies_000_Name=Separated Long-Value Copies/sec TLVChunkSeeks_000_Name=Separated Long-Value Chunk Seeks/sec TLVChunkRetrieves_000_Name=Separated Long-Value Chunk Retrieves/sec TLVChunkAppends_000_Name=Separated Long-Value Chunk Appends/sec TLVChunkReplaces_000_Name=Separated Long-Value Chunk Replaces/sec TLVChunkDeletes_000_Name=Separated Long-Value Chunk Deletes/sec TLVChunkCopies_000_Name=Separated Long-Value Chunk Copies/sec TBTAppendSplit_000_Name=B+ Tree Append Splits/sec TBTRightSplit_000_Name=B+ Tree Right Splits/sec TBTRightHotpointSplit_000_Name=B+ Tree Right Hotpoint Splits/sec TBTVerticalSplit_000_Name=B+ Tree Vertical Splits/sec TBTSplit_000_Name=B+ Tree Splits/sec TBTEmptyPageMerge_000_Name=B+ Tree Empty Page Merges/sec TBTRightMerge_000_Name=B+ Tree Right Merges/sec TBTPartialMerge_000_Name=B+ Tree Partial Merges/sec TBTLeftMerge_000_Name=B+ Tree Left Merges/sec TBTPartialLeftMerge_000_Name=B+ Tree Partial Left Merges/sec TBTPageMove_000_Name=B+ Tree Page Moves/sec TBTMerge_000_Name=B+ Tree Merges/sec TBTFailedSPCWriteLatch_000_Name=B+ Tree Failed Simple Page Cleanup Attempts/sec TBTSeekShortCircuit_000_Name=B+ Tree Seek Short Circuits/sec TBTOpportunePrereads_000_Name=B+ Tree Opportune Prereads/sec TBTUnnecessarySiblingLatch_000_Name=B+ Tree Unnecessary Sibling Latches/sec TBTNext_000_Name=B+ Tree Move Nexts/sec TBTNextNonVisibleNodesSkipped_000_Name=B+ Tree Move Nexts (Non-Visible Nodes Skipped)/sec TBTPrev_000_Name=B+ Tree Move Prevs/sec TBTPrevNonVisibleNodesSkipped_000_Name=B+ Tree Move Prevs (Non-Visible Nodes Skipped)/sec TBTSeek_000_Name=B+ Tree Seeks/sec TBTInsert_000_Name=B+ Tree Inserts/sec TBTReplace_000_Name=B+ Tree Replaces/sec TBTFlagDelete_000_Name=B+ Tree Flag Deletes/sec TBTDelete_000_Name=B+ Tree Deletes/sec TBTAppend_000_Name=B+ Tree Appends/sec TSPCreate_000_Name=B+ Tree Creates/sec TSPCreateCum_000_Name=B+ Tree Creates (Total) TSPDelete_000_Name=B+ Tree Destroys/sec TSPDeleteCum_000_Name=B+ Tree Destroys (Total) TBFCacheSizeMB_000_Name=Database Cache Size (MB) TBFCacheMisses_000_Name=Database Cache Misses/sec TBFCacheHits_000_Name=Database Cache % Hit TBFCacheRequests_000_Name=No name TBFCacheRequestsPerSec_000_Name=Database Cache Requests/sec TBFPagesReadAsyncPerSec_000_Name=Database Pages Read Async/sec TBFPagesReadSyncPerSec_000_Name=Database Pages Read Sync/sec TBFPagesWrittenPerSec_000_Name=Database Pages Written/sec TBFCleanPagesWrittenPerSec_000_Name=Database Clean Pages Written/sec TBFPagesTransferredPerSec_000_Name=Database Pages Transferred/sec TBFPagesPreread_000_Name=Database Pages Preread/sec TBFCachedPagesPreread_000_Name=Database Cached Pages Preread/sec TBFPagesPrereadUntouched_000_Name=Database Pages Preread Untouched/sec TBFPagesVersioned_000_Name=Database Pages Versioned/sec TBFPagesVersionCopied_000_Name=Database Pages Version Copied/sec TBFPagesOrdinarilyWritten_000_Name=Database Pages Ordinarily Written/sec TBFPagesAnomalouslyWritten_000_Name=Database Pages Anomalously Written/sec TBFPagesOpportunelyWritten_000_Name=Database Pages Opportunely Written/sec TBFPagesRepeatedlyWritten_000_Name=Database Pages Repeatedly Written/sec TBFPagesIdlyWritten_000_Name=Database Pages Idly Written/sec TBFPagesCoalescedWritten_000_Name=Database Pages Coalesced Written/sec TBFPagesCoalescedRead_000_Name=Database Pages Coalesced Read/sec IPagesConvertedSec_000_Name=Pages Converted/sec IPagesConvertedTotal_000_Name=Pages Converted IRecordsConvertedSec_000_Name=Records Converted/sec IRecordsConvertedTotal_000_Name=Records Converted IOLDTasksRunning_000_Name=Defragmentation Tasks IOLDTasksPending_000_Name=Defragmentation Tasks Pending IOLDTasksDiscarded_000_Name=Defragmentation Tasks Discarded IOLDTasksPostedPerSec_000_Name=Defragmentation Tasks Scheduled/sec IOLDTasksCompletedPerSec_000_Name=Defragmentation Tasks Completed/sec IFCBAsyncScan_000_Name=FCB Asynchronous Scan/sec IFCBAsyncPurge_000_Name=FCB Asynchronous Purge/sec IFCBAsyncThresholdScan_000_Name=FCB Asynchronous Threshold-Scan/sec IFCBAsyncThresholdPurge_000_Name=FCB Asynchronous Threshold-Purge/sec IFCBAsyncPurgeConflict_000_Name=FCB Asynchronous Purge Conflicts/sec IFCBSyncPurge_000_Name=FCB Synchronous Purge/sec IFCBSyncPurgeStalls_000_Name=FCB Synchronous Purge Stalls/sec IFCBAllocWaitForVersionCleanup_000_Name=FCB Allocations Wait For Version Cleanup/sec IFCBPurgeOnClose_000_Name=FCB Purge On Cursor Close/sec IFCBCacheHits_000_Name=FCB Cache % Hit IFCBCacheRequests_000_Name=No name IFCBCacheStalls_000_Name=FCB Cache Stalls/sec IFCBCacheMax_000_Name=FCB Cache Maximum IFCBCachePreferred_000_Name=FCB Cache Preferred IFCBCacheAlloc_000_Name=FCB Cache Allocated IFCBCacheAllocAvail_000_Name=FCB Cache Available IPIBInUse_000_Name=Sessions In Use IPIBUsed_000_Name=Sessions % Used IPIBTotal_000_Name=No name ITableOpenCacheHitRate_000_Name=Table Open Cache % Hit ITableOpenCacheRequests_000_Name=No name ITableOpenCacheHitsPerSec_000_Name=Table Open Cache Hits/sec ITableOpenCacheMissesPerSec_000_Name=Table Open Cache Misses/sec ITableOpensPerSec_000_Name=Table Opens/sec ILGBytesWrittenPerSec_000_Name=Log Bytes Write/sec ILGBytesGeneratedPerSec_000_Name=Log Bytes Generated/sec ILGBufferSize_000_Name=Log Buffer Size ILGBufferBytesUsed_000_Name=Log Buffer Bytes Used ILGBufferBytesFree_000_Name=Log Buffer Bytes Free ILGUsersWaiting_000_Name=Log Threads Waiting ILGFileSize_000_Name=Log File Size ILGCheckpointDepth_000_Name=Log Checkpoint Depth ILGLogGenerationCheckpointDepth_000_Name=Log Generation Checkpoint Depth ILGLogGenerationCheckpointDepthTarget_000_Name=Log Generation Checkpoint Depth Target ILGLogCheckpointDepthAsAPctOfTarget_000_Name=Log Checkpoint Depth as a % of Target ILGLogGenerationCheckpointDepthTarget2_000_Name=No name ILGLogGenerationCheckpointDepthMax_000_Name=Log Generation Checkpoint Depth Max ILGLogGenerationWaypointDepth_000_Name=Log Generation Loss Resiliency Depth ILGLogFileGenerated_000_Name=Log Files Generated ILGLogFileGeneratedPrematurely_000_Name=Log Files Generated Prematurely ILGLogFileCurrentGeneration_000_Name=Log File Current Generation IUserROTrxCommit0PerSec_000_Name=User Read Only Transaction Commits to Level 0/sec IUserRWTrxCommit0PerSec_000_Name=User Read/Write Transaction Commits to Level 0/sec IUserTrxCommit0PerSec_000_Name=User Transaction Commits to Level 0/sec IUserROTrxRollback0PerSec_000_Name=User Read Only Transaction Rollbacks to Level 0/sec IUserRWTrxRollback0PerSec_000_Name=User Read/Write Transaction Rollbacks to Level 0/sec IUserTrxRollback0PerSec_000_Name=User Transaction Rollbacks to Level 0/sec ISystemROTrxCommit0PerSec_000_Name=System Read Only Transaction Commits to Level 0/sec ISystemRWTrxCommit0PerSec_000_Name=System Read/Write Transaction Commits to Level 0/sec ISystemTrxCommit0PerSec_000_Name=System Transaction Commits to Level 0/sec ISystemROTrxRollback0PerSec_000_Name=System Read Only Transaction Rollbacks to Level 0/sec ISystemRWTrxRollback0PerSec_000_Name=System Read/Write Transaction Rollbacks to Level 0/sec ISystemTrxRollback0PerSec_000_Name=System Transaction Rollbacks to Level 0/sec IIODatabaseFileExtensionAsyncConsumed_000_Name=Database Page Allocation File Extension Async Consumed/sec IIODatabaseFileExtensionStall_000_Name=Database Page Allocation File Extension Stalls/sec ILGRecordPerSec_000_Name=Log Records/sec ILGCapacityFlushPerSec_000_Name=Log Buffer Capacity Flushes/sec ILGCommitFlushPerSec_000_Name=Log Buffer Commit Flushes/sec ILGFlushPerSec_000_Name=Log Buffer Flushes/sec ILGWritePerSec_000_Name=Log Writes/sec ILGStallPerSec_000_Name=Log Record Stalls/sec IVERcbucketAllocated_000_Name=Version buckets allocated IVERcbucketDeleteAllocated_000_Name=Version buckets allocated for deletes IVERBucketAllocWaitForVersionCleanup_000_Name=VER Bucket Allocations Wait For Version Cleanup/sec IVERcbAverageBookmark_000_Name=Version store average RCE bookmark length IVERUnnecessaryCalls_000_Name=Version store unnecessary calls/sec IVERAsyncCleanupDispatched_000_Name=Version store cleanup tasks asynchronously dispatched/sec IVERSyncCleanupDispatched_000_Name=Version store cleanup tasks synchronously dispatched/sec IVERCleanupDiscarded_000_Name=Version store cleanup tasks discarded/sec IVERCleanupFailed_000_Name=Version store cleanup tasks failures/sec IRECInserts_000_Name=Record Inserts/sec IRECDeletes_000_Name=Record Deletes/sec IRECReplaces_000_Name=Record Replaces/sec IRECNoOpReplaces_000_Name=Record Unnecessary Replaces/sec IRECRedundantReplaces_000_Name=Record Redundant Replaces/sec IRECEscrowUpdates_000_Name=Record Escrow-Updates/sec IRECIndexInserts_000_Name=Secondary Index Inserts/sec IRECIndexDeletes_000_Name=Secondary Index Deletes/sec IRECFalseIndexColumnUpdates_000_Name=False Index Column Updates/sec IRECFalseTupleIndexColumnUpdates_000_Name=False Tuple Index Column Updates/sec IRECUpdateIntrinsicLV_000_Name=Record Intrinsic Long-Values Updated/sec IRECAddSeparateLV_000_Name=Record Separated Long-Values Added/sec IRECAddForcedSeparateLV_000_Name=Record Separated Long-Values Forced/sec IRECForceSeparateAllLV_000_Name=Record Separated Long-Values All Forced/sec IRECRefAllSeparateLV_000_Name=Record Separated Long-Values Reference All/sec IRECDerefAllSeparateLV_000_Name=Record Separated Long-Values Dereference All/sec ILVSeeks_000_Name=Separated Long-Value Seeks/sec ILVRetrieves_000_Name=Separated Long-Value Retrieves/sec ILVCreates_000_Name=Separated Long-Value Creates/sec ILVUpdates_000_Name=Separated Long-Value Updates/sec ILVDeletes_000_Name=Separated Long-Value Deletes/sec ILVCopies_000_Name=Separated Long-Value Copies/sec ILVChunkSeeks_000_Name=Separated Long-Value Chunk Seeks/sec ILVChunkRetrieves_000_Name=Separated Long-Value Chunk Retrieves/sec ILVChunkAppends_000_Name=Separated Long-Value Chunk Appends/sec ILVChunkReplaces_000_Name=Separated Long-Value Chunk Replaces/sec ILVChunkDeletes_000_Name=Separated Long-Value Chunk Deletes/sec ILVChunkCopies_000_Name=Separated Long-Value Chunk Copies/sec IBTAppendSplit_000_Name=B+ Tree Append Splits/sec IBTRightSplit_000_Name=B+ Tree Right Splits/sec IBTRightHotpointSplit_000_Name=B+ Tree Right Hotpoint Splits/sec IBTVerticalSplit_000_Name=B+ Tree Vertical Splits/sec IBTSplit_000_Name=B+ Tree Splits/sec IBTEmptyPageMerge_000_Name=B+ Tree Empty Page Merges/sec IBTRightMerge_000_Name=B+ Tree Right Merges/sec IBTPartialMerge_000_Name=B+ Tree Partial Merges/sec IBTLeftMerge_000_Name=B+ Tree Left Merges/sec IBTPartialLeftMerge_000_Name=B+ Tree Partial Left Merges/sec IBTPageMove_000_Name=B+ Tree Page Moves/sec IBTMerge_000_Name=B+ Tree Merges/sec IBTFailedSPCWriteLatch_000_Name=B+ Tree Failed Simple Page Cleanup Attempts/sec IBTSeekShortCircuit_000_Name=B+ Tree Seek Short Circuits/sec IBTOpportunePrereads_000_Name=B+ Tree Opportune Prereads/sec IBTUnnecessarySiblingLatch_000_Name=B+ Tree Unnecessary Sibling Latches/sec IBTNext_000_Name=B+ Tree Move Nexts/sec IBTNextNonVisibleNodesSkipped_000_Name=B+ Tree Move Nexts (Non-Visible Nodes Skipped)/sec IBTPrev_000_Name=B+ Tree Move Prevs/sec IBTPrevNonVisibleNodesSkipped_000_Name=B+ Tree Move Prevs (Non-Visible Nodes Skipped)/sec IBTSeek_000_Name=B+ Tree Seeks/sec IBTInsert_000_Name=B+ Tree Inserts/sec IBTReplace_000_Name=B+ Tree Replaces/sec IBTFlagDelete_000_Name=B+ Tree Flag Deletes/sec IBTDelete_000_Name=B+ Tree Deletes/sec IBTAppend_000_Name=B+ Tree Appends/sec ISPCreate_000_Name=B+ Tree Creates/sec ISPCreateCum_000_Name=B+ Tree Creates (Total) ISPDelete_000_Name=B+ Tree Destroys/sec ISPDeleteCum_000_Name=B+ Tree Destroys (Total) IBFCacheSizeMB_000_Name=Database Cache Size (MB) IBFCacheMisses_000_Name=Database Cache Misses/sec IBFCacheHits_000_Name=Database Cache % Hit IBFCacheRequests_000_Name=No name IBFCacheRequestsPerSec_000_Name=Database Cache Requests/sec IBFPagesReadAsyncPerSec_000_Name=Database Pages Read Async/sec IBFPagesReadSyncPerSec_000_Name=Database Pages Read Sync/sec IBFPagesWrittenPerSec_000_Name=Database Pages Written/sec IBFCleanPagesWrittenPerSec_000_Name=Database Clean Pages Written/sec IBFPagesTransferredPerSec_000_Name=Database Pages Transferred/sec IBFPagesPreread_000_Name=Database Pages Preread/sec IBFCachedPagesPreread_000_Name=Database Cached Pages Preread/sec IBFPagesPrereadUntouched_000_Name=Database Pages Preread Untouched/sec IBFPagesVersioned_000_Name=Database Pages Versioned/sec IBFPagesVersionCopied_000_Name=Database Pages Version Copied/sec IBFPagesOrdinarilyWritten_000_Name=Database Pages Ordinarily Written/sec IBFPagesAnomalouslyWritten_000_Name=Database Pages Anomalously Written/sec IBFPagesOpportunelyWritten_000_Name=Database Pages Opportunely Written/sec IBFPagesRepeatedlyWritten_000_Name=Database Pages Repeatedly Written/sec IBFPagesIdlyWritten_000_Name=Database Pages Idly Written/sec IBFPagesCoalescedWritten_000_Name=Database Pages Coalesced Written/sec IBFPagesCoalescedRead_000_Name=Database Pages Coalesced Read/sec IBKReadIO_000_Name=Streaming Backup Pages Read/sec IOLDPageReferenced_000_Name=Online Defrag Pages Referenced/sec IOLDPageRead_000_Name=Online Defrag Pages Read/sec IOLDPagePreread_000_Name=Online Defrag Pages Preread/sec IOLDPageDirtied_000_Name=Online Defrag Pages Dirtied/sec IOLDPageRedirtied_000_Name=Online Defrag Pages Re-Dirtied/sec IOLDPagesFreed_000_Name=Online Defrag Pages Freed/sec IOLDPagesMerged_000_Name=Online Defrag Data Moves/sec IOLDPagesMoved_000_Name=Online Defrag Page Moves/sec IOLDLogRecord_000_Name=Online Defrag Log Records/sec IOLDLogBytes_000_Name=Online Defrag Average Log Bytes IOLDLogRecordsTotal1_000_Name=No name IPagesScannedSec_000_Name=Online Maintenance (DB Scan) Pages Read/sec IPagesScannedTotal_000_Name=Online Maintenance (DB Scan) Pages Read IPagesZeroedSec_000_Name=Online Maintenance (DB Scan) Pages Zeroed/sec IPagesZeroedTotal_000_Name=Online Maintenance (DB Scan) Pages Zeroed IDBTASKPageReferenced_000_Name=Database Tasks Pages Referenced/sec IDBTASKPageRead_000_Name=Database Tasks Pages Read/sec IDBTASKPagePreread_000_Name=Database Tasks Pages Preread/sec IDBTASKPageDirtied_000_Name=Database Tasks Pages Dirtied/sec IDBTASKPageRedirtied_000_Name=Database Tasks Pages Re-Dirtied/sec IDBTASKLogRecord_000_Name=Database Tasks Log Records/sec IDBTASKLogBytes_000_Name=Database Tasks Average Log Bytes IDBTASKLogRecordsTotal1_000_Name=No name IOSFileDbReadIO_000_Name=I/O Database Reads/sec IOSFileDbReadIOTotalTicks_000_Name=I/O Database Reads Average Latency IOSFileDbReadIOTotal1_000_Name=No name IOSFileDbReadIOTotalBytes_000_Name=I/O Database Reads Average Bytes IOSFileDbReadIOTotal2_000_Name=No name IOSFileDbReadIOInHeap_000_Name=I/O Database Reads In Heap IOSFileDbReadIOAsyncPending_000_Name=I/O Database Reads Async Pending IOSFileDbReadIOAbnormalLatency_000_Name=I/O Database Reads Abnormal Latency/sec IOSFileLogReadIO_000_Name=I/O Log Reads/sec IOSFileLogReadIOTotalTicks_000_Name=I/O Log Reads Average Latency IOSFileLogReadIOTotal1_000_Name=No name IOSFileLogReadIOTotalBytes_000_Name=I/O Log Reads Average Bytes IOSFileLogReadIOTotal2_000_Name=No name IOSFileLogReadIOInHeap_000_Name=I/O Log Reads In Heap IOSFileLogReadIOAsyncPending_000_Name=I/O Log Reads Async Pending IOSFileLogReadIOAbnormalLatency_000_Name=I/O Log Reads Abnormal Latency/sec IOSFileDbWriteIO_000_Name=I/O Database Writes/sec IOSFileDbWriteIOTotalTicks_000_Name=I/O Database Writes Average Latency IOSFileDbWriteIOTotal1_000_Name=No name IOSFileDbWriteIOTotalBytes_000_Name=I/O Database Writes Average Bytes IOSFileDbWriteIOTotal2_000_Name=No name IOSFileDbWriteIOInHeap_000_Name=I/O Database Writes In Heap IOSFileDbWriteIOAsyncPending_000_Name=I/O Database Writes Async Pending IOSFileDbWriteIOAbnormalLatency_000_Name=I/O Database Writes Abnormal Latency/sec IOSFileLogWriteIO_000_Name=I/O Log Writes/sec IOSFileLogWriteIOTotalTicks_000_Name=I/O Log Writes Average Latency IOSFileLogWriteIOTotal1_000_Name=No name IOSFileLogWriteIOTotalBytes_000_Name=I/O Log Writes Average Bytes IOSFileLogWriteIOTotal2_000_Name=No name IOSFileLogWriteIOInHeap_000_Name=I/O Log Writes In Heap IOSFileLogWriteIOAsyncPending_000_Name=I/O Log Writes Async Pending IOSFileLogWriteIOAbnormalLatency_000_Name=I/O Log Writes Abnormal Latency/sec IFailedXpressCompressionBytesPerSec_000_Name=Record Failed Compression Bytes/sec 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 OLDTasksRunning_000_Help=Defragmentation Tasks is the count of background database defragmentation tasks that are currently executing. OLDTasksPending_000_Help=Defragmentation Tasks Pending is the count of background database defragmentation tasks that are currently pending. OLDTasksDiscarded_000_Help=Defragmentation Tasks Discarded is the count of background database defragmentation tasks that could not be registered. [Dev Only] OLDTasksPostedPerSec_000_Help=Defragmentation Tasks Scheduled/sec is the number of background database defragmentation tasks scheduled for execution per second. [Dev Only] OLDTasksCompletedPerSec_000_Help=Defragmentation Tasks Completed/sec is the number of background database defragmentation tasks completing execution per second. [Dev Only] 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. PIBUsed_000_Help=Sessions % Used is the percentage of database sessions currently open for use by client threads. 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. LGBytesGeneratedPerSec_000_Help=Log Bytes Generated per second is the rate at which data is added to the log. This is different from Log Bytes Write per second in that each byte is generated only once whereas each byte may be written many times. 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. [Dev Only] 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] BTLeftMerge_000_Help=B+ Tree Left Merges/sec is the count of pages removed from a database B+ Tree per second by moving all its records to the previous page to the left. [Dev Only] BTPartialLeftMerge_000_Help=B+ Tree Partial Left Merges/sec is the count of pages where some of its records are moved to a page on the left in a database B+ Tree per second. [Dev Only] BTPageMove_000_Help=B+ Tree Page Moves/sec is the count of B+ Tree pages per second where all the records are moved to a new page. [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] BTOpportunePrereads_000_Help=B+ Tree Opportune Prereads/sec is the number of pages per second that are preread because they are adjacent to a page read by a seek. [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] BFCacheMisses_000_Help=Database Cache Misses per second is the rate at which database file page requests were fulfilled by the database cache by causing a file operation. If this rate is high then the database cache size may be too small. 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 BFCacheRequestsPerSec_000_Help=Database Cache Requests/sec is the rate that pages are requested from the database cache. BFPctPinned_000_Help=Database Cache % Pinned is the percentage of the database cache that pinned in the memory. [Dev Only] BFTotalBuffers1_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] BFCleanPagesWrittenPerSec_000_Help=Database Clean Pages Written/sec is the rate that pages are written to the database file (s) from the database cache. [Dev Only] BFOpportuneWriteIssued_000_Help=Database Opportune Write Issued (Total) is the count of IO operationshas been issued for opportune write. [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] BFCacheSizeResident_000_Help=Database Cache Size Resident is the amount of system memory used by the database cache that is currently part of the working set of the process. If Database Cache Size Resident is ever significantly smaller than Database Cache Size then the operating system has chosen to reclaim that system memory for use in other parts of the system. The database cache will recover from this event but if this is a common occurrence then it can lead to significant performance problems. BFCacheSizeResidentMB_000_Help=Database Cache Size Resident (MB) is the amount of system memory (in MegaBytes) used by the database cache that is currently part of the working set of the process. If Database Cache Size Resident (MB) is ever significantly smaller than Database Cache Size (MB) then the operating system has chosen to reclaim that system memory for use in other parts of the system. The database cache will recover from this event but if this is a common occurrence then it can lead to significant performance problems. 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] BFPagesVersionCopied_000_Help=Database Pages Version Copied/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 BFPctResident_000_Help=Database Cache % Resident is the percentage of the database cache that are currently in the process's working set. [Dev Only] BFTotalBuffers7_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] OLDPagesFreed_000_Help=Pages Freed/sec is the number of pages per second that are freed from the database by the online defragmentation process [Dev Only] OLDPagesMerged_000_Help=Data Moves/sec is the number of times per second that data is moved from one page to another by the online defragmentation process [Dev Only] OLDPagesMoved_000_Help=Page Moves/sec is the number of times per second that data is moved from one page to a new page by the online defragmentation process [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 PagesScannedSec_000_Help=Pages Read/sec is the number of pages per second that are read from the database by the scanning process [Dev Only] PagesScannedTotal_000_Help=Pages Read is the number of pages that have been read from the database by the scanning process [Dev Only] PagesZeroedSec_000_Help=Pages Read/sec is the number of pages per second that are zeroed in the database by the scanning process [Dev Only] PagesZeroedTotal_000_Help=Pages Read is the number of pages that have been zeroed in the database by the scanning process [Dev Only] 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] 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] FailedXpressCompressionBytesPerSec_000_Help=Record Failed Compression Bytes/sec is the rate of record bytes that either failed Xpress compression or did not significantly reduce the insert/replace size (10% or less). High results are indicative of wasted cpu resources. [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] TBTLeftMerge_000_Help=B+ Tree Left Merges/sec is the count of pages removed from a database B+ Tree per second by moving all its records to the previous page to the left. [Dev Only] TBTPartialLeftMerge_000_Help=B+ Tree Partial Left Merges/sec is the count of pages where some of its records are moved to a page on the left in a database B+ Tree per second. [Dev Only] TBTPageMove_000_Help=B+ Tree Page Moves/sec is the count of B+ Tree pages per second where all the records are moved to a new page. [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] TBTOpportunePrereads_000_Help=B+ Tree Opportune Prereads/sec is the number of pages per second that are preread because they are adjacent to a page read by a seek. [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. TBFCacheMisses_000_Help=Database Cache Misses per second is the rate at which database file page requests were fulfilled by the database cache by causing a file operation. If this rate is high then the database cache size may be too small. TBFCacheHits_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. TBFCacheRequests_000_Help=No text TBFCacheRequestsPerSec_000_Help=Database Cache Requests/sec is the rate that pages are requested from the database cache. 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] TBFCleanPagesWrittenPerSec_000_Help=Database Clean 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] TBFPagesVersionCopied_000_Help=Database Pages Version Copied/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 IOLDTasksRunning_000_Help=Defragmentation Tasks is the count of background database defragmentation tasks that are currently executing. IOLDTasksPending_000_Help=Defragmentation Tasks Pending is the count of background database defragmentation tasks that are currently pending. IOLDTasksDiscarded_000_Help=Defragmentation Tasks Discarded is the count of background database defragmentation tasks that could not be registered. [Dev Only] IOLDTasksPostedPerSec_000_Help=Defragmentation Tasks Scheduled/sec is the number of background database defragmentation tasks scheduled for execution per second. [Dev Only] IOLDTasksCompletedPerSec_000_Help=Defragmentation Tasks Completed/sec is the number of background database defragmentation tasks completing execution per second. [Dev Only] 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. IPIBUsed_000_Help=Sessions % Used is the percentage of database sessions currently open for use by client threads. 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. ILGBytesGeneratedPerSec_000_Help=Log Bytes Generated per second is the rate at which data is added to the log. This is different from Log Bytes Write per second in that each byte is generated only once whereas each byte may be written many times. 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. ILGLogGenerationCheckpointDepthTarget_000_Help=Log Generation Checkpoint Depth Target represents the ideal target for the amount of work, in count of log files, that may be redone or undone to the database file(s) if the process crashes. ILGLogCheckpointDepthAsAPctOfTarget_000_Help=Log Checkpoint Depth as a % of Target is an expression of the current checkpoint depth in terms of a percentage of the checkpoint depth target. For example, if the current checkpoint depth is 5 generations and the checkpoint depth target is 4 generations then this will be reported as 125% of target. ILGLogGenerationCheckpointDepthTarget2_000_Help=No text ILGLogGenerationCheckpointDepthMax_000_Help=Log Generation Checkpoint Depth Max represents the maximum allowable amount of work, in count of log files, that may be redone or undone to the database file(s) if the process crashes. ILGLogGenerationWaypointDepth_000_Help=Log Generation Loss Resiliency Depth represents the amount of work, in count of log files, that may be lost while still allowing the database file(s) to recover (with data loss) if the process crashes. ILGLogFileGenerated_000_Help=Log Files Generated represents the total number of log files generated by an instance since that instance was last initialized. ILGLogFileGeneratedPrematurely_000_Help=Log Files Generated Prematurely represents the total number of log files generated by an instance since that instance was last initialized and that have not been entirely filled with useful data. Under certain conditions the database engine will choose to switch to a new log file before it has been completely filled with useful data. ILGLogFileCurrentGeneration_000_Help=Log File Current Generation gives the generation number of the current log file of an instance. 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. [Dev Only] 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] IBTLeftMerge_000_Help=B+ Tree Left Merges/sec is the count of pages removed from a database B+ Tree per second by moving all its records to the previous page to the left. [Dev Only] IBTPartialLeftMerge_000_Help=B+ Tree Partial Left Merges/sec is the count of pages where some of its records are moved to a page on the left in a database B+ Tree per second. [Dev Only] IBTPageMove_000_Help=B+ Tree Page Moves/sec is the count of B+ Tree pages per second where all the records are moved to a new page. [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] IBTOpportunePrereads_000_Help=B+ Tree Opportune Prereads/sec is the number of pages per second that are preread because they are adjacent to a page read by a seek. [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] IBFCacheSizeMB_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. IBFCacheMisses_000_Help=Database Cache Misses per second is the rate at which database file page requests were fulfilled by the database cache by causing a file operation. If this rate is high then the database cache size may be too small. IBFCacheHits_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. IBFCacheRequests_000_Help=No text IBFCacheRequestsPerSec_000_Help=Database Cache Requests/sec is the rate that pages are requested from the database cache. 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] IBFCleanPagesWrittenPerSec_000_Help=Database Clean 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] IBFPagesVersionCopied_000_Help=Database Pages Version Copied/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 operations performed 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] IOLDPagesFreed_000_Help=Pages Freed/sec is the number of pages per second that are freed from the database by the online defragmentation process [Dev Only] IOLDPagesMerged_000_Help=Data Moves/sec is the number of times per second that data is moved from one page to another by the online defragmentation process [Dev Only] IOLDPagesMoved_000_Help=Page Moves/sec is the number of times per second that data is moved from one page to a new page by the online defragmentation process [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 IPagesScannedSec_000_Help=Pages Read/sec is the number of pages per second that are read from the database by the scanning process [Dev Only] IPagesScannedTotal_000_Help=Pages Read is the number of pages that have been read from the database by the scanning process [Dev Only] IPagesZeroedSec_000_Help=Pages Read/sec is the number of pages per second that are zeroed in the database by the scanning process [Dev Only] IPagesZeroedTotal_000_Help=Pages Read is the number of pages that have been zeroed in the database by the scanning process [Dev Only] 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] IFailedXpressCompressionBytesPerSec_000_Help=Record Failed Compression Bytes/sec is the rate of record bytes that either failed Xpress compression or did not significantly reduce the insert/replace size (10% or less). High results are indicative of wasted cpu resources. [Dev Only]