Master db being hammered

• S Hodkinson

  SSCertifiable

  Points: 7529

  More actions

  January 11, 2010 at 7:07 am

  #136536

  We have noticed that the master db is currently being hammered on one of our servers. When you look at performance the cpu is going up to 100%. The other databases on the server are hardly being used but master is surging from nothing to 100% and back down.

  Any clues?

  Madame Artois

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  January 11, 2010 at 7:14 am

  #1101763

  This Proc is probably a good starting point

  http://sqlblog.com/blogs/adam_machanic/archive/2009/12/03/who-is-active-v9-57-fast-comprehensive-dmv-collection.aspx

  ---

  
  Clear Sky SQL
  My Blog[/url]