Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    44

    Unanswered: Scheduler not yielding?

    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,

    Isaac

  2. #2
    Join Date
    Jun 2003
    Posts
    269

    Question

    post 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?
    I love cursor,though I never use it.Cos' I dont want to misuse it.
    ----------------------------------------------

    ----cheers
    ----http://mallier.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •