How to perform SQL Server health check


pls guide or share any powershell script to perform sql server health check. i have sql server 2012.



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.

1 Like