Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hirani_prashant
Yak Posting Veteran
93 Posts |
 Posted - 2008-05-12 : 01:48:14
|
| Hello,i need to tune some of my store procedures.can any one help me how it's possible to tune particular store procedures?Thanks Prashant Hirani |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-12 : 03:44:43
|
| Run the strored procedure with Actual Execution plan on in SQL Server Mgmnt Studio.Analyse the execution plan and try to spot costly steps and try to tune them. You may also use Profiler to identify long running queries inside stored procedure. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-05-12 : 04:06:27
|
| If you want some specific help on tuning a query, please post the query, the table schema and index definitions and some idea of the row count involved..--Gail Shaw |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-12 : 09:20:35
|
| check this out:http://www.sql-server-performance.com/tips/stored_procedures_p1.aspx |
|
|
|
|
|
|
How to tune particular store procedure