WUtils.com

Win32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods, ROOT\CIMV2

Class | Methods | Properties (52) | Qualifiers (15) | Instances (1) | Namespaces (1)
Samples: VB Script | C# | VB.Net | Search on:Microsoft

Description

Collects statistics associated with the database server access methods

Win32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods properties

Win32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods has 52 properties (43 Local, 9 Derived)

NameOriginCIMType
AUcleanupbatchesPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
AUcleanupsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
ByreferenceLobCreateCountWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
ByreferenceLobUseCountWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
CaptionCIM_StatisticalInformation8 [string]
CountLobReadaheadWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
CountPullInRowWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
CountPushOffRowWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
DeferreddroppedAUsWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
DeferredDroppedrowsetsWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
DescriptionCIM_StatisticalInformation8 [string]
DroppedrowsetcleanupsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
DroppedrowsetsskippedPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
ExtentDeallocationsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
ExtentsAllocatedPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
FailedAUcleanupbatchesPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
FailedleafpagecookieWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
FailedtreepagecookieWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
ForwardedRecordsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
FreeSpacePageFetchesPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
FreeSpaceScansPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
FullScansPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
IndexSearchesPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
InSysXactwaitsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
LobHandleCreateCountWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
LobHandleDestroyCountWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
LobSSProviderCreateCountWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
LobSSProviderDestroyCountWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
LobSSProviderTruncationCountWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
MixedpageallocationsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
NameCIM_StatisticalInformation8 [string]
PagecompressionattemptsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
PageDeallocationsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
PagesAllocatedPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
PagescompressedPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
PageSplitsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
ProbeScansPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
RangeScansPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
ScanPointRevalidationsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
SkippedGhostedRecordsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
TableLockEscalationsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]
UsedleafpagecookieWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
UsedtreepagecookieWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
WorkfilesCreatedPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
WorktablesCreatedPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
WorktablesFromCacheRatioWin32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]

Detailed description of Win32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods properties

Local properties (43) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods class

