SQL: Custom SQL Info/Config Report - Printer Ready! v1.6
Date: 2016-05-04 10:02:55
Here is an updated printable report for SQL Information and Configuration! I've tested the report queries against SQL 2005 SP4, SQL 2008 R2, and SQL 2012, and now with SQL 2014. It looks great. The best part is this report is rendered from within SQL Studio Management itself, a reporting server isn't needed. I used Visual Studio 2005 to create the report.
Here is the updated report RDL
for you to use (Right-Click the link and choose Save Link As).
This report encompasses all the configuration items, plus some more, from my previous article
and previous article
Updated in version 1.6 is the VLF check for 2014 and I reduced the Wait rows to the Top 10
To run this report directly in Studio Management:
1. Download the linked RDL to your desktop
2. Open SQL Studio Management
3. Connect to a SQL Server
4. Right-click the server
5. Choose Reports
6. Choose Custom Reports…
7. Browse to the RDL and Select it
8. To Export as PDF, right click inside the report window and choose Export…
If you are nervous about using the RDL, open it with Notepad and review the queries.