March 19, 2010 at 9:58 pm
Hi,
I'm new to the performance tuning. Where can i start checking the performance i.e., what is the process to check. Any guide lines with step by step process. We have so many DMV's how can i use one by one(in the hierarchy manner). Please help me. Is there any helpful links.
🙂
March 20, 2010 at 12:22 am
Since you mention DMVs, you could start by looking for Glenn Berry's Dr. DMV Scripts.
You could also take a look at the book by Grant Fritchey on execution plans.
http://www.amazon.com/Server-Execution-Plans-Grant-Fritchey/dp/1906434026
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 20, 2010 at 2:41 pm
The best guide I have seen for 2005 is the following White Paper from Microsoft:
March 22, 2010 at 3:24 am
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply