MS SQL Server Perfmon Access Methods (MSSQL_SERVER_PERFMON_ACCESS_METHODS)
The MSSQL_SERVER_PERFMON_ACCESS_METHODS application class provides counters to monitor how the logical data within the database is accessed. This application class counters can also be used to monitor the amount of data, indexes, and free space within the database, thereby indicating data volume and fragmentation for each server instance. Excessive index fragmentation can impair performance.
Application class attributes
Item | Description |
|---|---|
Active | Yes |
Created by | Discovery |
Parent class |
|
Child class | None |
Attributes (parameters)
- AU cleanup batches/sec (AUCleanupBatchesSec)
- AU cleanups/sec (AUCleanupsSec)
- By-reference Lob Create Count (ByReferenceLobCreateCount)
- By-reference Lob Use Count (ByReferenceLobUseCount)
- Count Lob Readahead (CountLobReadahead)
- Count Pull In Row (CountPullInRow)
- Count Push Off Row (CountPushOffRow)
- Deferred dropped AUs (DeferredDroppedAUs)
- Deferred Dropped rowsets (DeferredDroppedRowsets)
- Dropped rowset cleanups/sec (DroppedRowsetCleanupsSec)
- Dropped rowsets skipped/sec (DroppedRowsetsSkippedSec)
- Extent Deallocations/sec (ExtentDeallocationsSec)
- Extents Allocated/sec (ExtentsAllocatedSec)
- Failed AU cleanup batches/sec (FailedAUCleanupBatchesSec)
- Failed leaf page cookie (FailedLeafPageCookie)
- Failed tree page cookie (FailedTreePageCookie)
- Forwarded Records/sec (ForwardedRecordsSec)
- FreeSpace Page Fetches/sec (FreeSpacePageFetchesSec)
- FreeSpace Scans/sec (FreeSpaceScansSec)
- Full Scans/sec (FullScansSec)
- Index Searches/sec (IndexSearchesSec)
- InSysXact waits/sec (InSysXactWaitsSec)
- LobHandle Create Count (LobHandleCreateCount)
- LobHandle Destroy Count (LobHandleDestroyCount)
- LobSS Provider Create Count (LobSSProviderCreateCount)
- LobSS Provider Destroy Count (LobSSProviderDestroyCount)
- LobSS Provider Truncation Count (LobSSProviderTruncationCount)
- Mixed page allocations/sec (MixedPageAllocationsSec)
- Page compression attempts/sec (PageCompressionAttemptsSec)
- Page Deallocations/sec (PageDeallocationsSec)
- Pages Allocated/sec (PagesAllocatedSec)
- Pages compressed/sec (PagesCompressedSec)
- Page Splits/sec (PageSplitsSec)
- Probe Scans/sec (ProbeScansSec)
- Range Scans/sec (RangeScansSec)
- Scan Point Revalidations/sec (ScanPointRevalidationsSec)
- Skipped Ghosted Records/sec (SkippedGhostedRecordsSec)
- Table Lock Escalations/sec (TableLockEscalationsSec)
- Used leaf page cookie (UsedLeafPageCookie)
- Used tree page cookie (UsedTreePageCookie)
- Workfiles Created/sec (WorkfilesCreatedSec)
- Worktables Created/sec (WorktablesCreatedSec)
- Worktables From Cache Ratio (WorktablesFromCacheRatio)
Was this page helpful? Yes No
Submitting...
Thank you
Comments
Log in or register to comment.