Post reply

Things need to check

  • April 30, 2020 at 1:41 am

    #3747541

    Hi,

    can anyone please suggest what are things needs to check after windows patching and Sql Server Patching on the server.

    Eg : Services Running like..

  • April 30, 2020 at 5:33 am

    #3747555

    Some of the obvious things are.

    1. Did the SQL services restart and are running (if not, review error logs)
    2. Run SELECT @@VERSION to confirm the build id is updated to what was expected.
    3. Run general smoke testing such as remote connection to the database, query, Job Activity Monitor, etc.

  • April 30, 2020 at 10:02 am

    #3747603

    Yes, and have users on standby to check that the user experience hasn't deteriorated in terms either of performance or feature availability.

    John

  • April 30, 2020 at 3:35 pm

    #3747725

    You should have a set of smoke tests, things that verify the system meets your needs. A few things listed above, but here's the type of things I look for:

    1. I can connect to the SQL Server
    2. A normal (non admin) user can connect and query some table ( usually something the app needs)
    3. No critical errors
    4. Performance counters within normal bounds

    Script  these things and have something that many people know to run after any patch/upgrade/deployment

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

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

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