Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

QUERY TUNING Expand / Collapse
Author
Message
Posted Monday, January 21, 2013 2:07 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 4:04 PM
Points: 190, Visits: 477
How to Query Tune The Stored procedure.. Any helpful document..
Where to start
how to do..
Thanks
Post #1409425
Posted Monday, January 21, 2013 2:25 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:55 AM
Points: 13,570, Visits: 11,383
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
Posted Monday, January 21, 2013 2:27 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:11 AM
Points: 2,840, Visits: 3,976
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
Post #1409434
Posted Monday, January 21, 2013 2:47 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:31 AM
Points: 40,456, Visits: 36,912
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
Posted Monday, January 21, 2013 2:48 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 4:04 PM
Points: 190, Visits: 477
Thanks for your valuable reply...
Post #1409444
Posted Monday, January 21, 2013 4:39 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, November 25, 2014 11:15 AM
Points: 292, Visits: 319
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 »

Add to briefcase

Permissions Expand / Collapse