Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSResourcePoolStats - 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_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSResourcePoolStats WMI class can be used in ActiveXperts Network Monitor to monitor your servers.


Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSResourcePoolStats

Description

Example(s)

On Error Resume Next
strComputer = "."
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")
Set colItems = objWMIService.ExecQuery("Select * from Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSResourcePoolStats",,48)
For Each objItem in colItems
    Wscript.Echo "ActivememorygrantamountKB: " & objItem.ActivememorygrantamountKB
    Wscript.Echo "Activememorygrantscount: " & objItem.Activememorygrantscount
    Wscript.Echo "CachememorytargetKB: " & objItem.CachememorytargetKB
    Wscript.Echo "Caption: " & objItem.Caption
    Wscript.Echo "CompilememorytargetKB: " & objItem.CompilememorytargetKB
    Wscript.Echo "CPUcontroleffectPercent: " & objItem.CPUcontroleffectPercent
    Wscript.Echo "CPUusagePercent: " & objItem.CPUusagePercent
    Wscript.Echo "CPUusagetargetPercent: " & objItem.CPUusagetargetPercent
    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 "MaxmemoryKB: " & objItem.MaxmemoryKB
    Wscript.Echo "MemorygrantsPersec: " & objItem.MemorygrantsPersec
    Wscript.Echo "MemorygranttimeoutsPersec: " & objItem.MemorygranttimeoutsPersec
    Wscript.Echo "Name: " & objItem.Name
    Wscript.Echo "Pendingmemorygrantscount: " & objItem.Pendingmemorygrantscount
    Wscript.Echo "QueryexecmemorytargetKB: " & objItem.QueryexecmemorytargetKB
    Wscript.Echo "TargetmemoryKB: " & objItem.TargetmemoryKB
    Wscript.Echo "Timestamp_Object: " & objItem.Timestamp_Object
    Wscript.Echo "Timestamp_PerfTime: " & objItem.Timestamp_PerfTime
    Wscript.Echo "Timestamp_Sys100NS: " & objItem.Timestamp_Sys100NS
    Wscript.Echo "UsedmemoryKB: " & objItem.UsedmemoryKB
Next