…
▲ AUcleanupbatchesPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'AUcleanupbatchesPersec'
CounterType272696576
Description'The number of batches that completed successfully per second by the background task that cleans up deferred dropped allocation units.'
DisplayName'AU cleanup batches/sec'
DisplayName009'AU cleanup batches/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
AUcleanupbatchesPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ AUcleanupsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'AUcleanupsPersec'
CounterType272696576
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.'
DisplayName'AU cleanups/sec'
DisplayName009'AU cleanups/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
AUcleanupsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ ByreferenceLobCreateCount property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'ByreferenceLobCreateCount'
CounterType272696576
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.'
DisplayName'By-reference Lob Create Count'
DisplayName009'By-reference Lob Create Count'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
ByreferenceLobCreateCount property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ ByreferenceLobUseCount property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'ByreferenceLobUseCount'
CounterType272696576
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.'
DisplayName'By-reference Lob Use Count'
DisplayName009'By-reference Lob Use Count'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
ByreferenceLobUseCount property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ CountLobReadahead property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'CountLobReadahead'
CounterType272696576
Description'Count of lob pages on which readahead was issued.'
DisplayName'Count Lob Readahead'
DisplayName009'Count Lob Readahead'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
CountLobReadahead property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ CountPullInRow property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'CountPullInRow'
CounterType272696576
Description'Count of values that were pulled in-row from off-row.'
DisplayName'Count Pull In Row'
DisplayName009'Count Pull In Row'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
CountPullInRow property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ CountPushOffRow property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'CountPushOffRow'
CounterType272696576
Description'Count of values that were pushed from in-row to off-row.'
DisplayName'Count Push Off Row'
DisplayName009'Count Push Off Row'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
CountPushOffRow property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ DeferreddroppedAUs property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'DeferreddroppedAUs'
CounterType65792
Description'The number of allocation units waiting to be dropped by the background task that cleans up deferred dropped allocation units.'
DisplayName'Deferred dropped AUs'
DisplayName009'Deferred dropped AUs'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
DeferreddroppedAUs property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ DeferredDroppedrowsets property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'DeferredDroppedrowsets'
CounterType65792
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.'
DisplayName'Deferred Dropped rowsets'
DisplayName009'Deferred Dropped rowsets'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
DeferredDroppedrowsets property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ DroppedrowsetcleanupsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'DroppedrowsetcleanupsPersec'
CounterType272696576
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.'
DisplayName'Dropped rowset cleanups/sec'
DisplayName009'Dropped rowset cleanups/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
DroppedrowsetcleanupsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ DroppedrowsetsskippedPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'DroppedrowsetsskippedPersec'
CounterType272696576
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.'
DisplayName'Dropped rowsets skipped/sec'
DisplayName009'Dropped rowsets skipped/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
DroppedrowsetsskippedPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ ExtentDeallocationsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'ExtentDeallocationsPersec'
CounterType272696576
Description'Number of extents deallocated per second in all databases in this SQL Server instance.'
DisplayName'Extent Deallocations/sec'
DisplayName009'Extent Deallocations/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
ExtentDeallocationsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ ExtentsAllocatedPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'ExtentsAllocatedPersec'
CounterType272696576
Description'Number of extents allocated per second in all databases in this SQL Server instance.'
DisplayName'Extents Allocated/sec'
DisplayName009'Extents Allocated/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
ExtentsAllocatedPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ FailedAUcleanupbatchesPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'FailedAUcleanupbatchesPersec'
CounterType272696576
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.'
DisplayName'Failed AU cleanup batches/sec'
DisplayName009'Failed AU cleanup batches/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
FailedAUcleanupbatchesPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Failedleafpagecookie property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'Failedleafpagecookie'
CounterType272696576
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.'
DisplayName'Failed leaf page cookie'
DisplayName009'Failed leaf page cookie'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Failedleafpagecookie property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Failedtreepagecookie property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'Failedtreepagecookie'
CounterType272696576
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.'
DisplayName'Failed tree page cookie'
DisplayName009'Failed tree page cookie'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Failedtreepagecookie property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ ForwardedRecordsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'ForwardedRecordsPersec'
CounterType272696576
Description'Number of records fetched through forwarded record pointers.'
DisplayName'Forwarded Records/sec'
DisplayName009'Forwarded Records/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
ForwardedRecordsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ FreeSpacePageFetchesPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'FreeSpacePageFetchesPersec'
CounterType272696576
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.'
DisplayName'FreeSpace Page Fetches/sec'
DisplayName009'FreeSpace Page Fetches/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
FreeSpacePageFetchesPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ FreeSpaceScansPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'FreeSpaceScansPersec'
CounterType272696576
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.'
DisplayName'FreeSpace Scans/sec'
DisplayName009'FreeSpace Scans/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
FreeSpaceScansPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ FullScansPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'FullScansPersec'
CounterType272696576
Description'Number of unrestricted full scans. These can either be base table or full index scans.'
DisplayName'Full Scans/sec'
DisplayName009'Full Scans/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
FullScansPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ IndexSearchesPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'IndexSearchesPersec'
CounterType272696576
Description'Number of index searches. Index searches are used to start range scans, single index record fetches, and to reposition within an index.'
DisplayName'Index Searches/sec'
DisplayName009'Index Searches/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
IndexSearchesPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ InSysXactwaitsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'InSysXactwaitsPersec'
CounterType272696576
Description'Number of times a reader needs to wait for a page because the InSysXact bit is set'
DisplayName'InSysXact waits/sec'
DisplayName009'InSysXact waits/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
InSysXactwaitsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LobHandleCreateCount property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'LobHandleCreateCount'
CounterType272696576
Description'Count of temporary LOBs created.'
DisplayName'LobHandle Create Count'
DisplayName009'LobHandle Create Count'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
LobHandleCreateCount property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LobHandleDestroyCount property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'LobHandleDestroyCount'
CounterType272696576
Description'Count of temporary LOBs destroyed.'
DisplayName'LobHandle Destroy Count'
DisplayName009'LobHandle Destroy Count'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
LobHandleDestroyCount property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LobSSProviderCreateCount property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'LobSSProviderCreateCount'
CounterType272696576
Description'Count of LOB Storage Service Providers created. One worktable created per LOB Storage Service Provider.'
DisplayName'LobSS Provider Create Count'
DisplayName009'LobSS Provider Create Count'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
LobSSProviderCreateCount property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LobSSProviderDestroyCount property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'LobSSProviderDestroyCount'
CounterType272696576
Description'Count of LOB Storage Service Providers destroyed.'
DisplayName'LobSS Provider Destroy Count'
DisplayName009'LobSS Provider Destroy Count'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
LobSSProviderDestroyCount property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LobSSProviderTruncationCount property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'LobSSProviderTruncationCount'
CounterType272696576
Description'Count of LOB Storage Service Providers truncated.'
DisplayName'LobSS Provider Truncation Count'
DisplayName009'LobSS Provider Truncation Count'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
LobSSProviderTruncationCount property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ MixedpageallocationsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'MixedpageallocationsPersec'
CounterType272696576
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.'
DisplayName'Mixed page allocations/sec'
DisplayName009'Mixed page allocations/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
MixedpageallocationsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ PagecompressionattemptsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'PagecompressionattemptsPersec'
CounterType272696576
Description'Number of attempts to compress a database page per second'
DisplayName'Page compression attempts/sec'
DisplayName009'Page compression attempts/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
PagecompressionattemptsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ PageDeallocationsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'PageDeallocationsPersec'
CounterType272696576
Description'Number of pages deallocated per second in all databases in this SQL Server instance. These include pages from mixed extents and uniform extents.'
DisplayName'Page Deallocations/sec'
DisplayName009'Page Deallocations/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
PageDeallocationsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ PagesAllocatedPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'PagesAllocatedPersec'
CounterType272696576
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.'
DisplayName'Pages Allocated/sec'
DisplayName009'Pages Allocated/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
PagesAllocatedPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ PagescompressedPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'PagescompressedPersec'
CounterType272696576
Description'Number of times a database page was compressed'
DisplayName'Pages compressed/sec'
DisplayName009'Pages compressed/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
PagescompressedPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ PageSplitsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'PageSplitsPersec'
CounterType272696576
Description'Number of page splits per second that occur as a result of overflowing index pages.'
DisplayName'Page Splits/sec'
DisplayName009'Page Splits/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
PageSplitsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ ProbeScansPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'ProbeScansPersec'
CounterType272696576
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.'
DisplayName'Probe Scans/sec'
DisplayName009'Probe Scans/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
ProbeScansPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ RangeScansPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'RangeScansPersec'
CounterType272696576
Description'Number of qualified range scans through indexes per second.'
DisplayName'Range Scans/sec'
DisplayName009'Range Scans/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
RangeScansPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ ScanPointRevalidationsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'ScanPointRevalidationsPersec'
CounterType272696576
Description'Number of times the scan point had to be revalidated to continue the scan.'
DisplayName'Scan Point Revalidations/sec'
DisplayName009'Scan Point Revalidations/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
ScanPointRevalidationsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ SkippedGhostedRecordsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'SkippedGhostedRecordsPersec'
CounterType272696576
Description'Number of ghosted records per second skipped during scans.'
DisplayName'Skipped Ghosted Records/sec'
DisplayName009'Skipped Ghosted Records/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
SkippedGhostedRecordsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ TableLockEscalationsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'TableLockEscalationsPersec'
CounterType272696576
Description'The number of times locks on a table were escalated.'
DisplayName'Table Lock Escalations/sec'
DisplayName009'Table Lock Escalations/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
TableLockEscalationsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Usedleafpagecookie property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'Usedleafpagecookie'
CounterType272696576
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.'
DisplayName'Used leaf page cookie'
DisplayName009'Used leaf page cookie'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Usedleafpagecookie property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Usedtreepagecookie property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'Usedtreepagecookie'
CounterType272696576
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.'
DisplayName'Used tree page cookie'
DisplayName009'Used tree page cookie'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Usedtreepagecookie property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ WorkfilesCreatedPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'WorkfilesCreatedPersec'
CounterType272696576
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.'
DisplayName'Workfiles Created/sec'
DisplayName009'Workfiles Created/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
WorkfilesCreatedPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ WorktablesCreatedPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'WorktablesCreatedPersec'
CounterType272696576
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.'
DisplayName'Worktables Created/sec'
DisplayName009'Worktables Created/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
WorktablesCreatedPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ WorktablesFromCacheRatio property
CIMTYPE'uint64'
CookingType''
Counter'WorktablesFromCacheRatio'
CounterType537003264
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.'
DisplayName'Worktables From Cache Ratio'
DisplayName009'Worktables From Cache Ratio'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
WorktablesFromCacheRatio property is in 4 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods class

