All,
I'm getting the following error in my SQL logs:
Process 51:16 (2bc) UMS Context 0x1249F118 appears to be non-yielding on Scheduler 0.
I killed the process, but it's been rolling back for 3 hours. It's done zero IO and consumed a TON of CPU time.
Any suggestions as to what I can do?
Thanks,
Isaacpost details abt scheduler job.Are u executing DBCC DBREINDEX in that scheduler? what version of SQL server u are using? I hope it is SQL server 2000.If it is did u applied latest service pack?
No comments:
Post a Comment