This article is half-done without your Comment! *** Please share your thoughts via Comment ***
SQL Server 2012 introduced a sp_server_diagnostics system stored procedure for a quick assessment and health check of SQL Server.
Execute below system stored procedure and check the result of your server:
1 |
EXEC sp_server_diagnostics |
Basic about the component:
System: Returns data on items such as latch warnings, spinlocks, page faults, CPU utilisation
Resource: Focuses on related memory objects like physical and virtual memory, free page information
Query_Processing: Cumulative wait statistic information including the top preemptive and non-preemptive waits ordered by both count and wait for duration
IO_Subsystem: IO information like IO related timeouts and pending IO requests
Events: Comprehensive event information retrieved during the execution duration