I utilized sp_Blitz in one of our database server and it is absolutely handy as we can get a come to feel how the database is behaving.
Throwing hardware at the problem generally seems like the most effective solution https://blakefwlo963603.like-blogs.com/29841465/the-greatest-guide-to-sql-server-health-check-consulting-service