Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSMemoryManager vbscript sample code
The foundations for Manageability in Windows is 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. The Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSMemoryManager WMI class can be used in ActiveXperts Network Monitor to monitor your servers.
Sample Code
On Error Resume Next strComputer = "." Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2") Set colItems = objWMIService.ExecQuery("Select * from Win32_PerfRawData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSMemoryManager",,48) For Each objItem in colItems Wscript.Echo "Caption: " & objItem.Caption Wscript.Echo "ConnectionMemoryKB: " & objItem.ConnectionMemoryKB 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 "GrantedWorkspaceMemoryKB: " & objItem.GrantedWorkspaceMemoryKB Wscript.Echo "LockBlocks: " & objItem.LockBlocks Wscript.Echo "LockBlocksAllocated: " & objItem.LockBlocksAllocated Wscript.Echo "LockMemoryKB: " & objItem.LockMemoryKB Wscript.Echo "LockOwnerBlocks: " & objItem.LockOwnerBlocks Wscript.Echo "LockOwnerBlocksAllocated: " & objItem.LockOwnerBlocksAllocated Wscript.Echo "MaximumWorkspaceMemoryKB: " & objItem.MaximumWorkspaceMemoryKB Wscript.Echo "MemoryGrantsOutstanding: " & objItem.MemoryGrantsOutstanding Wscript.Echo "MemoryGrantsPending: " & objItem.MemoryGrantsPending Wscript.Echo "Name: " & objItem.Name Wscript.Echo "OptimizerMemoryKB: " & objItem.OptimizerMemoryKB Wscript.Echo "SQLCacheMemoryKB: " & objItem.SQLCacheMemoryKB Wscript.Echo "TargetServerMemoryKB: " & objItem.TargetServerMemoryKB Wscript.Echo "Timestamp_Object: " & objItem.Timestamp_Object Wscript.Echo "Timestamp_PerfTime: " & objItem.Timestamp_PerfTime Wscript.Echo "Timestamp_Sys100NS: " & objItem.Timestamp_Sys100NS Wscript.Echo "TotalServerMemoryKB: " & objItem.TotalServerMemoryKB Next