I made use of sp_Blitz in one of our database server and it is really beneficial as we could possibly get a really feel how the database is behaving. It is determined by the server complexity and instruments employed. https://www.ralantech.com/sql-health-check-consulting-service/