atolmeijer (10) [Avatar] Offline
#1
Hi Ian,

Maybe the topic of setting up custom reports for administrators (Performance Dashboard) is of interest (I think so).

Microsoft released a set of performance reports with SQL Server 2005 (SP2 is a minimal requirement). See: http://www.microsoft.com/downloads/en/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

To help with the installation of it, this link was helpful for me:
http://www.mssqltips.com/tip.asp?tip=1553

For SQL Server 2008, I found this blog contain valuable information:
http://blogs.technet.com/b/rob/archive/2009/02/18/performance-dashboard-reports-for-sql-server-2008.aspx

Thank you for the great information in the book, I use it an awfully lot more than I expected when I bought the MEAP.

Arno Tolmeijer
ian.stirk (27) [Avatar] Offline
#2
Re: SQL Server Custom Reports - Performance Dashboard
Hi Arno,

Yes you are right, the dashboard reports are very useful, and underneath they are using many of the DMVs discussed in the book. In fact, many of the book’s scripts could be included as new reports for the Dashboard.

The Performance Dashboard is one of the areas I thought about including in the book, but there is never enough time to include everything. At least you have recorded them here together with some useful references.

I’m glad you enjoyed the book. I think you were as surprised as I was to discover how useful this much neglected area could be!

Thanks
Ian