What does Waiting to be processed (sleeping) mean?

Toutes les réponses

• mardi 10 août 2010 20:48

   

   
  

  0

  ____ qbos,

  Brian Smith wrote this blog that gives you a lot of details of the queue states.

  http://blogs.msdn.com/b/brismith/archive/2007/02/28/my-queue-is-stuck-how-to-manage-your-queue-service-in-project-server-2007.aspx

  cheers!

  MIcahel Wharton, MBA, PMP, MCT

  ---

  Sincerely, Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA www.WhartonComputer.com

  • Marqué comme réponse Brian Smith - MSFTMicrosoft Employee, Moderator jeudi 19 août 2010 20:09
  •  
  • Réponse
  • Citation

   
• vendredi 20 août 2010 16:59

   

   
  

  0

  Thanks Michael, but Brian Smith's blog still doesn't address the sleeping part.

  Every job that we submit lately (saves, check-ins, etc.) are now starting in the Waiting to be processed(Sleeping) state; after a bit they, move to the Waiting to be processed state, and then eventually get to the processing state. Once there, the .mpp save and publish jobs are taking an extremely long time to process for mid-to large .mpps, up to 2 hours, and some never complete--getting hung up at around 95%. 

  Our SQL Server DBAs index the database weekly, and our Internet connection is very good.

  Any suggestions?

  • Réponse
  • Citation

   
• vendredi 20 août 2010 18:42

  Modérateur

   

   
  

  0
  Hi gbos, Check that the time on both servers is the same.

  ---

  Ben Howard [MVP] http://appleparkltd.spaces.live.com/
  • Réponse
  • Citation

   
• mardi 7 septembre 2010 17:59

   

   
  

  0

  The times are the same on both.

  • Réponse
  • Citation