SQL 2014 DB Engine CPU Utilization (\%) performance collection rule
MSSQL 2014: DB Engine CPU Utilization (%)
System CPU usage by instance of sqlservr.exe process.
Percentage of CPU utilization depends on the processors affinity mask is set for the SQL Server instance. If affinity mask is set automatically for all processors, accumulated value will be counted taking into account the amount of all processors.
Name | Description | Default Value |
Enabled |
| Yes |
Generates Alerts |
| No |
Interval (seconds) | The recurring interval of time in seconds in which to run the workflow. | 900 |
Synchronization Time | The synchronization time specified by using a 24-hour format. May be omitted. |
|
Timeout (seconds) | Specifies the time the workflow is allowed to run before being closed and marked as failed. | 300 |
Target | Microsoft.SQLServer.2014.DBEngine |
Category | PerformanceCollection |
Enabled | True |
Alert Generate | False |
Remotable | True |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | Microsoft.SQLServer.2014.DBEngine.CPUUsagePercent.DataSourceMapped | Microsoft.SQLServer.2014.SQLProbeAccount |
WriteToDB | WriteAction | Microsoft.SystemCenter.CollectPerformanceData | Default |
WriteToDW | WriteAction | Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData | Default |
<Rule ID="Microsoft.SQLServer.2014.DBEngine.CPUUsagePercent.Collection" Enabled="true" Target="SQL2014Core!Microsoft.SQLServer.2014.DBEngine" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="DS" TypeID="Microsoft.SQLServer.2014.DBEngine.CPUUsagePercent.DataSourceMapped" RunAs="SQL2014Core!Microsoft.SQLServer.2014.SQLProbeAccount">
<ServiceName>$Target/Property[Type="SQL2014Core!Microsoft.SQLServer.2014.DBEngine"]/ServiceName$</ServiceName>
<IntervalSeconds>900</IntervalSeconds>
<TimeoutSeconds>300</TimeoutSeconds>
<ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<SyncTime/>
</DataSource>
</DataSources>
<WriteActions>
<WriteAction ID="WriteToDB" TypeID="SC!Microsoft.SystemCenter.CollectPerformanceData"/>
<WriteAction ID="WriteToDW" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>
</WriteActions>
</Rule>