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.
Author Name: Viktor Suha
Author Description:
Viktor has been working with the Microsoft data platform for many years now. He is a Cloud Data Architect, having worked with the largest enterprise customers in different roles. His experience covers widespread knowledge in data engineering, database administration, database development and consulting. Viktor owns several Microsoft Azure certifications as well as an MCSA certification for SQL Server. He is keen to learn new technologies and he is a lifelong learner. In his latest role, he prima… more

Table of Contents

• Course Overview
  1min
• Understanding SSRS Report Problems
  13mins
• Understanding SSRS Report Execution
  17mins
• Troubleshooting Report Execution Problems
  21mins
• Troubleshooting Report Data Retrieval
  25mins
• Troubleshooting Report Processing and Rendering
  40mins
• Troubleshooting the Report Server
  29mins
• Troubleshooting Report Expressions
  24mins