Error: 17883 - issue with SQL Server Scheduler

• imarchenko-236376

  SSCommitted

  Points: 1734

  More actions

  June 28, 2005 at 1:53 pm

  #88908

  Hello!

   

     We are running SQL Server 200 SP Enterprise Edition on Windows 2003 with SAN components. Just recently, we got an error message in SQL Server error log:'Process 53:0 (ac8) UMS Context 0x11EF2ED8 appears to be non-yielding on Scheduler 0.'

      I found a couple of articles on MS website:

   

  http://support.microsoft.com/kb/319892

  http://support.microsoft.com/kb/810885

  http://support.microsoft.com/kb/890637

  One of the articles refers to High-End disk system as possible source. I am wondering whether anyone had similar problem and had been able to detect the cause of this type of error message. 

   

  Thanks,

  Igor

• noeld

  SSC Guru

  Points: 96590

  More actions

  June 28, 2005 at 2:06 pm

  #569137

  SQL Server is very picky whenit comes to timings and sometimes on High-End systems it can trigger that error during AUTOGROW (which you should avoid at all costs) and File Locking functions.

  There is a solution HotFix which was included in SP4:

  http://support.microsoft.com/default.aspx?scid=kb;EN-US;815056

  If you feel confortable with SP4 then go ahead and apply it other wise contact MS to obtain the HotFix only

  hth

   

  
  * Noel