QUERY TUNING

Question

Post reply

QUERY TUNING

m.rajesh.uk

Hall of Fame

Points: 3653
More actions
January 21, 2013 at 2:07 am

#288191

How to Query Tune The Stored procedure.. Any helpful document..
Where to start
how to do..
Thanks

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

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Your question is a bit broad.

I'd suggest you start reading a book, such as SQL Server 2012 Query Performance Tuning.

I'm also pretty sure if you enter "sql server query tuning" in Google, you'll get a lot of results. Just a hunch.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 2

m.rajesh.uk (1/21/2013)
How to Query Tune The Stored procedure.. Any helpful document..
Where to start
how to do..
Thanks

VERY vast topic . one can spend months or even years on it.

a lots of thing could be covered here like

query redesign

index redesign ot missing indexes

unneccassry order by or select columns.

unwanted intermediate data manipulation.

off execution plan or outdated statistics.

fight between table variable or temp table

usage of tvf function.

missing or imporper filters like where or and clause.

better google these terms 🙂

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

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

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-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

m.rajesh.uk Hall of Fame Points: 3653 More actions · Answer 4

m.rajesh.uk

Hall of Fame

Points: 3653

January 21, 2013 at 2:48 am

#1579156

Thanks for your valuable reply...

Andre Ranieri SSCrazy Points: 2819 More actions · Answer 5

I agree - Grant Fritchey's books on SQL tuning are the simply amazing.

I own a dog-eared copy of "SQL Server 2008 Query Performance Tuning Distilled" but haven't broken down and bought the sequel yet.

Edit: Grant has a a companion book on interpreting execution plans that's a really good weekend read. Highly recommended for a quick deep dive into the subject of performance tuning.