Are you a DBA that has no funding for fancy SQL System Health Reports like RedGate, SQLTools, Foglight, SentryOne, etc? Do you hate looking at dmv queries because there are so many of them to remember? Well did you know that SQL Management Studios comes with System Health Reports? Below are steps to get System Health Reports at no cost.
To view the System Reports
Right click on “your Server” -> Reports -> Standard Reports -> “select a report”
To view the Database Specific Reports
Each report can be expanded for detail information.
As always, hope this helps!