This counter reports the total number of activation stored procedures invoked by all queue monitors in the instance per second. This counter is polled every fifteen minutes.
This counter reports the total number of activation stored procedures invoked by all queue monitors in the instance per second. This counter is polled every fifteen minutes.
Name | Description | Default Value |
Enabled | Enables or disables the workflow. | Yes |
Frequency (seconds) | The recurring interval of time in seconds in which to run the workflow. | 900 |
Target | Microsoft.SQLServer.2016.DBEngine |
Category | PerformanceCollection |
Enabled | True |
Instance Name | $Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/PerformanceCounterObject$:Broker Activation |
Counter Name | Stored Procedures Invoked/sec |
Frequency | 900 |
Alert Generate | False |
Remotable | True |
Comment | Mom2016ID='{EE989915-954C-4D00-9608-0219DDC1D7F4}';MOM2016GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74} |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
_75FB0143_93F3_4B09_9387_829C6FEA3235_ | 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.2016.SQLServer_Broker_Activation_Stored_Procedures_Invoked_sec__Total_15.0_minutes_5_Rule" Target="SQL2016Core!Microsoft.SQLServer.2016.DBEngine" Enabled="true" ConfirmDelivery="false" Comment="Mom2016ID='{EE989915-954C-4D00-9608-0219DDC1D7F4}';MOM2016GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="_75FB0143_93F3_4B09_9387_829C6FEA3235_" Comment="{75FB0143-93F3-4B09-9387-829C6FEA3235}" TypeID="SystemPerf!System.Performance.DataProvider">
<ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<CounterName>Stored Procedures Invoked/sec</CounterName>
<ObjectName>$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/PerformanceCounterObject$:Broker Activation</ObjectName>
<InstanceName>_Total</InstanceName>
<Frequency>900</Frequency>
</DataSource>
</DataSources>
<ConditionDetection ID="PerfMapper" TypeID="SystemPerf!System.Performance.DataGenericMapper">
<ObjectName>SQL DB Engine:Broker Activation</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>