LinkedIn | FaceBook | Twitter
I've been covering lots of reports that ship in the box with SQL Server Management Studio, but there are several others that you can get (if you have Service Pack 2 for SQL Server 2005) that are really amazing.
First things first. You can download them here: http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en
When you download the reports, make sure you read the instructions carefully, and note down where it unpacks them. You have to open and run a SQL script in that directory for the reports to work. Also, within that directory is a ".CHM" file - which is a compiled help format documentation file.
I won't document these reports, because it's already done in the CHM file. These are a GREAT set of reports to have around, though. You can get some very detailed performance information, which as you know is one of the most requested things we hear about.
I've been covering lots of reports that ship in the box with SQL Server Management Studio , but there