Building a BI Performance Monitoring Solution

Users expect business intelligence solutions to quickly deliver answers to their questions. When queries start slowing down, how do you determine the root cause of the problem? Is it the report server, the cube, the query, or server resource contention? Come to this session to learn how to use performance counters, report execution log data, and trace files to troubleshoot performance problems. You'll also learn how to set up a monitoring solution to capture data for benchmarking purposes before problems arise and for diagnostic purposes when queries start slowing down. You'll also learn how to interpret the performance monitoring data so that you can take the necessary steps to resolve performance problems in your BI solution.
Presented by Stacia Misner at SQLBits XII
  • Downloads
    Video available MP4 Video HD 537 MB
  • SpeakerBIO

    Stacia Misner has over 25 years of experience with improving business practices through technology and has been providing consulting and education services for Microsoft’s business intelligence technologies since 2000. She founded Data Inspirations in 2006. Stacia is a SQL Server MVP, MCITP, MCTS, and a frequent speaker at technical conferences, including Professional Association for SQL Server (PASS) and SQL Server Magazine’s Connections. She has over 14 years of experience in business intelligence architecture and implementation, data warehousing, OLAP, ETL, and reporting and analysis. During that time, Stacia has authored or co-authored multiple books about Microsoft business intelligence technologies.
  • Video