The number of SQL Server messages received per second. This counter is polled every fifteen minutes.
The number of SQL Server messages received per second. 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 | SQL RECEIVEs/sec |
Frequency | 900 |
Alert Generate | False |
Remotable | True |
Comment | Mom2014ID='{4C62F8A1-8AF2-42C2-A2BF-D237E1CF7D5C}';MOM2014GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74} |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
_86D1A379_5B83_4737_BBC9_4A533443076F_ | 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_SQL_RECEIVEs_sec_15.0_minutes_5_Rule" Target="SQL2014Core!Microsoft.SQLServer.2014.DBEngine" Enabled="true" ConfirmDelivery="false" Comment="Mom2014ID='{4C62F8A1-8AF2-42C2-A2BF-D237E1CF7D5C}';MOM2014GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="_86D1A379_5B83_4737_BBC9_4A533443076F_" Comment="{86D1A379-5B83-4737-BBC9-4A533443076F}" TypeID="SystemPerf!System.Performance.DataProvider">
<ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<CounterName>SQL RECEIVEs/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>