High waits due to BROKER_TASK_STOP wait type - should I be concerned?

• Marios Philippopoulos

  SSC Guru

  Points: 57190

  More actions

  October 15, 2009 at 1:51 pm

  #216363

  Roughly 50% of the total wait time in our production server is due to the BROKER_TASK_STOP wait type.

  Should I be concerned?

  __________________________________________________________________________________
  SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
  Persisting SQL Server Index-Usage Statistics with MERGE[/url]
  Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  October 15, 2009 at 8:55 pm

  #1066667

  They should not be a problem, they accumulate naturally when Service Broker is not in use. See here for more information.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]