Hi,
pls guide or share any powershell script to perform sql server health check. i have sql server 2012.
thx
Hi,
pls guide or share any powershell script to perform sql server health check. i have sql server 2012.
thx
Hi,
You wouldn't go far wrong starting with Glenn Berry's SQL Server Diagnostic Information scripts. I think that would give you a good starting point with lots of information and may assist you in creating your own set of checks.
You can also have a look at Brent Ozar's health check script.