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


Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBufferManager

Description

Example(s)

On Error Resume Next
strComputer = "."
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")
Set colItems = objWMIService.ExecQuery("Select * from Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSBufferManager",,48)
For Each objItem in colItems
    Wscript.Echo "AWElookupmapsPersec: " & objItem.AWElookupmapsPersec
    Wscript.Echo "AWEstolenmapsPersec: " & objItem.AWEstolenmapsPersec
    Wscript.Echo "AWEunmapcallsPersec: " & objItem.AWEunmapcallsPersec
    Wscript.Echo "AWEunmappagesPersec: " & objItem.AWEunmappagesPersec
    Wscript.Echo "AWEwritemapsPersec: " & objItem.AWEwritemapsPersec
    Wscript.Echo "Buffercachehitratio: " & objItem.Buffercachehitratio
    Wscript.Echo "Caption: " & objItem.Caption
    Wscript.Echo "CheckpointpagesPersec: " & objItem.CheckpointpagesPersec
    Wscript.Echo "Databasepages: " & objItem.Databasepages
    Wscript.Echo "Description: " & objItem.Description
    Wscript.Echo "FreeliststallsPersec: " & objItem.FreeliststallsPersec
    Wscript.Echo "Freepages: " & objItem.Freepages
    Wscript.Echo "Frequency_Object: " & objItem.Frequency_Object
    Wscript.Echo "Frequency_PerfTime: " & objItem.Frequency_PerfTime
    Wscript.Echo "Frequency_Sys100NS: " & objItem.Frequency_Sys100NS
    Wscript.Echo "LazywritesPersec: " & objItem.LazywritesPersec
    Wscript.Echo "Name: " & objItem.Name
    Wscript.Echo "Pagelifeexpectancy: " & objItem.Pagelifeexpectancy
    Wscript.Echo "PagelookupsPersec: " & objItem.PagelookupsPersec
    Wscript.Echo "PagereadsPersec: " & objItem.PagereadsPersec
    Wscript.Echo "PagewritesPersec: " & objItem.PagewritesPersec
    Wscript.Echo "ReadaheadpagesPersec: " & objItem.ReadaheadpagesPersec
    Wscript.Echo "Reservedpages: " & objItem.Reservedpages
    Wscript.Echo "Stolenpages: " & objItem.Stolenpages
    Wscript.Echo "Targetpages: " & objItem.Targetpages
    Wscript.Echo "Timestamp_Object: " & objItem.Timestamp_Object
    Wscript.Echo "Timestamp_PerfTime: " & objItem.Timestamp_PerfTime
    Wscript.Echo "Timestamp_Sys100NS: " & objItem.Timestamp_Sys100NS
    Wscript.Echo "Totalpages: " & objItem.Totalpages
Next