I employed sp_Blitz in a single of our database server and it is really helpful as we might get a truly feel how the database is behaving. We put in general performance trackers to history CPU, memory, and disk https://www.ralantech.com/sql-health-check-consulting-service/