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 |
|
abc123
Starting Member
47 Posts |
 Posted - 2008-08-12 : 10:51:38
|
| Hi, I have one questionConsider I have one procedure which is performing very slow.1.which steps should I follow to increase the performnce of this steps?2. How I can find out which query is performing slow from stored procedure ? |
|
|
acollins74
Yak Posting Veteran
82 Posts |
Posted - 2008-08-12 : 11:04:52
|
| Hi,I have two answers.1. Use SQL Profiler. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-12 : 14:17:41
|
| Choose SP events in SQL profilerand check execution plan for high cost. Maybe you need index. |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2008-08-12 : 16:56:57
|
| Do the usual stuff as indicated above. Also take a step back from your code and think for a second : "Is this as set based as possible?" because if your stored proc is doing some sort of crazy nested loop you are never going to get good performance from it and the inefficiency will scale with your data set size.-------------Charlie |
|
|
|
|
|
|
To increase the performance