| Win32_PerfFormattedData_MSSQLSERVER_SQLServerBrokerStatistics | |||
| Service Broker Statistics | |||
| NameSpace Path | |||
| \ROOT\CIMV2 | |||
| PROPERTY | SMS_REPORT | CIMTYPE | DESCRIPTION |
| BrokerTransactionRollbacks | UInt64 | The number of Service Broker related transactions that have rolled back. | |
| Caption | String | A short textual description (one-line string) for the statistic or metric. | |
| Description | String | A textual description of the statistic or metric. | |
| DialogTimerEventCount | UInt64 | The number of dialog endpoint related timer events in the Broker. | |
| EnqueuedLocalMessagesPersec | UInt64 | The number of messages from local endpoints that are successfully delivered as ready into queues per second. | |
| EnqueuedLocalMessagesTotal | UInt64 | Total number of message fragments from local endpoints that are successfully delivered as ready into queues. | |
| EnqueuedMessagesPersec | UInt64 | The number of messages from local endpoints and the transport that are successfully delivered as ready into queues per second. | |
| EnqueuedMessagesTotal | UInt64 | Total number of message fragments from local endpoints and the transport that are successfully delivered as ready into queues. | |
| EnqueuedTransportMsgFragsPersec | UInt64 | The number of message fragments from the transport that are successfully delivered into queues per second. Note the cooresponding message may not be complete yet or may be out of order, and therefore the message can be in the queue as disabled. | |
| EnqueuedTransportMsgFragTot | UInt64 | Total number of message fragments from the transport that are successfully delivered into queues. Note the cooresponding message may not be complete yet or may be out of order, and therefore the message can be in the queue as disabled. | |
| EnqueuedTransportMsgsPersec | UInt64 | The number of messages from the transport that are successfully delivered as ready into queues per second. | |
| EnqueuedTransportMsgsTotal | UInt64 | Total number of messages from the transport that are successfully delivered as ready into queues. | |
| ForwardedMessagesPersec | UInt64 | The number of forwarded messages successfully sent per second. | |
| ForwardedMessagesTotal | UInt64 | Total number of forwarded messages successfully sent. | |
| ForwardedMsgBytesPersec | UInt64 | The number of forwarded message bytes successfully sent per second. | |
| ForwardedMsgByteTotal | UInt64 | Total number of forwarded message bytes successfully sent. | |
| ForwardedMsgDiscardedTotal | UInt64 | Total number of forwarded messages discarded due to forwarded message memory limits, age limits, etc. | |
| ForwardedMsgsDiscardedPersec | UInt64 | The number of forwarded messages that were discarded per second due to forwarded message memory limits, age limits, etc. | |
| ForwardedPendingMsgBytes | UInt64 | The number of forwarded message bytes that have not been successfully sent yet. | |
| ForwardedPendingMsgCount | UInt64 | The number of forwarded messages that have not been successfully sent yet. | |
| Frequency_Object | UInt64 | NA | |
| Frequency_PerfTime | UInt64 | NA | |
| Frequency_Sys100NS | UInt64 | NA | |
| Name | String | The Name property defines the label by which the statistic or metric is known. When subclassed, the property can be overridden to be a Key property. | |
| SQLRECEIVEsPersec | UInt64 | The number of SQL RECEIVE commands processed by the Broker per second. | |
| SQLRECEIVETotal | UInt64 | Total number of SQL RECEIVE commands processed by the Broker. | |
| SQLSENDsPersec | UInt64 | The number of SQL SEND commands processed by the Broker per second. | |
| SQLSENDTotal | UInt64 | Total number of SQL SEND commands processed by the Broker. | |
| Timestamp_Object | UInt64 | NA | |
| Timestamp_PerfTime | UInt64 | NA | |
| Timestamp_Sys100NS | UInt64 | NA | |
| SAMPLE DATA INSTANCE | |||
| [Description("Service Broker Statistics"): ToInstance Amended, DisplayName("SQLServer:Broker Statistics"): ToInstance Amended, genericperfctr: ToInstance Amended, locale(1033): ToInstance Amended] instance of Win32_PerfFormattedData_MSSQLSERVER_SQLServerBrokerStatistics { [Description("The number of Service Broker related transactions that have rolled back."): ToInstance Amended, DisplayName("Broker Transaction Rollbacks"): ToInstance Amended] BrokerTransactionRollbacks = "0"; [Description("The number of dialog endpoint related timer events in the Broker."): ToInstance Amended, DisplayName("Dialog Timer Event Count"): ToInstance Amended] DialogTimerEventCount = "0"; [Description("The number of messages from local endpoints that are successfully delivered as ready into queues per second."): ToInstance Amended, DisplayName("Enqueued Local Messages/sec"): ToInstance Amended] EnqueuedLocalMessagesPersec = "0"; [Description("Total number of message fragments from local endpoints that are successfully delivered as ready into queues."): ToInstance Amended, DisplayName("Enqueued Local Messages Total"): ToInstance Amended] EnqueuedLocalMessagesTotal = "0"; [Description("The number of messages from local endpoints and the transport that are successfully delivered as ready into queues per second."): ToInstance Amended, DisplayName("Enqueued Messages/sec"): ToInstance Amended] EnqueuedMessagesPersec = "0"; [Description("Total number of message fragments from local endpoints and the transport that are successfully delivered as ready into queues."): ToInstance Amended, DisplayName("Enqueued Messages Total"): ToInstance Amended] EnqueuedMessagesTotal = "0"; [Description("The number of message fragments from the transport that are successfully delivered into queues per second. Note the cooresponding message may not be complete yet or may be out of order, and therefore the message can be in the queue as disabled."): ToInstance Amended, DisplayName("Enqueued Transport Msg Frags/sec"): ToInstance Amended] EnqueuedTransportMsgFragsPersec = "0"; [Description("Total number of message fragments from the transport that are successfully delivered into queues. Note the cooresponding message may not be complete yet or may be out of order, and therefore the message can be in the queue as disabled."): ToInstance Amended, DisplayName("Enqueued Transport Msg Frag Tot"): ToInstance Amended] EnqueuedTransportMsgFragTot = "0"; [Description("The number of messages from the transport that are successfully delivered as ready into queues per second."): ToInstance Amended, DisplayName("Enqueued Transport Msgs/sec"): ToInstance Amended] EnqueuedTransportMsgsPersec = "0"; [Description("Total number of messages from the transport that are successfully delivered as ready into queues."): ToInstance Amended, DisplayName("Enqueued Transport Msgs Total"): ToInstance Amended] EnqueuedTransportMsgsTotal = "0"; [Description("The number of forwarded messages successfully sent per second."): ToInstance Amended, DisplayName("Forwarded Messages/sec"): ToInstance Amended] ForwardedMessagesPersec = "0"; [Description("Total number of forwarded messages successfully sent."): ToInstance Amended, DisplayName("Forwarded Messages Total"): ToInstance Amended] ForwardedMessagesTotal = "0"; [Description("The number of forwarded message bytes successfully sent per second."): ToInstance Amended, DisplayName("Forwarded Msg Bytes/sec"): ToInstance Amended] ForwardedMsgBytesPersec = "0"; [Description("Total number of forwarded message bytes successfully sent."): ToInstance Amended, DisplayName("Forwarded Msg Byte Total"): ToInstance Amended] ForwardedMsgByteTotal = "0"; [Description("Total number of forwarded messages discarded due to forwarded message memory limits, age limits, etc."): ToInstance Amended, DisplayName("Forwarded Msg Discarded Total"): ToInstance Amended] ForwardedMsgDiscardedTotal = "0"; [Description("The number of forwarded messages that were discarded per second due to forwarded message memory limits, age limits, etc."): ToInstance Amended, DisplayName("Forwarded Msgs Discarded/sec"): ToInstance Amended] ForwardedMsgsDiscardedPersec = "0"; [Description("The number of forwarded message bytes that have not been successfully sent yet."): ToInstance Amended, DisplayName("Forwarded Pending Msg Bytes"): ToInstance Amended] ForwardedPendingMsgBytes = "0"; [Description("The number of forwarded messages that have not been successfully sent yet."): ToInstance Amended, DisplayName("Forwarded Pending Msg Count"): ToInstance Amended] ForwardedPendingMsgCount = "0"; [Description("The number of SQL RECEIVE commands processed by the Broker per second."): ToInstance Amended, DisplayName("SQL RECEIVEs/sec"): ToInstance Amended] SQLRECEIVEsPersec = "0"; [Description("Total number of SQL RECEIVE commands processed by the Broker."): ToInstance Amended, DisplayName("SQL RECEIVE Total"): ToInstance Amended] SQLRECEIVETotal = "0"; [Description("The number of SQL SEND commands processed by the Broker per second."): ToInstance Amended, DisplayName("SQL SENDs/sec"): ToInstance Amended] SQLSENDsPersec = "0"; [Description("Total number of SQL SEND commands processed by the Broker."): ToInstance Amended, DisplayName("SQL SEND Total"): ToInstance Amended] SQLSENDTotal = "0"; }; | |||