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.
Speakers
Stacia Varga's previous sessions
Getting Your Story Straight with Data Visualizations
Choosing the wrong visualization can obscure the story - or worse yet, distort it! In this session, learn the vocabulary of data visualization and how to apply grammar (visualization design principles) to your data.
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.
So How Does BI Workload Impact the Database Engine? Part I
In this first of two sessions, we review the architecture of SQL Server and its BI components and deployment options for optimal performance. We'll also discuss how to optimize data warehouse load operations.