You are here:
ActiveXperts.com > Administration > Scripts > WMI > VBScript > Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSWorkloadGroupStats
ActiveXperts Network Monitor ships with a large collection of WMI based PowerShell scripts and VBScript scripts to monitor and manage a network.
Use ActiveXperts Netork Monitor to monitor your virtualization servers, domains, computers and devices. It runs on a single Windows server, without agents required on the monitored systems. It has many built-in checks and also allows administrators to create custom checks using PowerShell, VBScript, WMI and SSH.
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSWorkloadGroupStats - WMI sample in VBScript
The foundations for Manageability in Windows 7/2008/Vista/XP/2000 and Millennium Edition/'98 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 Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSWorkloadGroupStats WMI class can be used in ActiveXperts Network Monitor to monitor your servers.
Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSWorkloadGroupStats
Description
ActiveXperts Network Monitor ships with a large collection of WMI based PowerShell scripts and VBScript scripts to monitor and manage a network.Use ActiveXperts Netork Monitor to monitor your virtualization servers, domains, computers and devices. It runs on a single Windows server, without agents required on the monitored systems. It has many built-in checks and also allows administrators to create custom checks using PowerShell, VBScript, WMI and SSH.
Example(s)
On Error Resume Next
strComputer = "."
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")
Set colItems = objWMIService.ExecQuery("Select * from Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSWorkloadGroupStats",,48)
For Each objItem in colItems
Wscript.Echo "Activeparallelthreads: " & objItem.Activeparallelthreads
Wscript.Echo "Activerequests: " & objItem.Activerequests
Wscript.Echo "Blockedtasks: " & objItem.Blockedtasks
Wscript.Echo "Caption: " & objItem.Caption
Wscript.Echo "CPUusagePercent: " & objItem.CPUusagePercent
Wscript.Echo "CPUusagePercent_Base: " & objItem.CPUusagePercent_Base
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 "Maxrequestcputimems: " & objItem.Maxrequestcputimems
Wscript.Echo "MaxrequestmemorygrantKB: " & objItem.MaxrequestmemorygrantKB
Wscript.Echo "Name: " & objItem.Name
Wscript.Echo "QueryoptimizationsPersec: " & objItem.QueryoptimizationsPersec
Wscript.Echo "Queuedrequests: " & objItem.Queuedrequests
Wscript.Echo "ReducedmemorygrantsPersec: " & objItem.ReducedmemorygrantsPersec
Wscript.Echo "RequestscompletedPersec: " & objItem.RequestscompletedPersec
Wscript.Echo "SuboptimalplansPersec: " & objItem.SuboptimalplansPersec
Wscript.Echo "Timestamp_Object: " & objItem.Timestamp_Object
Wscript.Echo "Timestamp_PerfTime: " & objItem.Timestamp_PerfTime
Wscript.Echo "Timestamp_Sys100NS: " & objItem.Timestamp_Sys100NS
Next