SQLTeam.com | Weblogs | Forums

How to perform SQL Server health check

sql2012
#1

Hi,

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

thx

#2

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.

#3

You can also have a look at Brent Ozar's health check script.

https://www.brentozar.com/blitz/

1 Like