![]() To help things out, here is a sample table that you can use to populate the list Usage information from the instances you specify. Here is the complete code of the PowerShell script that gathers CPU and Memory PowerShell Script to Gather CPU and Memory Information (SELECT AVG(CPU_Usage) FROM SQLProcessCPU WHERE row_number BETWEEN 1 AND 5) AS 'SQLProcessUtilization5', (SELECT AVG(CPU_Usage) FROM SQLProcessCPU WHERE row_number BETWEEN 1 AND 10) AS 'SQLProcessUtilization10', (SELECT AVG(CPU_Usage) FROM SQLProcessCPU WHERE row_number BETWEEN 1 AND 15) AS 'SQLProcessUtilization15', (SELECT AVG(CPU_Usage) FROM SQLProcessCPU WHERE row_number BETWEEN 1 AND 30) AS 'SQLProcessUtilization30', (SELECT FROM sys.dm_os_performance_counters WHERE LIKE '%Manager%' AND = 'Page life expectancy') AS 'Page Life Expectancy', (SELECT system_memory_state_desc FROM sys.dm_os_sys_memory) AS 'System Memory State', (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 |