Post reply

DB Health Check

  • October 3, 2008 at 1:10 pm

    #124070

    Hi All,

    Recently I heard that 'any DBA worth their weight can do a health check.' This has perplexed me, as I cannot seem to find even a loose definition of what performing a health check involves, let alone a standard. I am curious to know what senior DBAs consider to be a valid list of criteria/tasks to cover during a routine 'health check.'

    Any feedback is greatly appreciated.

    Thanks!

  • October 3, 2008 at 1:46 pm

    #880688

    Off the top of my head...

    Disaster recovery - do you have a workable one and is it functioning properly

    Performance - are there performance bottlenecks? what are they?

    Is the DB sound - run physical and logical integrity checks

    Is the server sound?

    Are there any errors (system, application, otherwise)?

    What about deadlocks, locks, excessive waits, etc?

    Are there any upcoming issues? (i.e running out of space)

  • October 3, 2008 at 2:12 pm

    #880700

    Security checks: Do any of the fixed database or server roles have members that they shouldn't? Are a large number of unexplained login failures occurring?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 8, 2008 at 10:03 am

    #882424

    Thank you Pam and Gail, this was helpful.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply