How to know how healthy an SQL Server database is now? I want to know how healthy an SQL Server database is now (before I started to work with it).
Then, in a month or so, I want to check again to see how healthy database is at that time and compare it to the previous state.
Basically is there any way I can take something like a snapshot of the database health now and later? And then see what's been improved, so I can track my progress.
Any source of information would be great.
Look at sp_blitzfirst from www.brentozar.com
This store procedure will give you a good status of your SQL servers.