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 |
|
krajdba
Starting Member
43 Posts |
 Posted - 2008-11-28 : 12:33:35
|
| Hi,There is a stored procedure in our database, which was doing good till last week. use to take just about 10 seconds to complete. However, now the stored procedure has considereable slowed down and is taking about 5 mins to finish.Please let me know how to get back the original speed. what to do?Please help.Raj. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-28 : 12:39:59
|
| Has you updated statistics of table? Also has any bulk data inserts happened over lately? Probabaly worth analysing execution plan also while procedure executes. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-28 : 12:40:19
|
| Have you Rebuild/update statistics? |
|
|
|
krajdba
Starting Member
43 Posts |
Posted - 2008-12-02 : 06:54:57
|
| yesRaj. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-02 : 07:03:35
|
Have you saved the original execution plan?Can you compare the old execution with the current execution plan?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
SP performance slowed down.