…
▲ Caption property
CIMTYPE'string'
Description'A short textual description (one-line string) for the statistic or metric.'
MaxLen64
readTrue
Caption property is in 1050 classes of ROOT\cimv2 and in 37 namespaces
…
▲ Description property
CIMTYPE'string'
Description'A textual description of the statistic or metric.'
readTrue
Description property is in 1061 classes of ROOT\cimv2 and in 142 namespaces
…
▲ Frequency_Object property
CIMTYPE'uint64'
Frequency_Object property is in 727 classes of ROOT\cimv2 and in 2 namespaces
…
▲ Frequency_PerfTime property
CIMTYPE'uint64'
Frequency_PerfTime property is in 727 classes of ROOT\cimv2 and in 2 namespaces
…
▲ Frequency_Sys100NS property
CIMTYPE'uint64'
Frequency_Sys100NS property is in 727 classes of ROOT\cimv2 and in 2 namespaces
…
▲ Name property
CIMTYPE'string'
Description'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. '
MaxLen256
readTrue
Name property is in 1046 classes of ROOT\cimv2 and in 142 namespaces
…
▲ Timestamp_Object property
CIMTYPE'uint64'
Timestamp_Object property is in 727 classes of ROOT\cimv2 and in 2 namespaces
…
▲ Timestamp_PerfTime property
CIMTYPE'uint64'
Timestamp_PerfTime property is in 727 classes of ROOT\cimv2 and in 2 namespaces
…
▲ Timestamp_Sys100NS property
CIMTYPE'uint64'
Timestamp_Sys100NS property is in 727 classes of ROOT\cimv2 and in 2 namespaces

