Win32-PerfFormattedData-MSSQLSQLEXPRESS-MSSQLSQLEXPRESSTransactions - WMI VBScript sample
The foundations for Manageability in Windows 2019/2016/2012/2008 and Windows 10/7/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 Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSTransactions WMI class can be used in ActiveXperts Network Monitor to monitor your servers.
Win32-PerfFormattedData-MSSQLSQLEXPRESS-MSSQLSQLEXPRESSTransactions
Example(s)
On Error Resume Next strComputer = "." Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2") Set colItems = objWMIService.ExecQuery("Select * from Win32_PerfFormattedData_MSSQLSQLEXPRESS_MSSQLSQLEXPRESSTransactions",,48) For Each objItem in colItems Wscript.Echo "Caption: " & objItem.Caption Wscript.Echo "Description: " & objItem.Description Wscript.Echo "FreeSpaceintempdbKB: " & objItem.FreeSpaceintempdbKB Wscript.Echo "Frequency_Object: " & objItem.Frequency_Object Wscript.Echo "Frequency_PerfTime: " & objItem.Frequency_PerfTime Wscript.Echo "Frequency_Sys100NS: " & objItem.Frequency_Sys100NS Wscript.Echo "LongestTransactionRunningTime: " & objItem.LongestTransactionRunningTime Wscript.Echo "Name: " & objItem.Name Wscript.Echo "NonSnapshotVersionTransactions: " & objItem.NonSnapshotVersionTransactions Wscript.Echo "SnapshotTransactions: " & objItem.SnapshotTransactions Wscript.Echo "Timestamp_Object: " & objItem.Timestamp_Object Wscript.Echo "Timestamp_PerfTime: " & objItem.Timestamp_PerfTime Wscript.Echo "Timestamp_Sys100NS: " & objItem.Timestamp_Sys100NS Wscript.Echo "Transactions: " & objItem.Transactions Wscript.Echo "Updateconflictratio: " & objItem.Updateconflictratio Wscript.Echo "UpdateSnapshotTransactions: " & objItem.UpdateSnapshotTransactions Wscript.Echo "VersionCleanuprateKBPers: " & objItem.VersionCleanuprateKBPers Wscript.Echo "VersionGenerationrateKBPers: " & objItem.VersionGenerationrateKBPers Wscript.Echo "VersionStoreSizeKB: " & objItem.VersionStoreSizeKB Wscript.Echo "VersionStoreunitcount: " & objItem.VersionStoreunitcount Wscript.Echo "VersionStoreunitcreation: " & objItem.VersionStoreunitcreation Wscript.Echo "VersionStoreunittruncation: " & objItem.VersionStoreunittruncation Next