QUERY TUNING

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » QUERY TUNING

QUERY TUNING

Rate Topic

Display Mode

Topic Options

Author

Message

m.rajesh.uk

Posted Monday, January 21, 2013 2:07 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 11:47 AM
Points: 109, Visits: 273

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

Post #1409425

Koen Verbeeck

Posted Monday, January 21, 2013 2:25 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:54 AM
Points: 9,364, Visits: 6,462

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.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1409431

Bhuvnesh

Posted Monday, January 21, 2013 2:27 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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 Smile

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1409434

GilaMonster

Posted Monday, January 21, 2013 2:47 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 2:45 PM
Points: 37,635, Visits: 29,885

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 2008, MVP
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

Post #1409442

m.rajesh.uk

Posted Monday, January 21, 2013 2:48 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 11:47 AM
Points: 109, Visits: 273

Thanks for your valuable reply...

Post #1409444

Andre Ranieri

Posted Monday, January 21, 2013 4:39 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 7:56 AM
Points: 277, Visits: 200

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.

Post #1409478

« Prev Topic | Next Topic »

Permissions