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 |
|
ganeshkumar08
Posting Yak Master
187 Posts |
 Posted - 2008-05-28 : 04:47:07
|
| Hi,Can any one give me an idea how can i increase performance of the stored procedure.In SP many temporary tables are used.Also i need a information from any one you that is there any tool to find out the performance of a query or SP etc.ThanksGaneshSolutions are easy. Understanding the problem, now, that's the hard part |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-05-28 : 04:53:20
|
| Have a look at the performance dashboard.Look at the query plan to see what is taking the time.Otherwise run the statements in the SP one by one to see what's taking the time.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
ranganath
Posting Yak Master
209 Posts |
Posted - 2008-05-28 : 04:53:59
|
| http://www.agsrhichome.bnl.gov/Controls/doc/database/opt_query.html |
|
|
|
ganeshkumar08
Posting Yak Master
187 Posts |
Posted - 2008-05-28 : 05:00:17
|
| Thanks for your reply.. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-28 : 10:23:49
|
| You can use counters inside SQL Profiler also to analyse the performance of SP.Take the profiler trace while excuting SP for statement batch started,statement batch completed counters and you can find out long running statements inside your SP. |
|
|
|
|
|
|
How to increase Performance of a Stored Procedure