Deal of the Day

Home » Main » Manning Forums » 2010 » SQL Server DMVs in Action

Thread: SQL Server Custom Reports - Performance Dashboard

Reply to this Thread Reply to this Thread Search Forum Search Forum Back to Thread List Back to Thread List

Permlink Replies: 1 - Pages: 1 - Last Post: Apr 14, 2011 5:34 AM by: ian.stirk
atolmeijer

Posts: 10
From: Netherlands
Registered: 3/8/10
SQL Server Custom Reports - Performance Dashboard
Posted: Apr 14, 2011 2:38 AM
  Click to reply to this thread Reply

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

Posts: 27
From: London
Registered: 2/25/10
Re: SQL Server Custom Reports - Performance Dashboard
Posted: Apr 14, 2011 5:34 AM   in response to: atolmeijer in response to: atolmeijer
  Click to reply to this thread Reply

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 books 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.

Im 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

Legend
Gold: 300 + pts
Silver: 100 - 299 pts
Bronze: 25 - 99 pts
Manning Author
Manning Staff
Manning Developmental Editor