I made use of sp_Blitz in one of our database server and it is actually practical as we may get a feel how the database is behaving.
It depends on the server complexity and equipment applied. primary manual checks https://sairavxkj399501.ttblogs.com/9520947/fascination-about-sql-database-health-check-company