SQLServerGeneralStatistics - WMI sample in VBScript

The foundations for Manageability in Windows 2019/2012/2008/ and Windows 10/8/7/Vista/XP are 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.

On this site, you can find many WMI samples.

The SQLServerGeneralStatistics WMI class can be used in ActiveXperts Network Monitor to monitor your servers.

---

SQLServerGeneralStatistics

Example(s)

Set objWMIService = GetObject("winmgmts:\\.\root\cimv2")

Set colItems = objWMIService.ExecQuery("Select * From Win32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics")

For Each objItem in colItems
	WScript.Echo "ActiveTempTables:" & objItem.ActiveTempTables
	WScript.Echo "Caption:" & objItem.Caption
	WScript.Echo "ConnectionResetPersec:" & objItem.ConnectionResetPersec
	WScript.Echo "Description:" & objItem.Description
	WScript.Echo "EventNotificationsDelayedDrop:" & objItem.EventNotificationsDelayedDrop
	WScript.Echo "Frequency_Object:" & objItem.Frequency_Object
	WScript.Echo "Frequency_PerfTime:" & objItem.Frequency_PerfTime
	WScript.Echo "Frequency_Sys100NS:" & objItem.Frequency_Sys100NS
	WScript.Echo "HTTPAuthenticatedRequests:" & objItem.HTTPAuthenticatedRequests
	WScript.Echo "LogicalConnections:" & objItem.LogicalConnections
	WScript.Echo "LoginsPersec:" & objItem.LoginsPersec
	WScript.Echo "LogoutsPersec:" & objItem.LogoutsPersec
	WScript.Echo "MarsDeadlocks:" & objItem.MarsDeadlocks
	WScript.Echo "Name:" & objItem.Name
	WScript.Echo "Nonatomicyieldrate:" & objItem.Nonatomicyieldrate
	WScript.Echo "Processesblocked:" & objItem.Processesblocked
	WScript.Echo "SOAPEmptyRequests:" & objItem.SOAPEmptyRequests
	WScript.Echo "SOAPMethodInvocations:" & objItem.SOAPMethodInvocations
	WScript.Echo "SOAPSessionInitiateRequests:" & objItem.SOAPSessionInitiateRequests
	WScript.Echo "SOAPSessionTerminateRequests:" & objItem.SOAPSessionTerminateRequests
	WScript.Echo "SOAPSQLRequests:" & objItem.SOAPSQLRequests
	WScript.Echo "SOAPWSDLRequests:" & objItem.SOAPWSDLRequests
	WScript.Echo "SQLTraceIOProviderLockWaits:" & objItem.SQLTraceIOProviderLockWaits
	WScript.Echo "Tempdbrecoveryunitid:" & objItem.Tempdbrecoveryunitid
	WScript.Echo "Tempdbrowsetid:" & objItem.Tempdbrowsetid
	WScript.Echo "TempTablesCreationRate:" & objItem.TempTablesCreationRate
	WScript.Echo "TempTablesForDestruction:" & objItem.TempTablesForDestruction
	WScript.Echo "Timestamp_Object:" & objItem.Timestamp_Object
	WScript.Echo "Timestamp_PerfTime:" & objItem.Timestamp_PerfTime
	WScript.Echo "Timestamp_Sys100NS:" & objItem.Timestamp_Sys100NS
	WScript.Echo "TraceEventNotificationQueue:" & objItem.TraceEventNotificationQueue
	WScript.Echo "Transactions:" & objItem.Transactions
	WScript.Echo "UserConnections:" & objItem.UserConnections
	WScript.Echo ""
	WScript.Echo "########"
	WScript.Echo ""
Next