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

---

SQLServerBrokerDBMTransport

Example(s)

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

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

For Each objItem in colItems
	WScript.Echo "Caption:" & objItem.Caption
	WScript.Echo "CurrentBytesforRecvIO:" & objItem.CurrentBytesforRecvIO
	WScript.Echo "CurrentBytesforSendIO:" & objItem.CurrentBytesforSendIO
	WScript.Echo "CurrentMsgFragsforSendIO:" & objItem.CurrentMsgFragsforSendIO
	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 "MessageFragmentP10SendsPersec:" & objItem.MessageFragmentP10SendsPersec
	WScript.Echo "MessageFragmentP1SendsPersec:" & objItem.MessageFragmentP1SendsPersec
	WScript.Echo "MessageFragmentP2SendsPersec:" & objItem.MessageFragmentP2SendsPersec
	WScript.Echo "MessageFragmentP3SendsPersec:" & objItem.MessageFragmentP3SendsPersec
	WScript.Echo "MessageFragmentP4SendsPersec:" & objItem.MessageFragmentP4SendsPersec
	WScript.Echo "MessageFragmentP5SendsPersec:" & objItem.MessageFragmentP5SendsPersec
	WScript.Echo "MessageFragmentP6SendsPersec:" & objItem.MessageFragmentP6SendsPersec
	WScript.Echo "MessageFragmentP7SendsPersec:" & objItem.MessageFragmentP7SendsPersec
	WScript.Echo "MessageFragmentP8SendsPersec:" & objItem.MessageFragmentP8SendsPersec
	WScript.Echo "MessageFragmentP9SendsPersec:" & objItem.MessageFragmentP9SendsPersec
	WScript.Echo "MessageFragmentReceivesPersec:" & objItem.MessageFragmentReceivesPersec
	WScript.Echo "MessageFragmentSendsPersec:" & objItem.MessageFragmentSendsPersec
	WScript.Echo "MsgFragmentRecvSizeAvg:" & objItem.MsgFragmentRecvSizeAvg
	WScript.Echo "MsgFragmentRecvSizeAvg_Base:" & objItem.MsgFragmentRecvSizeAvg_Base
	WScript.Echo "MsgFragmentSendSizeAvg:" & objItem.MsgFragmentSendSizeAvg
	WScript.Echo "MsgFragmentSendSizeAvg_Base:" & objItem.MsgFragmentSendSizeAvg_Base
	WScript.Echo "Name:" & objItem.Name
	WScript.Echo "OpenConnectionCount:" & objItem.OpenConnectionCount
	WScript.Echo "PendingBytesforRecvIO:" & objItem.PendingBytesforRecvIO
	WScript.Echo "PendingBytesforSendIO:" & objItem.PendingBytesforSendIO
	WScript.Echo "PendingMsgFragsforRecvIO:" & objItem.PendingMsgFragsforRecvIO
	WScript.Echo "PendingMsgFragsforSendIO:" & objItem.PendingMsgFragsforSendIO
	WScript.Echo "ReceiveIObytesPersec:" & objItem.ReceiveIObytesPersec
	WScript.Echo "ReceiveIOLenAvg:" & objItem.ReceiveIOLenAvg
	WScript.Echo "ReceiveIOLenAvg_Base:" & objItem.ReceiveIOLenAvg_Base
	WScript.Echo "ReceiveIPerOsPersec:" & objItem.ReceiveIPerOsPersec
	WScript.Echo "RecvIOBufferCopiesbytesPersec:" & objItem.RecvIOBufferCopiesbytesPersec
	WScript.Echo "RecvIOBufferCopiesCount:" & objItem.RecvIOBufferCopiesCount
	WScript.Echo "SendIObytesPersec:" & objItem.SendIObytesPersec
	WScript.Echo "SendIOLenAvg:" & objItem.SendIOLenAvg
	WScript.Echo "SendIOLenAvg_Base:" & objItem.SendIOLenAvg_Base
	WScript.Echo "SendIPerOsPersec:" & objItem.SendIPerOsPersec
	WScript.Echo "Timestamp_Object:" & objItem.Timestamp_Object
	WScript.Echo "Timestamp_PerfTime:" & objItem.Timestamp_PerfTime
	WScript.Echo "Timestamp_Sys100NS:" & objItem.Timestamp_Sys100NS
	WScript.Echo ""
	WScript.Echo "########"
	WScript.Echo ""
Next