Things I've built.

SQLTempo

SQLTempo is a FREE-to-use lightweight reporting utility currently for SQL Server. It captures the current state of an instance and its databases and produces a small HTML report you can use to compare against prior reports from days, weeks, or even months ago. It's designed to be run from a DBA's workstation, so nothing is installed on production servers.

• Installs and updates from a single location — no agent on the SQL Server
• Runs from a DBA's workstation or a single shared application server
• Ideal for Historical review that allows changes to be seen overtime
• Simple command-line usage, ready to run in under five minutes

What does the SQLTempo report include? Here is a small list of reported sections.

• SQL server Time/Up Time/Version and more...
• SQL Volume Information, Total Size, Available Size, Space Free % and more..
• Database Files, Physical Name and Location, Max Size, Growth and more...
• Drive Latency, Drive, Read Latency, Write Latency and more...
• SQL Backup Information, Recovery Model, Last Full Backup, Last Differential Backup and more..
• and so much more.

A special Thank You to Glenn Berry and the entire team at SQLSkills.com for all the support and training over my career as a DBA.

# show usage
SQLTempo.exe /HELP

# instance-only report
SQLTempo.exe --server=SQLPROD01 /I

# full report, verbose
SQLTempo.exe --server=localhost /V

✓ 0 changes required on target server