Database query

• Mvs2k11

  Ten Centuries

  Points: 1223

  More actions

  September 27, 2011 at 7:37 pm

  #258015

  I need a scripts to check the system health for sqlserver 2008.

  Thanks for your help in advance

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  September 27, 2011 at 7:53 pm

  #1387506

  Google brent ozar blitz.

  That'll give you a script along with a 2.5 horus video that explains how to use it.

  Of course this only begins to scracth the surface of what needs to be done.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  September 27, 2011 at 8:45 pm

  #1387516

  Might look at Glenn Berry's diag queries as well: http://www.sqlservercentral.com/blogs/glennberry/archive/2011/09/27/september-2011-sql-server-2008-instance-level-diagnostic-queries.aspx