How to Tune Performane of Stored Procedure

Question

How to Tune Performane of Stored Procedure

Diyas

SSCarpal Tunnel

Points: 4851
More actions
May 23, 2012 at 2:39 am

#392319

hi,
how to tune the performance of a stored procedure.

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

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

Ant-Green SSC Guru Points: 113509 More actions · Answer 1

such a broad topic, there are plenty of good articles buy doing a search in a search engine of your choice, but if you have something specific, please follow the link in my signature by Gail on how to post performance issues.

vinu512 SSCoach Points: 15729 More actions · Answer 2

Div Goud (5/23/2012)
hi,
how to tune the performance of a stored procedure.

Depends on the Stored Procedure that you are talking about. But, generally there are a few things you need to take care of in order to write optimized Stored procedures. the following links might be of some help:

Part 1

Part 2

Hope this helps.

Vinu Vijayan

For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

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

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

After reading Gail's articles, read my book. Links are in the 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