![]() ![]() (SELECT available_physical_memory_kb/1024 FROM sys.dm_os_sys_memory) AS 'Available Memory (MB)', (SELECT total_physical_memory_kb/1024 FROM sys.dm_os_sys_memory) AS 'Physical Memory (MB)', (SELECT physical_memory_in_use_kb/1024 FROM sys.dm_os_process_memory) AS 'SQL Server Memory Usage (MB)', (SELECT value_in_use FROM sys.configurations WHERE name like '%max server memory%') AS 'Max Server Memory', SERVERPROPERTY('SERVERNAME') AS 'Instance', WHERE ring_buffer_type = N'RING_BUFFER_SCHEDULER_MONITOR' Record.value('(./Record/SchedulerMonitorEvent/SystemHealth/ProcessUtilization)', 'int') AS , Record.value('(./Record/SchedulerMonitorEvent/SystemHealth/SystemIdle)', 'int') AS , ![]() SELECT TOP(30) SQLProcessUtilization AS 'CPU_Usage', ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) AS 'row_number'
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |