SQL Server performance troubleshooting and analysis methodology.
Lincoln Burrows ~
Modified: February 29th, 2016 ~ ~ 1 Minute Reading
- This topic has 1 reply, 2 voices, and was last updated 9 years, 1 month ago by .
Viewing 1 post (of 1 total)
-
Posts
-
Defining a troubleshooting methodology is hard, because the actual methodology that I apply depends entirely on the specific problem that I am trying to troubleshoot for a specific environment.
Fairly early on in any analysis, I’ll take a look at the wait statistics, in the
sys.dm_os_wait_stats Dynamic Management View (DMV), to identify any major resource waits in
the system, at the operating system level.
Viewing 1 post (of 1 total)
- You must be logged in to reply to this topic.