WUtils.com

Win32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods, ROOT\CIMV2

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

Description

Collects statistics associated with the database server access methods

Win32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods properties

Win32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods has 53 properties (44 Local, 9 Derived)

NameOriginCIMType
AUcleanupbatchesPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
AUcleanupsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
ByreferenceLobCreateCountWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
ByreferenceLobUseCountWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
CaptionCIM_StatisticalInformation8 [string]
CountLobReadaheadWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
CountPullInRowWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
CountPushOffRowWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
DeferreddroppedAUsWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
DeferredDroppedrowsetsWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
DescriptionCIM_StatisticalInformation8 [string]
DroppedrowsetcleanupsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
DroppedrowsetsskippedPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
ExtentDeallocationsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
ExtentsAllocatedPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
FailedAUcleanupbatchesPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
FailedleafpagecookieWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
FailedtreepagecookieWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
ForwardedRecordsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
FreeSpacePageFetchesPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
FreeSpaceScansPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
FullScansPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
IndexSearchesPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
InSysXactwaitsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
LobHandleCreateCountWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
LobHandleDestroyCountWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
LobSSProviderCreateCountWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
LobSSProviderDestroyCountWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
LobSSProviderTruncationCountWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
MixedpageallocationsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
NameCIM_StatisticalInformation8 [string]
PagecompressionattemptsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
PageDeallocationsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
PagesAllocatedPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
PagescompressedPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
PageSplitsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
ProbeScansPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
RangeScansPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
ScanPointRevalidationsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
SkippedGhostedRecordsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
TableLockEscalationsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]
UsedleafpagecookieWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
UsedtreepagecookieWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
WorkfilesCreatedPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
WorktablesCreatedPersecWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
WorktablesFromCacheRatioWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]
WorktablesFromCacheRatio_BaseWin32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods21 [uint64]

Detailed description of Win32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods properties

Local properties (44) of Win32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods class

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

Derived properties (9) of Win32_PerfRawData_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_PerfRawData_MSSQLSERVER_SQLServerAccessMethods Qualifiers

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

Win32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods System properties

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

Similar Classes to Win32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods

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