Ce compteur affiche le nombre de connexions SQL Server Broker ouvertes. Ce compteur est interrogé toutes les quinze minutes.
Ce compteur affiche le nombre de connexions SQL Server Broker ouvertes. Ce compteur est interrogé toutes les quinze minutes.
Nom | Description | Valeur par défaut |
Activé | Active ou désactive le flux de travail. | Oui |
Fréquence (en secondes) | L'intervalle de temps récurrent en secondes pendant lequel le workflow est exécuté. | 900 |
Target | Microsoft.SQLServer.2014.DBEngine |
Category | PerformanceCollection |
Enabled | True |
Instance Name | $Target/Property[Type="SQL2014Core!Microsoft.SQLServer.2014.DBEngine"]/PerformanceCounterObject$:Broker/DBM Transport |
Counter Name | Open Connection Count |
Frequency | 900 |
Alert Generate | False |
Remotable | True |
Comment | Mom2014ID='{6F6453AC-323E-46F8-ACCB-DEB6043A02CF}';MOM2014GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74} |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
_6993B834_C234_490D_B699_C3EC76D4EA5C_ | 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_Transport_Open_Connection_Count_15.0_minutes_5_Rule" Target="SQL2014Core!Microsoft.SQLServer.2014.DBEngine" Enabled="true" ConfirmDelivery="false" Comment="Mom2014ID='{6F6453AC-323E-46F8-ACCB-DEB6043A02CF}';MOM2014GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="_6993B834_C234_490D_B699_C3EC76D4EA5C_" Comment="{6993B834-C234-490D-B699-C3EC76D4EA5C}" TypeID="SystemPerf!System.Performance.DataProvider">
<ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<CounterName>Open Connection Count</CounterName>
<ObjectName>$Target/Property[Type="SQL2014Core!Microsoft.SQLServer.2014.DBEngine"]/PerformanceCounterObject$:Broker/DBM Transport</ObjectName>
<Frequency>900</Frequency>
</DataSource>
</DataSources>
<ConditionDetection ID="PerfMapper" TypeID="SystemPerf!System.Performance.DataGenericMapper">
<ObjectName>SQL DB Engine:Broker/DBM Transport</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>