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 |
|
learning_grsql
Posting Yak Master
230 Posts |
 Posted - 2013-06-29 : 03:59:00
|
| Some of the stored procedures which were working fine and used to execute in few minutes now taking ages to open sometimes even half an hour.How can I find the cause of the issues and sort them out? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2013-06-29 : 04:54:32
|
Run "exec sp_who2" to see what other processes are running.Run "exec sp_locks" to see if there are any blocking.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
prett
Posting Yak Master
212 Posts |
|
|
|
|
|
sql stored procedures performance too slow