Find RAM 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 project.
The audit below will show the top 5 machines with the highest average memory usage in the last week. Identify machines that need additional memory with ease. You can also adjust the audit to include all machines in your network and/or over a longer period of time for other use cases.
RAM Utilization Query
Select Top 5 tblAssets.AssetID, tblAssets.AssetName, Cast(Avg(tblPerformanceCountersScanMetric.Value) As int) As [Avarage RAM 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.Name = 'Used physical memory' And tblAssetCustom.State = 1 Group By tblAssets.AssetID, tblAssets.AssetName, Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10), tsysPerformanceCounterMetric.Name Having Max(tblPerformanceCountersScan.ScanDateTime) > GetDate() - 7 Order By [Avarage RAM usage in %] Desc