Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm looking for resources that can teach me how to properly read a sql server execution plan.

I'm a long time developer, with tons of sql server experience, but I've never really learned how to really understand what an execution plan is saying to me.

I guess I'm looking for links, books, anything that can describe things like whether a clustered index scan is good or bad along with examples on how to fix issues.

share|improve this question

2 Answers 2

up vote 1 down vote accepted

I think this free e-book from Grant Fitchey is a really good place to start. I'm not shilling for RedGate, trust me, just recommending a good freebie. Use the "Just the E-book please" link to skip the trial software.

Other than that, the SQL 2008 Internals book from Kalen Delaney/Tripp/Randall is a bit more all-encompassing, but excellent

share|improve this answer

I've heard good things about SQL Server 2008 Query Performance Tuning Distilled. I haven't read it yet myself but it's on my own to buy list. Lots of great reviews for it on Amazon, blogs, etc...

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.