Please tel me any good books on profiler and query plan

Question

Please tel me any good books on profiler and query plan

rajemessage 14195

Hall of Fame

Points: 3315
More actions
January 19, 2015 at 8:15 am

#300416

hi,
Please tel me any good book on profiler and query plan or any good link
where i can get some problem and solution or steps to follow in different problems
yours sincerely

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

This would probably be a good place to start http://www.red-gate.com/community/books/sql-server-execution-plans-ed-2

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Sean Lange SSC Guru Points: 286590 More actions · Answer 2

rajemessage 14195 (1/19/2015)
hi,
Please tel me any good book on profiler and query plan or any good link
where i can get some problem and solution or steps to follow in different problems
yours sincerely

I assume you mean trying to improve performance for problem queries?

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

david.alcock SSCertifiable Points: 6021 More actions · Answer 3

Just to echo Gail's suggestion; BIG fan of this book: grab the free PDF and have a look through - it will guide you through the components of execution plans (with examples of course) and with the knowledge you can start dissecting plans that you are coming up against on your servers!

'Only he who wanders finds new paths'

Grant Fritchey SSC Guru Points: 398886 More actions · Answer 4

I am clearly biased, but check out the books below in my signature.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 5

Grant Fritchey (1/19/2015)
I am clearly biased, but check out the books below in my signature.

I'm clearly biased, as well. I only like good books and these are absolutely two of the best on this subject.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)