PASS Community Summit 2008: Program Sessions (Business Intelligence)

SQLCAT - Collecting Analysis Services Performance Data by using Management Data Warehouse, SQL Profiler, and AS DMVs in SSAS 2008

Presenter:
Carl Rabeler (Microsoft SQL CAT)

Co-Presenter:
Brian Knight (Pragmatic Works)
Maciek Sarnowicz (Microsoft Corp.)

Session Details

In this session, you will learn how to collect Analysis Services query and processing performance data through the use of custom reports that query system performance counters, Analysis Services profiler trace information and Analysis Services Dynamic Management View (DMV) data collected in Management Data Warehouse (MDW). You will learn how the SQL CAT team has extended Management Data Warehouse through the use of custom data collectors and reports. In this session, we will demonstrate how the SQL CAT Best Practices team uses MDW for performance testing and analysis of test runs during stress and configuration testing of Analysis Services

Register Now for PASS Community Summit 2008!