I utilised sp_Blitz in a single of our database server and it is basically handy as we may get a sense how the database is behaving. But Why don't you Allow SqlBak get it done for you personally mechanically? it's got https://www.ralantech.com/sql-health-check-consulting-service/