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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2010-08-18 : 06:22:10
|
| i am running a query, which i see in the Activity monitor is changed to SUSPEND MODE.in the activity monitor the only thing that run's at that time, is some system operation on tempdb.when i follow up, isee that some times my query goes out for a second or two from suspended mode, and goes back to that mode.any idea why?ThanksPeleg |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2010-08-18 : 06:33:07
|
| maybe it is waiting for some resource?check sys.dm_tran_locks in books online to determine what is causing the suspend mode--------------------keeping it simple... |
 |
|
|
|
|
|
query sent to suspend mode