SQL Server Health and History Tool (SQLH2)
SQLH2 is a new tool from MS that helps collect information from different instances of SQL Server on a machine and then persist it on a database for analysis. A set of canned reports are provided that turn the data into meaningful reports. You can download SQLH2 from here: SQLH2.
We did a local install of this and started monitoring our servers. A couple of reports were broken because of some overflow issues and on fixing the appropriate stored procedures, we found that some arbit values where returned for these columns. Will need to submit this as a bug. Nevertheless, SQLH2 is a great way to monitor server usage and report off the same.