The Author Online Book Forums are Moving

The Author Online Book Forums will soon redirect to Manning's liveBook and liveVideo. All book forum content will migrate to liveBook's discussion forum and all video forum content will migrate to liveVideo. Log in to liveBook or liveVideo with your Manning credentials to join the discussion!

Thank you for your engagement in the AoF over the years! We look forward to offering you a more enhanced forum experience.

atolmeijer (11) [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