May 31, 2017 at 2:38 am
Hello All,
Is there any way to health check multiple SQL Instances\servers after the scheduled patching?
I am looking for a script (Powershell or TSQL) which should be able to perform generic health check like (ALL SQL services should be up which are in automatic mode, All database status, Mirroring\AlwaysOn status etc), this script will require to show the report for all servers.
Thanks in advance.
Regards
May 31, 2017 at 2:44 am
What have you already tried, and what are you struggling with - the queries to do the actual health checks, or getting them to run on all servers? I think this is too detailed a requirement to answer in a single forum topic. If anyone has done this before, it'll be out there if you search for it. I've done something similar with SSIS, but that's for regular checks - probably overkill for something you only want to run after patching.
John
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply