SQLBits 2014

Building a BI Performance Monitoring Solution

Learn how to use performance counters, report execution log data, and trace files to troubleshoot performance problems. Learn how to set up a monitoring solution to capture data and diagnose slow queries.
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.