The number of messages per second that have been placed onto the queues in the instance. This counter is polled every fifteen minutes.
The number of messages per second that have been placed onto the queues in the instance. This counter is polled every fifteen minutes.
Name | Description | Default Value |
Enabled |
| Yes |
Frequency | The recurring interval of time in seconds in which to run the workflow. | 900 |
Generates Alerts |
| No |
Target | Microsoft.SQLServer.2014.DBEngine |
Category | PerformanceCollection |
Enabled | True |
Instance Name | $Target/Property[Type="SQL2014Core!Microsoft.SQLServer.2014.DBEngine"]/PerformanceCounterObject$:Broker Statistics |
Counter Name | Enqueued Messages/sec |
Frequency | 900 |
Alert Generate | False |
Remotable | True |
Comment | Mom2014ID='{89E1808E-5F4B-4121-B927-96424E18831B}';MOM2014GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74} |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
_375FE5BF_0F72_4925_A09D_01DDFE8F142E_ | DataSource | System.Performance.DataProvider | Default |
PerfMapper | ConditionDetection | System.Performance.DataGenericMapper | Default |
CollectPerfData | WriteAction | Microsoft.SystemCenter.CollectPerformanceData | Default |
CollectPerfDataWarehouse | WriteAction | Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData | Default |
<Rule ID="Microsoft.SQLServer.2014.SQLServer_Broker_Statistics_Enqueued_Messages_sec_15.0_minutes_5_Rule" Target="SQL2014Core!Microsoft.SQLServer.2014.DBEngine" Enabled="true" ConfirmDelivery="false" Comment="Mom2014ID='{89E1808E-5F4B-4121-B927-96424E18831B}';MOM2014GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="_375FE5BF_0F72_4925_A09D_01DDFE8F142E_" Comment="{375FE5BF-0F72-4925-A09D-01DDFE8F142E}" TypeID="SystemPerf!System.Performance.DataProvider">
<ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<CounterName>Enqueued Messages/sec</CounterName>
<ObjectName>$Target/Property[Type="SQL2014Core!Microsoft.SQLServer.2014.DBEngine"]/PerformanceCounterObject$:Broker Statistics</ObjectName>
<Frequency>900</Frequency>
</DataSource>
</DataSources>
<ConditionDetection ID="PerfMapper" TypeID="SystemPerf!System.Performance.DataGenericMapper">
<ObjectName>SQL DB Engine:Broker Statistics</ObjectName>
<CounterName>$Data/CounterName$</CounterName>
<InstanceName>$Data/InstanceName$</InstanceName>
<Value>$Data/Value$</Value>
</ConditionDetection>
<WriteActions>
<WriteAction ID="CollectPerfData" TypeID="SC!Microsoft.SystemCenter.CollectPerformanceData"/>
<WriteAction ID="CollectPerfDataWarehouse" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>
</WriteActions>
</Rule>