I have setup the Data Collection feature in my SQL Server and I left it for a round a week, and now I have a nice colorful monitoring reports. Yet I don't understand much of what is in those reports, or in other words, I can read those reports but I do not know how to use them and benefit from them  .... for example, what is it to find the SQLCLR wait, the top in the SQL Server Waits sub-report?! how to evaluate its values? what to do if a value is high or low ... etc 

so I'm wondering if there is a book or a whitepaper (not a one page blog or five minutes youtube) that talks comprehensively about those reports and how to use them.

Hi Butmah,

You can review the third part of below article to understand the data collection reports and know how to use these reports for performance troubleshooting.

SQL Server performance monitoring with Data Collector Part 3 reading the reports
http://www.sqlshack.com/sql-server-performance-monitoring-data-collector-part-3-reading-reports/

And regarding to the book, you can choose some books about data warehouse and mastering SQL Server as shown in this link.
 

Thanks,
Lydia Zhang

Lydia thanks, but I said I don't want a one page blog as I think that the value of those report can't be reduced in short paragraphs that repeat _but in other words_ what is in BOL .... And the link u've posted is one short description of the reports. And I've asked for comprehensive a white paper, a book, or a presentation about the subject ... Not a very abstract 20 lines, that are barely good as introduction. Also you don't think that I didn't google the subject before I've posted my question on msdn forums, do you?! ... I've already read the link you've posted and did the same Google as you linked, before I asked Anyways thanks again, but believe me, most of who asks here put some effort and Google his issue before he/she asks, and we come here after we look at the first three or four pages of Google result ... We come here when we need experts like you :)

Microsoft has little explanation of the SQL Server Data Collection reports. BOL:https://msdn.microsoft.com/en-us/cc280385.aspx.

You'd better buy a book about SQL Server to understand it.

• Edited by Cheer08 3 hours 44 minutes ago

Microsoft has little explanation of the SQL Server Data Collection reports. BOL:https://msdn.microsoft.com/en-us/cc280385.aspx.

You'd better buy a book about SQL Server to understand it.

• Edited by Cheer08 Saturday, May 30, 2015 3:21 AM