I utilized sp_Blitz in one of our database server and it is actually handy as we could possibly get a really feel how the database is behaving. I like this PowerShell library for DBAs. Rather than compose a whole lot https://www.ralantech.com/sql-health-check-consulting-service/