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

---

SQLServerBufferManager

Example(s)

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

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

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
	WScript.Echo ""
	WScript.Echo "########"
	WScript.Echo ""
Next