Win32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods, ROOT\cimv2 - Instances

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

Instances of Win32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods

This section contains sample wmi instances of Win32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods class with their properties from Microsoft Windows Server 2012 R2 Datacenter Evaluation.
Win32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods is a singleton class, so it has only one instance (or no instance).

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods=@

Properties={
   'AUcleanupbatchesPersec' : '0' //String, 0x0
   'AUcleanupsPersec' : '0' //String, 0x0
   'ByreferenceLobCreateCount' : '0' //String, 0x0
   'ByreferenceLobUseCount' : '0' //String, 0x0
   'Caption' : null
   'CountLobReadahead' : '0' //String, 0x0
   'CountPullInRow' : '0' //String, 0x0
   'CountPushOffRow' : '0' //String, 0x0
   'DeferreddroppedAUs' : '0' //String, 0x0
   'DeferredDroppedrowsets' : '0' //String, 0x0
   'Description' : null
   'DroppedrowsetcleanupsPersec' : '0' //String, 0x0
   'DroppedrowsetsskippedPersec' : '0' //String, 0x0
   'ExtentDeallocationsPersec' : '0' //String, 0x0
   'ExtentsAllocatedPersec' : '0' //String, 0x0
   'FailedAUcleanupbatchesPersec' : '0' //String, 0x0
   'Failedleafpagecookie' : '0' //String, 0x0
   'Failedtreepagecookie' : '0' //String, 0x0
   'ForwardedRecordsPersec' : '0' //String, 0x0
   'FreeSpacePageFetchesPersec' : '0' //String, 0x0
   'FreeSpaceScansPersec' : '0' //String, 0x0
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '2746789' //String, 0x29E9A5
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'FullScansPersec' : '11054' //String, 0x2B2E
   'IndexSearchesPersec' : '1273645' //String, 0x136F2D
   'InSysXactwaitsPersec' : '0' //String, 0x0
   'LobHandleCreateCount' : '0' //String, 0x0
   'LobHandleDestroyCount' : '0' //String, 0x0
   'LobSSProviderCreateCount' : '4' //String, 0x4
   'LobSSProviderDestroyCount' : '4' //String, 0x4
   'LobSSProviderTruncationCount' : '0' //String, 0x0
   'MixedpageallocationsPersec' : '6' //String, 0x6
   'Name' : null
   'PagecompressionattemptsPersec' : '0' //String, 0x0
   'PageDeallocationsPersec' : '1' //String, 0x1
   'PagesAllocatedPersec' : '7' //String, 0x7
   'PagescompressedPersec' : '0' //String, 0x0
   'PageSplitsPersec' : '5' //String, 0x5
   'ProbeScansPersec' : '512081' //String, 0x7D051
   'RangeScansPersec' : '708308' //String, 0xACED4
   'ScanPointRevalidationsPersec' : '1130' //String, 0x46A
   'SkippedGhostedRecordsPersec' : '1130' //String, 0x46A
   'TableLockEscalationsPersec' : '0' //String, 0x0
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '243063855913' //String
   'Timestamp_Sys100NS' : '130603634090210000' //String
   'Usedleafpagecookie' : '0' //String, 0x0
   'Usedtreepagecookie' : '0' //String, 0x0
   'WorkfilesCreatedPersec' : '4672' //String, 0x1240
   'WorktablesCreatedPersec' : '1610' //String, 0x64A
   'WorktablesFromCacheRatio' : '0' //String, 0x0
   'WorktablesFromCacheRatio_Base' : '0' //String, 0x0
}
comments powered by Disqus
WUtils.com