Query to fetch PC utilization
Trying to integrate .net application with SCOM . Need queries through which I can display information like CPU Utilization , Memory Usage , Number of Processes running on the client machine . SCOM has its own database but unable to create a query that can fetch the said information.
Rajeev PunhaniPosted Mar 10, 2016, 3:45 AM
Hi Hemali,
SELECT
(physical_memory_in_use_kb/1024) AS Memory_usedby_Sqlserver_MB,
(locked_page_allocations_kb/1024) AS Locked_pages_used_Sqlserver_MB,
(total_virtual_address_space_kb/1024) AS Total_VAS_in_MB,
process_physical_memory_low,
process_virtual_memory_low
FROM sys.dm_os_process_memory;
If the above solution is helpful then,accept the answer.