Win32_PerfRawData_ESENT_Database 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_ESENT_Database 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_ESENT_Database",,48) For Each objItem in colItems Wscript.Echo "Caption: " & objItem.Caption Wscript.Echo "DatabaseCachePercentHit: " & objItem.DatabaseCachePercentHit Wscript.Echo "DatabaseCachePercentHit_Base: " & objItem.DatabaseCachePercentHit_Base Wscript.Echo "DatabaseCacheSize: " & objItem.DatabaseCacheSize Wscript.Echo "DatabaseCacheSizeMB: " & objItem.DatabaseCacheSizeMB Wscript.Echo "DatabasePageEvictionsPersec: " & objItem.DatabasePageEvictionsPersec Wscript.Echo "DatabasePageFaultsPersec: " & objItem.DatabasePageFaultsPersec Wscript.Echo "DatabasePageFaultStallsPersec: " & objItem.DatabasePageFaultStallsPersec 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 "IODatabaseReadsAverageLatency: " & objItem.IODatabaseReadsAverageLatency Wscript.Echo "IODatabaseReadsAverageLatency_Base: " & objItem.IODatabaseReadsAverageLatency_Base Wscript.Echo "IODatabaseReadsPersec: " & objItem.IODatabaseReadsPersec Wscript.Echo "IODatabaseWritesAverageLatency: " & objItem.IODatabaseWritesAverageLatency Wscript.Echo "IODatabaseWritesAverageLatency_Base: " & objItem.IODatabaseWritesAverageLatency_Base Wscript.Echo "IODatabaseWritesPersec: " & objItem.IODatabaseWritesPersec Wscript.Echo "IOLogReadsPersec: " & objItem.IOLogReadsPersec Wscript.Echo "IOLogWritesAverageLatency: " & objItem.IOLogWritesAverageLatency Wscript.Echo "IOLogWritesAverageLatency_Base: " & objItem.IOLogWritesAverageLatency_Base Wscript.Echo "IOLogWritesPersec: " & objItem.IOLogWritesPersec Wscript.Echo "LogBytesWritePersec: " & objItem.LogBytesWritePersec Wscript.Echo "LogRecordStallsPersec: " & objItem.LogRecordStallsPersec Wscript.Echo "LogThreadsWaiting: " & objItem.LogThreadsWaiting Wscript.Echo "LogWritesPersec: " & objItem.LogWritesPersec Wscript.Echo "Name: " & objItem.Name Wscript.Echo "PagesConverted: " & objItem.PagesConverted Wscript.Echo "PagesConvertedPersec: " & objItem.PagesConvertedPersec Wscript.Echo "RecordsConverted: " & objItem.RecordsConverted Wscript.Echo "RecordsConvertedPersec: " & objItem.RecordsConvertedPersec Wscript.Echo "SessionsInUse: " & objItem.SessionsInUse Wscript.Echo "SessionsPercentUsed: " & objItem.SessionsPercentUsed Wscript.Echo "SessionsPercentUsed_Base: " & objItem.SessionsPercentUsed_Base Wscript.Echo "TableOpenCacheHitsPersec: " & objItem.TableOpenCacheHitsPersec Wscript.Echo "TableOpenCacheMissesPersec: " & objItem.TableOpenCacheMissesPersec Wscript.Echo "TableOpenCachePercentHit: " & objItem.TableOpenCachePercentHit Wscript.Echo "TableOpenCachePercentHit_Base: " & objItem.TableOpenCachePercentHit_Base Wscript.Echo "TableOpensPersec: " & objItem.TableOpensPersec Wscript.Echo "Timestamp_Object: " & objItem.Timestamp_Object Wscript.Echo "Timestamp_PerfTime: " & objItem.Timestamp_PerfTime Wscript.Echo "Timestamp_Sys100NS: " & objItem.Timestamp_Sys100NS Wscript.Echo "Versionbucketsallocated: " & objItem.Versionbucketsallocated Next