Presentation Material for Webcast on Performance Dashboard

On 4th May 2011 (Day 3), Amit Banerjee presented webcast on “Understanding Performance Bottlenecks using Performance Dashboard”. In this session Amit demonstrated how to troubleshoot a SQL Server performance issue using out-of-the-box features without having to collect diagnostic data for post-mortem analysis.

This session was attended by more than 500 participants via webcast and we heard very positive feedback.

Many participants asked the presentation material and we have posted it here. For video recording, we need to wait for marketing team. Once its made available to us, we would share with the world.

Happy Learning!!!

Regards,
Balmukund Lakhani
Technical Lead
SQL Server Support Team

Comments

  • Anonymous
    May 10, 2011
    How did the "Blocking Report" come up in the Dashboard. I download it from www.microsoft.com/.../details.aspx.

  • Anonymous
    May 12, 2011
    Is this available for SQL 2008 or 2008 R2?

  • Anonymous
    May 12, 2011
    The blocking report can be obtained by clicking on the any of the wait-type bars shown in the "Current Waiting Requests" graph on the Performance Dashboard Main report. The first answer in the post: troubleshootingsql.com/.../qna-performance-dashboard-webcast explains how to make Performance Dashboard work for SQL Server 2008 and SQL Server 2008 R2.