| Win32_PerfFormattedData_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. | |
| SAMPLE DATA INSTANCE | |||
| [Description("Collects statistics associated with the database server access methods"): ToInstance Amended, DisplayName("SQLServer:Access Methods"): ToInstance Amended, genericperfctr: ToInstance Amended, locale(1033): ToInstance Amended] instance of Win32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods { [Description("The number of batches that completed successfully per second by the background task that cleans up deferred dropped allocation units."): ToInstance Amended, DisplayName("AU cleanup batches/sec"): ToInstance Amended] AUcleanupbatchesPersec = "0"; [Description("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."): ToInstance Amended, DisplayName("AU cleanups/sec"): ToInstance Amended] AUcleanupsPersec = "0"; [Description("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."): ToInstance Amended, DisplayName("By-reference Lob Create Count"): ToInstance Amended] ByreferenceLobCreateCount = "0"; [Description("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."): ToInstance Amended, DisplayName("By-reference Lob Use Count"): ToInstance Amended] ByreferenceLobUseCount = "0"; [Description("Count of lob pages on which readahead was issued."): ToInstance Amended, DisplayName("Count Lob Readahead"): ToInstance Amended] CountLobReadahead = "0"; [Description("Count of values that were pulled in-row from off-row."): ToInstance Amended, DisplayName("Count Pull In Row"): ToInstance Amended] CountPullInRow = "0"; [Description("Count of values that were pushed from in-row to off-row."): ToInstance Amended, DisplayName("Count Push Off Row"): ToInstance Amended] CountPushOffRow = "0"; [Description("The number of allocation units waiting to be dropped by the background task that cleans up deferred dropped allocation units."): ToInstance Amended, DisplayName("Deferred dropped AUs"): ToInstance Amended] DeferreddroppedAUs = "0"; [Description("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."): ToInstance Amended, DisplayName("Deferred Dropped rowsets"): ToInstance Amended] DeferredDroppedrowsets = "0"; [Description("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."): ToInstance Amended, DisplayName("Dropped rowset cleanups/sec"): ToInstance Amended] DroppedrowsetcleanupsPersec = "0"; [Description("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."): ToInstance Amended, DisplayName("Dropped rowsets skipped/sec"): ToInstance Amended] DroppedrowsetsskippedPersec = "0"; [Description("Number of extents deallocated per second in all databases in this SQL Server instance."): ToInstance Amended, DisplayName("Extent Deallocations/sec"): ToInstance Amended] ExtentDeallocationsPersec = "0"; [Description("Number of extents allocated per second in all databases in this SQL Server instance."): ToInstance Amended, DisplayName("Extents Allocated/sec"): ToInstance Amended] ExtentsAllocatedPersec = "0"; [Description("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."): ToInstance Amended, DisplayName("Failed AU cleanup batches/sec"): ToInstance Amended] FailedAUcleanupbatchesPersec = "0"; [Description("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."): ToInstance Amended, DisplayName("Failed leaf page cookie"): ToInstance Amended] Failedleafpagecookie = "0"; [Description("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."): ToInstance Amended, DisplayName("Failed tree page cookie"): ToInstance Amended] Failedtreepagecookie = "0"; [Description("Number of records fetched through forwarded record pointers."): ToInstance Amended, DisplayName("Forwarded Records/sec"): ToInstance Amended] ForwardedRecordsPersec = "0"; [Description("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."): ToInstance Amended, DisplayName("FreeSpace Page Fetches/sec"): ToInstance Amended] FreeSpacePageFetchesPersec = "0"; [Description("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."): ToInstance Amended, DisplayName("FreeSpace Scans/sec"): ToInstance Amended] FreeSpaceScansPersec = "0"; [Description("Number of unrestricted full scans. These can either be base table or full index scans."): ToInstance Amended, DisplayName("Full Scans/sec"): ToInstance Amended] FullScansPersec = "0"; [Description("Number of index searches. Index searches are used to start range scans, single index record fetches, and to reposition within an index."): ToInstance Amended, DisplayName("Index Searches/sec"): ToInstance Amended] IndexSearchesPersec = "0"; [Description("Count of temporary LOBs created."): ToInstance Amended, DisplayName("LobHandle Create Count"): ToInstance Amended] LobHandleCreateCount = "0"; [Description("Count of temporary LOBs destroyed."): ToInstance Amended, DisplayName("LobHandle Destroy Count"): ToInstance Amended] LobHandleDestroyCount = "0"; [Description("Count of LOB Storage Service Providers created. One worktable created per LOB Storage Service Provider."): ToInstance Amended, DisplayName("LobSS Provider Create Count"): ToInstance Amended] LobSSProviderCreateCount = "0"; [Description("Count of LOB Storage Service Providers destroyed."): ToInstance Amended, DisplayName("LobSS Provider Destroy Count"): ToInstance Amended] LobSSProviderDestroyCount = "0"; [Description("Count of LOB Storage Service Providers truncated."): ToInstance Amended, DisplayName("LobSS Provider Truncation Count"): ToInstance Amended] LobSSProviderTruncationCount = "0"; [Description("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."): ToInstance Amended, DisplayName("Mixed page allocations/sec"): ToInstance Amended] MixedpageallocationsPersec = "0"; [Description("Number of pages deallocated per second in all databases in this SQL Server instance. These include pages from mixed extents and uniform extents."): ToInstance Amended, DisplayName("Page Deallocations/sec"): ToInstance Amended] PageDeallocationsPersec = "0"; [Description("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."): ToInstance Amended, DisplayName("Pages Allocated/sec"): ToInstance Amended] PagesAllocatedPersec = "0"; [Description("Number of page splits per second that occur as a result of overflowing index pages."): ToInstance Amended, DisplayName("Page Splits/sec"): ToInstance Amended] PageSplitsPersec = "0"; [Description("Number of probe scans per second that are used to find at most one single qualified row in an index or base table directly."): ToInstance Amended, DisplayName("Probe Scans/sec"): ToInstance Amended] ProbeScansPersec = "0"; [Description("Number of qualified range scans through indexes per second."): ToInstance Amended, DisplayName("Range Scans/sec"): ToInstance Amended] RangeScansPersec = "0"; [Description("Number of times the scan point had to be revalidated to continue the scan."): ToInstance Amended, DisplayName("Scan Point Revalidations/sec"): ToInstance Amended] ScanPointRevalidationsPersec = "0"; [Description("Number of ghosted records per second skipped during scans."): ToInstance Amended, DisplayName("Skipped Ghosted Records/sec"): ToInstance Amended] SkippedGhostedRecordsPersec = "0"; [Description("The number of times locks on a table were escalated."): ToInstance Amended, DisplayName("Table Lock Escalations/sec"): ToInstance Amended] TableLockEscalationsPersec = "0"; [Description("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."): ToInstance Amended, DisplayName("Used leaf page cookie"): ToInstance Amended] Usedleafpagecookie = "0"; [Description("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."): ToInstance Amended, DisplayName("Used tree page cookie"): ToInstance Amended] Usedtreepagecookie = "0"; [Description("Number of work files created per second. For example, work files could be used to store temporary results for hash joins and hash aggregates."): ToInstance Amended, DisplayName("Workfiles Created/sec"): ToInstance Amended] WorkfilesCreatedPersec = "0"; [Description("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."): ToInstance Amended, DisplayName("Worktables Created/sec"): ToInstance Amended] WorktablesCreatedPersec = "0"; [Description("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."): ToInstance Amended, DisplayName("Worktables From Cache Ratio"): ToInstance Amended] WorktablesFromCacheRatio = "0"; }; | |||