Win32_PerfFormattedData_NETDataProviderforSqlServer 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_PerfFormattedData_NETDataProviderforSqlServer 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_PerfFormattedData_NETDataProviderforSqlServer_NETDataProviderforSqlServer", "WQL");

var enumItems = new Enumerator(colItems);

for (; !enumItems.atEnd(); enumItems.moveNext()) {
	var objItem = enumItems.item();
	WScript.Echo("Caption: " + objItem.Caption);
	WScript.Echo("Description: " + objItem.Description);
	WScript.Echo("Frequency_Object: " + objItem.Frequency_Object);
	WScript.Echo("Frequency_PerfTime: " + objItem.Frequency_PerfTime);
	WScript.Echo("Frequency_Sys100NS: " + objItem.Frequency_Sys100NS);
	WScript.Echo("HardConnectsPerSecond: " + objItem.HardConnectsPerSecond);
	WScript.Echo("HardDisconnectsPerSecond: " + objItem.HardDisconnectsPerSecond);
	WScript.Echo("Name: " + objItem.Name);
	WScript.Echo("NumberOfActiveConnectionPoolGroups: " + objItem.NumberOfActiveConnectionPoolGroups);
	WScript.Echo("NumberOfActiveConnectionPools: " + objItem.NumberOfActiveConnectionPools);
	WScript.Echo("NumberOfActiveConnections: " + objItem.NumberOfActiveConnections);
	WScript.Echo("NumberOfFreeConnections: " + objItem.NumberOfFreeConnections);
	WScript.Echo("NumberOfInactiveConnectionPoolGroups: " + objItem.NumberOfInactiveConnectionPoolGroups);
	WScript.Echo("NumberOfInactiveConnectionPools: " + objItem.NumberOfInactiveConnectionPools);
	WScript.Echo("NumberOfNonPooledConnections: " + objItem.NumberOfNonPooledConnections);
	WScript.Echo("NumberOfPooledConnections: " + objItem.NumberOfPooledConnections);
	WScript.Echo("NumberOfReclaimedConnections: " + objItem.NumberOfReclaimedConnections);
	WScript.Echo("NumberOfStasisConnections: " + objItem.NumberOfStasisConnections);
	WScript.Echo("SoftConnectsPerSecond: " + objItem.SoftConnectsPerSecond);
	WScript.Echo("SoftDisconnectsPerSecond: " + objItem.SoftDisconnectsPerSecond);
	WScript.Echo("Timestamp_Object: " + objItem.Timestamp_Object);
	WScript.Echo("Timestamp_PerfTime: " + objItem.Timestamp_PerfTime);
	WScript.Echo("Timestamp_Sys100NS: " + objItem.Timestamp_Sys100NS);
	WScript.Echo("")
	WScript.Echo("########")
	WScript.Echo("")
}