| Win32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods |
| Collects statistics associated with the database server access methods |
| NameSpace Path |
| \ROOT\CIMV2 |
| PROPERTY | SMS_REPORT | CIMTYPE | DESCRIPTION |
| AUcleanupbatchesPersec | | UInt64 | The number of batches that completed successfully per second by the background task that cleans up deferred dropped allocation units. |
| AUcleanupsPersec | | UInt64 | The number of allocation units per second that were successfully dropped by the background task that cleans up deferred dropped allocation units. Each allocation unit drop requires multiple batches. |
| ByreferenceLobCreateCount | | UInt64 | Count of large object (LOB) values that were passed by reference. By-reference lobs are used in certain bulk operations to avoid the cost of passing them by value. |
| ByreferenceLobUseCount | | UInt64 | Count of by-reference lob values that were used. By-reference lobs are used in certain bulk operations to avoid the cost of passing them by value. |
| Caption | | String | A short textual description (one-line string) for the statistic or metric. |
| CountLobReadahead | | UInt64 | Count of lob pages on which readahead was issued. |
| CountPullInRow | | UInt64 | Count of values that were pulled in-row from off-row. |
| CountPushOffRow | | UInt64 | Count of values that were pushed from in-row to off-row. |
| DeferreddroppedAUs | | UInt64 | The number of allocation units waiting to be dropped by the background task that cleans up deferred dropped allocation units. |
| DeferredDroppedrowsets | | UInt64 | The number of rowsets created as a result of aborted online index build operations that are waiting to be dropped by the background task that cleans up deferred dropped rowsets. |
| Description | | String | A textual description of the statistic or metric. |
| DroppedrowsetcleanupsPersec | | UInt64 | The number of rowsets per second created as a result of aborted online index build operations that were successfully dropped by the background task that cleans up deferred dropped rowsets. |
| DroppedrowsetsskippedPersec | | UInt64 | The number of rowsets per second created as a result of aborted online index build operations that were skipped by the background task that cleans up deferred dropped rowsets created. |
| ExtentDeallocationsPersec | | UInt64 | Number of extents deallocated per second in all databases in this SQL Server instance. |
| ExtentsAllocatedPersec | | UInt64 | Number of extents allocated per second in all databases in this SQL Server instance. |
| FailedAUcleanupbatchesPersec | | UInt64 | The number of batches per second that failed and required retry, by the background task that cleans up deferred dropped allocation units. Failure could be due to lack of memory or disk space, hardware failure and other reasons. |
| Failedleafpagecookie | | UInt64 | The number of times that a leaf page cookie could not be used during an index search since changes happened on the leaf page. The cookie is used to speed up index search. |
| Failedtreepagecookie | | UInt64 | The number of times that a tree page cookie could not be used during an index search since changes happened on the parent pages of those tree pages. The cookie is used to speed up index search. |
| ForwardedRecordsPersec | | UInt64 | Number of records fetched through forwarded record pointers. |
| FreeSpacePageFetchesPersec | | UInt64 | Number of pages fetched per second by free space scans. These scans search for free space within pages already allocated to an allocation unit, to satisfy requests to insert or modify record fragments. |
| FreeSpaceScansPersec | | UInt64 | Number of scans per second that were initiated to search for free space within pages already allocated to an allocation unit to insert or modify record fragments. Each scan may find multiple pages. |
| Frequency_Object | | UInt64 | NA |
| Frequency_PerfTime | | UInt64 | NA |
| Frequency_Sys100NS | | UInt64 | NA |
| FullScansPersec | | UInt64 | Number of unrestricted full scans. These can either be base table or full index scans. |
| IndexSearchesPersec | | UInt64 | Number of index searches. Index searches are used to start range scans, single index record fetches, and to reposition within an index. |
| LobHandleCreateCount | | UInt64 | Count of temporary LOBs created. |
| LobHandleDestroyCount | | UInt64 | Count of temporary LOBs destroyed. |
| LobSSProviderCreateCount | | UInt64 | Count of LOB Storage Service Providers created. One worktable created per LOB Storage Service Provider. |
| LobSSProviderDestroyCount | | UInt64 | Count of LOB Storage Service Providers destroyed. |
| LobSSProviderTruncationCount | | UInt64 | Count of LOB Storage Service Providers truncated. |
| MixedpageallocationsPersec | | UInt64 | Number of pages allocated per second from mixed extents. These could be used for storing the IAM pages and the first eight pages that are allocated to an allocation unit. |
| Name | | String | The Name property defines the label by which the statistic or metric is known. When subclassed, the property can be overridden to be a Key property. |
| PageDeallocationsPersec | | UInt64 | Number of pages deallocated per second in all databases in this SQL Server instance. These include pages from mixed extents and uniform extents. |
| PagesAllocatedPersec | | UInt64 | Number of pages allocated per second in all databases in this SQL Server instance. These include pages allocations from both mixed extents and uniform extents. |
| PageSplitsPersec | | UInt64 | Number of page splits per second that occur as a result of overflowing index pages. |
| ProbeScansPersec | | UInt64 | Number of probe scans per second that are used to find at most one single qualified row in an index or base table directly. |
| RangeScansPersec | | UInt64 | Number of qualified range scans through indexes per second. |
| ScanPointRevalidationsPersec | | UInt64 | Number of times the scan point had to be revalidated to continue the scan. |
| SkippedGhostedRecordsPersec | | UInt64 | Number of ghosted records per second skipped during scans. |
| TableLockEscalationsPersec | | UInt64 | The number of times locks on a table were escalated. |
| Timestamp_Object | | UInt64 | NA |
| Timestamp_PerfTime | | UInt64 | NA |
| Timestamp_Sys100NS | | UInt64 | NA |
| Usedleafpagecookie | | UInt64 | Number of times a leaf page cookie was used successfully during an index search since no change happened on the leaf page. The cookie is used to speed up index search. |
| Usedtreepagecookie | | UInt64 | Number of times a tree page cookie was used successfully during an index search since no change happened on the parent page of the tree page. The cookie is used to speed up index search. |
| WorkfilesCreatedPersec | | UInt64 | Number of work files created per second. For example, work files could be used to store temporary results for hash joins and hash aggregates. |
| WorktablesCreatedPersec | | UInt64 | Number of work tables created per second. For example, work tables could be used to store temporary results for query spool, LOB variables, XML variables, and cursors. |
| WorktablesFromCacheRatio | | UInt64 | Percentage of work tables created where the initial two pages of the work table were not allocated but were immediately available from the work table cache. |
| WorktablesFromCacheRatio_Base | | UInt64 | Percent of worktables from cache base. |
| SAMPLE DATA INSTANCE |
Class does not currently contain data instances
|
