SQL Server health check

  • 892717952

    SSC Veteran

    Points: 219

    If I want to do a SQL Server health check, which aspects should be checked?  and how often this health check should be done ? thanks!

  • Site Owners

    SSC Guru

    Points: 80385

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • Grant Fritchey

    SSC Guru

    Points: 395264

    A health check is generally not done very often. A server health check is looking at the server configuration, settings, etc., to determine whether or not they are appropriate for the hardware. Additionally a health check can include some performance aspects such as looking at wait statistics on the server to understand where bottlenecks exist. The reason for this is because those bottlenecks can also suggest where to check that settings are correct.

    As to frequency, I'd say any time you're new to a system, do a full examination of it, and then, any time hardware or settings are changed. Other than that, they're generally not needed. This assumes of course, the servers are under your control and you have good change tracking, source control, etc. If they're not under your control, maybe, monthly spot checks to see if anything has changed.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • 892717952

    SSC Veteran

    Points: 219

    Thank you Grant Fritchey for you kind and patient assistance !

  • Andrey

    Old Hand

    Points: 383

    good and well-known tool for that :

    https://www.brentozar.com/blitz/

     

  • Grant Fritchey

    SSC Guru

    Points: 395264

    There are lots of tools for doing health checks. I just found this one: https://mitchwheat.com/sqlfrontline/

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

Viewing 6 posts - 1 through 6 (of 6 total)

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