How Often Do You Give Your Server a Physical?

  • pamelamooney1966

    SSC Veteran

    Points: 244

    Comments posted to this topic are about the item How Often Do You Give Your Server a Physical?

  • sqlservercentral-631096

    Grasshopper

    Points: 19

    Hey,

    Thanks for sharing your knowledge, though I suspect the "Let's Start with Architecture" link at the bottom is incorrect.  It's currently to an article from 2012 🙂

    Hope this helps.

    https://toepoke.co.uk

  • pamelamooney1966

    SSC Veteran

    Points: 244

    Thanks! I will find out what is happening and see if I can get it corrected.

  • MVDBA

    SSC-Insane

    Points: 20728

    I check almost everything I can think of every day.

    we used to call it a daily health check.

    Every day I add a new check to the job and export the list of failures to an internal website so that first line engineers can see these issues.

    PLE, wait times, buffer cache hit ratio. etc etc, these are all as important as failed sql agent jobs

    we have a lot of servers and more databases (I guess maybe 400 distinct databases) than I can count, so centralising the data is key.

    Enabling others to say that a server might be out of our "tollerance zone" helps hugely.

    Needless to say, we have not got it right yet

    if i add a check every day, it makes my life easier when we add new servers or databases... currently i'm checking for objects that don't compile (no sense breaking builds in devops with code that doesn't work)

     

     

    MVDBA

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715401

    Apologies, the link is for an article due to publish in a few days. I'll remove it for now.

  • Jeff Moden

    SSC Guru

    Points: 994555

    Heh... as of late and at the rate that MS is pushing versions, my answer to the question posed by this thread is... every time we're forced to do an upgrade. 😀

    More seriously though, I'm like many others... I have reports that let me know when something is starting to slip a bit or when something bad starts to happen (not the norm because of the previously mentioned reports).  But, like anyone else, I'm not perfect and so I'm very much looking forward to this series of articles to see what I might be able to do better.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • wessir

    Newbie

    Points: 1

    DBA isn't my first hat but is part of my responsibilities so I'm looking to gain something from this thread.

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

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