What you'll learn

SSRS performance problems in an Enterprise environment are often rooted back to server deployment, resource utilization and report definition problems. The most common problems are the nonoptimal report query workloads executed live in the data source, most often in SQL Server relational databases. To troubleshoot these problems, SSRS offers a variety of methods and tools to track report executions, what report was executed when and how, but if the bottleneck is in the data source, you need to reach out to the data source layer and troubleshoot that as well. In this course, Troubleshooting and Optimizing SSRS Reporting, you’ll gain a better understanding of how to approach troubleshooting as a process. You'll follow the resolution of four SSRS report problems of different root-causes, while you discover SSRS troubleshooting methods and tools. When you’re finished with this course, you’ll have the skills to approach SSRS troubleshooting with a structure and apply SSRS specific troubleshooting techniques.