SQL Server Health and History Tool (SQLH2)

I'm loving all the new tools coming out for SQL DBA's - check out the SQL Server Best Practice Analyzer as well.

The Microsoft SQL Server Health and History Tool (SQLH2) allows you to collect information from instances of SQL Server, store this information, and run reports against the data in order to determine how SQL Server is being used.

You then view this data using SQL Server Reporting Services using "SQL Server Health and History Tool (SQLH2) Reports"

Overview
SQLH2 collects four main types of information:

• Feature Usage – What services/features are installed, running and level of workload on the service.
• Configuration Settings – Machine, OS and SQL configuration settings, SQL instance and database metadata.
• Uptime of the SQL Server service
• Performance Counters (optional) – Used to determine performance trends

System Requirements

• Supported Operating Systems - Windows Server 2003, Windows 2000, Windows 2000 Service Pack 2, Windows 2000 Service Pack 3, Windows 2000 Service Pack 4, Windows NT, Windows Server 2003, Windows XP

Download it from here

-by way of Darrell Norton's blog -