Contact Info

Crumbtrail

ActiveXperts.com » Administration » Scripts » WMI » vbscript sample

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