Win32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods Qualifiers

…
NameValueToInstanceToSubclassOverridableAmendedLocal
AutoCook1✓✗✓✗✓
AutoCook_RawClass'Win32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods'✓✗✓✗✓
CookedTrue✓✗✓✗✓
Description'Collects statistics associated with the database server access methods'✓✗✓✓✓
DisplayName'SQLServer:Access Methods'✓✗✓✓✓
DisplayName009'SQLServer:Access Methods'✓✗✓✗✓
dynamicTrue✓✗✓✗✓
GenericPerfCtrTrue✓✗✓✗✓
HelpIndex0✓✗✓✗✓
HiPerfTrue✓✗✓✗✓
Locale1033✓✗✓✓✓
PerfIndex0✓✗✓✗✓
provider'WmiPerfInst'✗✗✓✗✓
RegistryKey'MSSQLSERVER'✓✗✓✗✓
SingletonTrue✓✓✗✗✓

Win32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods System properties

…
NameValueOriginCIMTypeLocalArray
__PATH'\\.\ROOT\cimv2:Win32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods'___SYSTEM8✗✗
__NAMESPACE'ROOT\cimv2'___SYSTEM8✗✗
__SERVER'.'___SYSTEM8✗✗
__DERIVATION['Win32_PerfFormattedData', 'Win32_Perf', 'CIM_StatisticalInformation']___SYSTEM8✗✓
__PROPERTY_COUNT52___SYSTEM3✗✗
__RELPATH'Win32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods'___SYSTEM8✗✗
__DYNASTY'CIM_StatisticalInformation'___SYSTEM8✗✗
__SUPERCLASS'Win32_PerfFormattedData'___SYSTEM8✗✗
__CLASS'Win32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods'___SYSTEM8✗✗
__GENUS1___SYSTEM3✗✗

Similar Classes to Win32_PerfFormattedData_MSSQLSERVER_SQLServerAccessMethods

Number of classes:1
…
Class nameChildsPropertiesMethodsClass
Instances		Child
Instances		AbstractSingleton
Win32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods05301--✓
comments powered by Disqus
WUtils.com