Devices with Memory Utilization Exceeds 85%

Devices with Memory Utilization Exceeds 85%

This is a sample of dynamic group for the devices with memory utilization exceeds 85% for example.

SELECT Device.nDeviceID
FROM dbo.StatisticalMemoryCache AS SMC
LEFT OUTER JOIN dbo.StatisticalMemoryIdentification AS SMI ON 
SMI.nStatisticalMemoryIdentificationID = SMC.nStatisticalMemoryIdentificationID
LEFT OUTER JOIN dbo.PivotStatisticalMonitorTypeToDevice AS PSMTTD ON 
PSMTTD.nPivotStatisticalMonitorTypeToDeviceID = SMI.nPivotStatisticalMonitorTypeToDeviceID
LEFT OUTER JOIN Device ON Device.nDeviceID = PSMTTD.nDeviceID
WHERE (SMC.nUsed_Max/SMC.nSize > 0.85) AND sType = 'RAM'