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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 stored proc hangs

Author  Topic 

prodigy2006
Yak Posting Veteran

66 Posts

Posted - 2010-01-14 : 11:46:00
A stored proc which used to just take a couple of seconds to run, now it never seems to stop. What could be the reason?

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2010-01-14 : 11:49:15
perhaps a bad query plan? drop/recreate the proc and the plan should be flushed out...or you can use sp_Recompile to recompile next time it is run...

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2010-01-14 : 13:58:16
My car is broken, please fix it....

Post the sproc



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page
   

- Advertisement -