Find CPU Bottlenecks in Your Network
Performance scanning is critical when it comes to managing a network and it's users. When users start complaining about things being slow, it is easier than ever to locate the cause. Furthermore, performance monitoring can be used for migration projects as well. Determine how much resources your servers need to so you can set the correct requirements for a cloud or virtual migration.
The audit below will show the top 5 machines with the highest average CPU usage in the last week. This way you can find machines that might be bottlenecked and could use an upgrade. For additional use cases, you can easily modify the audit to include all machines in your network and/or over a longer period of time.
CPU Utilization Query
Select Top 5 tblAssets.AssetID, tblAssets.AssetName, Cast(Avg(tblPerformanceCountersScanMetric.Value) As int) As [Average CPU usage in %], Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon, Max(tblPerformanceCountersScan.ScanDateTime) As [Last scan] From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tblPerformanceCountersScan On tblAssets.AssetID = tblPerformanceCountersScan.AssetId Inner Join tblPerformanceCountersScanMetric On tblPerformanceCountersScan.Id = tblPerformanceCountersScanMetric.PerformanceCountersScanId Left Join tblPerformanceCountersScanMetricIdentifier On tblPerformanceCountersScanMetricIdentifier.Id = tblPerformanceCountersScanMetric.PerformanceCountersScanMetricIdentifierId Inner Join tsysPerformanceCounterMetric On tsysPerformanceCounterMetric.Id = tblPerformanceCountersScanMetric.Metric Left Join tsysOS On tsysOS.OScode = tblAssets.OScode Where tsysPerformanceCounterMetric.[Group] = 'CPU' And tblAssetCustom.State = 1 Group By tblAssets.AssetID, tblAssets.AssetName, Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) Having Max(tblPerformanceCountersScan.ScanDateTime) > GetDate() - 7 Order By [Average CPU usage in %] Desc