SQL Server Health and History Tool (SQLH2)
This tool has been available for a couple of months but I only found out about it yesterday; I was reading some stuff about SQL Server 2005 and found a reference to say this tool will be supported in SQL 2k5. Realising such downloads have sometimes escaped me I’ve decided to subscribe to Download Notifications
https://www.microsoft.com/downloads/render.aspx?displaylang=en&content=notifications
From the website SQLH2:
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.
Overview
SQLH2 collects four main types of information:
1. Feature Usage – What services/features are installed, running and level of workload on the service.
2. Configuration Settings – Machine, OS and SQL configuration settings, SQL instance and database metadata.
3. Uptime of the SQL Server service
4. Performance Counters (optional) – Used to determine performance trends