Règle de collecte de performances du nombre de transactions de base de données SQL 2014 par seconde
Nombre de transactions par seconde pour la base de données SQL 2014
Nombre de transactions démarrées pour la base de données par seconde.
Nom | Description | Valeur par défaut |
Activé |
| Oui |
Fréquence | L'intervalle de temps récurrent en secondes pendant lequel le workflow est exécuté. | 900 |
Génère des alertes |
| Non |
Target | Microsoft.SQLServer.2014.Database |
Category | PerformanceCollection |
Enabled | True |
Instance Name | $Target/Host/Property[Type="SQL2014Core!Microsoft.SQLServer.2014.DBEngine"]/PerformanceCounterObject$:Databases |
Counter Name | Transactions/sec |
Frequency | 900 |
Alert Generate | False |
Remotable | True |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | System.Performance.DataProvider | Microsoft.SQLServer.2014.SQLProbeAccount |
Mapper | ConditionDetection | System.Performance.DataGenericMapper | Default |
WriteToDB | WriteAction | Microsoft.SystemCenter.CollectPerformanceData | Default |
WriteToDW | WriteAction | Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData | Default |
<Rule ID="Microsoft.SQLServer.2014.Database.TransactionsPerSecDB.Collection" Enabled="true" Target="SQL2014Core!Microsoft.SQLServer.2014.Database" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="DS" TypeID="SystemPerf!System.Performance.DataProvider" RunAs="SQL2014Core!Microsoft.SQLServer.2014.SQLProbeAccount">
<ComputerName>$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<CounterName>Transactions/sec</CounterName>
<ObjectName>$Target/Host/Property[Type="SQL2014Core!Microsoft.SQLServer.2014.DBEngine"]/PerformanceCounterObject$:Databases</ObjectName>
<InstanceName>$Target/Property[Type="SQL2014Core!Microsoft.SQLServer.2014.Database"]/DatabaseName$</InstanceName>
<AllInstances>false</AllInstances>
<Frequency>900</Frequency>
</DataSource>
</DataSources>
<ConditionDetection ID="Mapper" TypeID="SystemPerf!System.Performance.DataGenericMapper">
<ObjectName>SQL Database</ObjectName>
<CounterName>DB Transactions/sec</CounterName>
<InstanceName/>
<Value>$Data/Value$</Value>
</ConditionDetection>
<WriteActions>
<WriteAction ID="WriteToDB" TypeID="SC!Microsoft.SystemCenter.CollectPerformanceData"/>
<WriteAction ID="WriteToDW" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>
</WriteActions>
</Rule>