I applied sp_Blitz in one of our database server and it is admittedly handy as we could possibly get a come to feel how the database is behaving. It will depend on the server complexity and applications utilized. https://www.ralantech.com/sql-health-check-consulting-service/