August 1, 2014 at 8:44 am
Good morning,
Every once in a while, we get complaints from the users that their applications are running slow. I searched around in SSC and around the web for some tips as well as forum questions to find some in depth discussion on how to use the tools to diagnose and resolve the issues.
Currently we use a combination of the tools (Activity Monitor and sp_who) to see who is blocking and find the dog that way. However, it would be helpful to get a better understanding of the activity monitor and how to use it as well as anything else to get to the source of the problem.
The Microsoft page for the monitor (http://msdn.microsoft.com/en-us/library/cc879320.aspx) gives a definition on the various column, but not really a good explanation on how to dig in and use the tool effectively.
I am going working my way through some SQL Server Execution Plan resources (one by Grant Fritchey). This is working well for when I know what procedure/query is causing the issues.
I am and have been mainly an IT developer (C#, SQL, PHP, etc) and would like to learn a lot more about the DBA side of the fence and tuning and performance sounds like a really interesting place to start.
Any ideas on best practices as well as where to look for additional help?
Thanks,
Anton
What
August 1, 2014 at 8:45 am
Gail has written a great article on Simple-talk.
August 1, 2014 at 9:41 am
Jeff Shurak (8/1/2014)
Jeff,
Thanks for the point in the right direction. These two articles and the one on deadlocks look very informative.
Gives me something to do this weekend.
Anton
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply