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

---

LCUSrv00DBStore

Example(s)

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

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

For Each objItem in colItems
	WScript.Echo "Caption:" & objItem.Caption
	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 "Name:" & objItem.Name
	WScript.Echo "Timestamp_Object:" & objItem.Timestamp_Object
	WScript.Echo "Timestamp_PerfTime:" & objItem.Timestamp_PerfTime
	WScript.Echo "Timestamp_Sys100NS:" & objItem.Timestamp_Sys100NS
	WScript.Echo "USrv000QueueDepth:" & objItem.USrv000QueueDepth
	WScript.Echo "USrv000QueueDepth_Base:" & objItem.USrv000QueueDepth_Base
	WScript.Echo "USrv002QueueLatencymsec:" & objItem.USrv002QueueLatencymsec
	WScript.Echo "USrv002QueueLatencymsec_Base:" & objItem.USrv002QueueLatencymsec_Base
	WScript.Echo "USrv004SprocLatencymsec:" & objItem.USrv004SprocLatencymsec
	WScript.Echo "USrv004SprocLatencymsec_Base:" & objItem.USrv004SprocLatencymsec_Base
	WScript.Echo "USrv006PercentDatabaseTime:" & objItem.USrv006PercentDatabaseTime
	WScript.Echo "USrv006PercentDatabaseTime_Base:" & objItem.USrv006PercentDatabaseTime_Base
	WScript.Echo "USrv008ThreadsWaitingforNewDatabaseRequests:" & objItem.USrv008ThreadsWaitingforNewDatabaseRequests
	WScript.Echo "USrv009ThreadsExecutingDatabaseOperations:" & objItem.USrv009ThreadsExecutingDatabaseOperations
	WScript.Echo "USrv010ThreadsCallingBackwithDatabaseResults:" & objItem.USrv010ThreadsCallingBackwithDatabaseResults
	WScript.Echo "USrv011BlockedClientThreads:" & objItem.USrv011BlockedClientThreads
	WScript.Echo "USrv011BlockedClientThreads_Base:" & objItem.USrv011BlockedClientThreads_Base
	WScript.Echo "USrv013TotalDeadlocks:" & objItem.USrv013TotalDeadlocks
	WScript.Echo "USrv014TotalDroppedRequests:" & objItem.USrv014TotalDroppedRequests
	WScript.Echo "USrv015TotalDeadlockFailures:" & objItem.USrv015TotalDeadlockFailures
	WScript.Echo "USrv016TotalTransactionCountMismatchFailures:" & objItem.USrv016TotalTransactionCountMismatchFailures
	WScript.Echo "USrv017TotalODBCTimeoutFailures:" & objItem.USrv017TotalODBCTimeoutFailures
	WScript.Echo "USrv018TotalsevereSQLerrors:" & objItem.USrv018TotalsevereSQLerrors
	WScript.Echo "USrv019TotalfatalSQLerrors:" & objItem.USrv019TotalfatalSQLerrors
	WScript.Echo "USrv020ThrottledrequestsPersec:" & objItem.USrv020ThrottledrequestsPersec
	WScript.Echo "USrv021Totalthrottledrequests:" & objItem.USrv021Totalthrottledrequests
	WScript.Echo ""
	WScript.Echo "########"
	WScript.Echo ""
Next