

Orchtech is a software development company working in multiple countries worldwide and our experience spans over multiple services/products such as Offshoring/Outsourcing software development, Mobile applications development services, Web development and HR mobile applications for internal employees management.
Sometimes you need to use the SQL queries to get the performance data instead of using WUG Reports. You can use the following queries to get the required data for Memory utilization.
SELECT Device.nDeviceID, Device.sDisplayName, sType, nSize, nUsed_Avg, nUsed_Min, nUsed_Max, dPollTime
FROM dbo.StatisticalMemory
LEFT OUTER JOIN dbo.StatisticalMemoryIdentification ON
StatisticalMemoryIdentification.nStatisticalMemoryIdentificationID = StatisticalMemory.nStatisticalMemoryIdentificationID
LEFT OUTER JOIN dbo.PivotStatisticalMonitorTypeToDevice ON
PivotStatisticalMonitorTypeToDevice.nPivotStatisticalMonitorTypeToDeviceID = StatisticalMemoryIdentification.nPivotStatisticalMonitorTypeToDeviceID
LEFT OUTER JOIN Device ON
Device.nDeviceID = PivotStatisticalMonitorTypeToDevice.nDeviceID
ORDER BY dPollTime DESC
Memory Cache data, the latest Memory utilization data (i.e exactly one record per monitored Memory)
SELECT Device.nDeviceID, Device.sDisplayName, sType, nSize, nUsed_Avg, nUsed_Min, nUsed_Max, dPollTime
FROM dbo.StatisticalMemoryCache
LEFT OUTER JOIN dbo.StatisticalMemoryIdentification ON
StatisticalMemoryIdentification.nStatisticalMemoryIdentificationID = StatisticalMemoryCache.nStatisticalMemoryIdentificationID
LEFT OUTER JOIN dbo.PivotStatisticalMonitorTypeToDevice ON
PivotStatisticalMonitorTypeToDevice.nPivotStatisticalMonitorTypeToDeviceID = StatisticalMemoryIdentification.nPivotStatisticalMonitorTypeToDeviceID
LEFT OUTER JOIN Device ON
Device.nDeviceID = PivotStatisticalMonitorTypeToDevice.nDeviceID
ORDER BY dPollTime DESC
This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.