Win32_PerfRawData_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_PerfRawData_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_PerfRawData_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("") }