Win32_PerfRawData_MSSQLSERVER jscript sample code

The foundations for Manageability in Windows is Windows Management Instrumentation (WMI; formerly WBEM) and WMI extensions for Windows Driver Model (WDM).

ActiveXperts Network Monitor provides the ability to build monitor check routines based on WMI. ActiveXperts has collected more than a hundred WMI samples. You can use these samples as a base for new check routines you can write yourself. The Win32_PerfRawData_MSSQLSERVER WMI class can be used in ActiveXperts Network Monitor to monitor your servers.

---

Sample Code

var strComputer = ".";

var objWMIService = GetObject("winmgmts:\\\\" + strComputer + "\\root\\CIMV2");
var colItems = objWMIService.ExecQuery("SELECT * FROM Win32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods", "WQL");

var enumItems = new Enumerator(colItems);

for (; !enumItems.atEnd(); enumItems.moveNext()) {
	var objItem = enumItems.item();
	WScript.Echo("AUcleanupbatchesPersec: " + objItem.AUcleanupbatchesPersec);
	WScript.Echo("AUcleanupsPersec: " + objItem.AUcleanupsPersec);
	WScript.Echo("ByreferenceLobCreateCount: " + objItem.ByreferenceLobCreateCount);
	WScript.Echo("ByreferenceLobUseCount: " + objItem.ByreferenceLobUseCount);
	WScript.Echo("Caption: " + objItem.Caption);
	WScript.Echo("CountLobReadahead: " + objItem.CountLobReadahead);
	WScript.Echo("CountPullInRow: " + objItem.CountPullInRow);
	WScript.Echo("CountPushOffRow: " + objItem.CountPushOffRow);
	WScript.Echo("DeferreddroppedAUs: " + objItem.DeferreddroppedAUs);
	WScript.Echo("DeferredDroppedrowsets: " + objItem.DeferredDroppedrowsets);
	WScript.Echo("Description: " + objItem.Description);
	WScript.Echo("DroppedrowsetcleanupsPersec: " + objItem.DroppedrowsetcleanupsPersec);
	WScript.Echo("DroppedrowsetsskippedPersec: " + objItem.DroppedrowsetsskippedPersec);
	WScript.Echo("ExtentDeallocationsPersec: " + objItem.ExtentDeallocationsPersec);
	WScript.Echo("ExtentsAllocatedPersec: " + objItem.ExtentsAllocatedPersec);
	WScript.Echo("FailedAUcleanupbatchesPersec: " + objItem.FailedAUcleanupbatchesPersec);
	WScript.Echo("Failedleafpagecookie: " + objItem.Failedleafpagecookie);
	WScript.Echo("Failedtreepagecookie: " + objItem.Failedtreepagecookie);
	WScript.Echo("ForwardedRecordsPersec: " + objItem.ForwardedRecordsPersec);
	WScript.Echo("FreeSpacePageFetchesPersec: " + objItem.FreeSpacePageFetchesPersec);
	WScript.Echo("FreeSpaceScansPersec: " + objItem.FreeSpaceScansPersec);
	WScript.Echo("Frequency_Object: " + objItem.Frequency_Object);
	WScript.Echo("Frequency_PerfTime: " + objItem.Frequency_PerfTime);
	WScript.Echo("Frequency_Sys100NS: " + objItem.Frequency_Sys100NS);
	WScript.Echo("FullScansPersec: " + objItem.FullScansPersec);
	WScript.Echo("IndexSearchesPersec: " + objItem.IndexSearchesPersec);
	WScript.Echo("LobHandleCreateCount: " + objItem.LobHandleCreateCount);
	WScript.Echo("LobHandleDestroyCount: " + objItem.LobHandleDestroyCount);
	WScript.Echo("LobSSProviderCreateCount: " + objItem.LobSSProviderCreateCount);
	WScript.Echo("LobSSProviderDestroyCount: " + objItem.LobSSProviderDestroyCount);
	WScript.Echo("LobSSProviderTruncationCount: " + objItem.LobSSProviderTruncationCount);
	WScript.Echo("MixedpageallocationsPersec: " + objItem.MixedpageallocationsPersec);
	WScript.Echo("Name: " + objItem.Name);
	WScript.Echo("PagecompressionattemptsPersec: " + objItem.PagecompressionattemptsPersec);
	WScript.Echo("PageDeallocationsPersec: " + objItem.PageDeallocationsPersec);
	WScript.Echo("PagesAllocatedPersec: " + objItem.PagesAllocatedPersec);
	WScript.Echo("PagescompressedPersec: " + objItem.PagescompressedPersec);
	WScript.Echo("PageSplitsPersec: " + objItem.PageSplitsPersec);
	WScript.Echo("ProbeScansPersec: " + objItem.ProbeScansPersec);
	WScript.Echo("RangeScansPersec: " + objItem.RangeScansPersec);
	WScript.Echo("ScanPointRevalidationsPersec: " + objItem.ScanPointRevalidationsPersec);
	WScript.Echo("SkippedGhostedRecordsPersec: " + objItem.SkippedGhostedRecordsPersec);
	WScript.Echo("TableLockEscalationsPersec: " + objItem.TableLockEscalationsPersec);
	WScript.Echo("Timestamp_Object: " + objItem.Timestamp_Object);
	WScript.Echo("Timestamp_PerfTime: " + objItem.Timestamp_PerfTime);
	WScript.Echo("Timestamp_Sys100NS: " + objItem.Timestamp_Sys100NS);
	WScript.Echo("Usedleafpagecookie: " + objItem.Usedleafpagecookie);
	WScript.Echo("Usedtreepagecookie: " + objItem.Usedtreepagecookie);
	WScript.Echo("WorkfilesCreatedPersec: " + objItem.WorkfilesCreatedPersec);
	WScript.Echo("WorktablesCreatedPersec: " + objItem.WorktablesCreatedPersec);
	WScript.Echo("WorktablesFromCacheRatio: " + objItem.WorktablesFromCacheRatio);
	WScript.Echo("WorktablesFromCacheRatio_Base: " + objItem.WorktablesFromCacheRatio_Base);
	WScript.Echo("")
	WScript.Echo("########")
	WScript.Echo("")
}