Troubleshooting and Optimizing SSRS Reporting
This course discusses SSRS performance concepts, what factors can contribute to SSRS report performance problems and how to troubleshoot the SSRS environment once those problems already persist.
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.
Table of contents
- Where Are We at with the Troubleshooting? 1m
- Demo: Reproducing the Second Report Performance Problem 4m
- Demo: Using Report Caching 4m
- Demo: Analyzing the Report Structure 4m
- Demo: Optimizing the Report for Processing and Rendering 7m
- Final Report Optimization Conclusions 3m
- Scalability Considerations 5m
- Demo: Using Windows Perfmon to Monitor Report Processing 9m
- Module Summary 4m
- Where Are We at with the Troubleshooting? 1m
- Errors and Exceptions 1m
- Demo: Reproducing and Fixing the Third Report Problem 5m
- Sales Orders City Report Error Types 2m
- Sales Orders City Report Fixes 2m
- Demo: Analyzing and Configuring the SSRS Trace Logs 5m
- Report Server Trace Logs and Configuration 4m
- Demo: Rsreportserver.config, Windows Event Logs, and Windows Reliability Monitor 7m
- Module Summary 3m
- Where Are We at with the Troubleshooting? 1m
- Runtime Expression Errors 2m
- Multi-tenant Reporting with a Single Report 2m
- Multi-tenant Reporting with Multiple Reports and Common Challenges 5m
- Demo: Reproducing the Fourth Report Problem 3m
- Demo: Analyzing the Report with Report Designer and Fixing the Report 5m
- Module Summary 2m
- Course Summary 3m
Course FAQ
SQL Server Reporting Services (SSRS) is a server-based report generating software system that is offered by Microsoft.
In this course, you will learn about report execution phases, bottlenecks and optimizations, SSRS execution logs, SQL Server extended events, and Troubleshooting report expressions. By the end of this course you will know how to approach troubleshooting with a structure and apply SSRS troubleshooting techniques.
SSRS supports file rendering into the most common file formats including: HTML, PDF, CSV, XML, TIFF, Word, and Excel. Reports that are in Microsoft Office formats are also fully editable which enable users to create custom documents based on these reports.
SQL Management Studio is a software application that is used to configure, manage, and administer all the components within a Microsoft SQL Server.
Transact-SQL (T-SQL) queries is an extension to the standard SQL language and is often used to interact with relational databases.
About the author
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