MS SQL queue

• ran.ovadia

  Ten Centuries

  Points: 1183

  More actions

  March 16, 2009 at 6:41 am

  #200971

  Hi,

  I want to know how does MS SQL server queue work.

  Is there an option that my SP completed but MS SQL server queue hadn't finished processing the data yet?

  How can I access (view) the queue state?

  Thanks,

  Ran.

• maechismo_8514

  SSCoach

  Points: 17510

  More actions

  March 17, 2009 at 5:18 pm

  #961492

  sys.dm_os_waiting_stats dynamic managemtn view should be able to show you information about the wait queue stats.