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