RAM Utilization Audit

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,
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 =
Inner Join tblPerformanceCountersScanMetric On tblPerformanceCountersScan.Id =
Left Join tblPerformanceCountersScanMetricIdentifier On
tblPerformanceCountersScanMetricIdentifier.Id =
Inner Join tsysPerformanceCounterMetric On tsysPerformanceCounterMetric.Id =
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tsysPerformanceCounterMetric.Name = 'Used physical memory' And
tblAssetCustom.State = 1
Group By tblAssets.AssetID,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10),
Having Max(tblPerformanceCountersScan.ScanDateTime) > GetDate() - 7
Order By [Avarage RAM usage in %] Desc


Audit and Take Action in 3 Easy Steps


1. Download & Install Lansweeper


3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting