This is the performance counter for SQL Send Adapter Messages Sent Per Second.
Number of messages sent by the SQL send adapter per second. The counter applies only to messages that have been written to the destination SQL table.
Target | Microsoft.BizTalk.Server.2010.BizTalkRuntimeRole |
Category | PerformanceCollection |
Enabled | True |
Instance Name | BizTalk:SQL Send Adapter |
Counter Name | Messages sent/Sec |
Frequency | 300 |
Alert Generate | False |
Remotable | True |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
PerfDataSource | DataSource | System.Performance.OptimizedDataProvider | Default |
CollectPerfData | WriteAction | Microsoft.SystemCenter.CollectPerformanceData | Default |
CollectPerfDataWarehouse | WriteAction | Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData | Default |
<Rule ID="Microsoft.BizTalk.Server.2010.Perf.SQLSendAdapterMessagesSentPerSec" Enabled="true" Target="BTSLib!Microsoft.BizTalk.Server.2010.BizTalkRuntimeRole" ConfirmDelivery="true" Remotable="true" Priority="Normal" DiscardLevel="100">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="PerfDataSource" TypeID="Perf!System.Performance.OptimizedDataProvider">
<ComputerName>$Target/Property[Type="BTSLib!Microsoft.BizTalk.Server.2010.ServerRole"]/ComputerName$</ComputerName>
<CounterName>Messages sent/Sec</CounterName>
<ObjectName>BizTalk:SQL Send Adapter</ObjectName>
<InstanceName/>
<AllInstances>true</AllInstances>
<Frequency>300</Frequency>
<Tolerance>3</Tolerance>
<MaximumSampleSeparation>20</MaximumSampleSeparation>
</DataSource>
</DataSources>
<WriteActions>
<WriteAction ID="CollectPerfData" TypeID="SC!Microsoft.SystemCenter.CollectPerformanceData"/>
<WriteAction ID="CollectPerfDataWarehouse" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>
</WriteActions>
</Rule>