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 |
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
 Posted - 2009-04-27 : 02:18:48
|
| Hi allHope this is the right forum to ask this, All of a sudden our Stored Procedures that run overnight are taking hours to run instead of minutes.Is there any checks I can run to detect what is going on? I already have a couple of SP's that write info to a table if one of my SP's fail, but they don't seem to get to that state, they are just running slow.I have rebooted the server twice over the last fortnight and that seems to cure it for a while, but after a few days things start to run slowly again!can anyone give some guidelines as to where should i look to try and find the problem? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-27 : 02:24:01
|
You can use SQL Profiler/trace to capture the sp.Just make sure you include the actual execution plan.Then look at the execution plan to see if something looks suspisious.If not, something may have happened with the server's configuration.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
SP's running slooooooowww