Simple play icon Course

Troubleshooting and Optimizing SSRS Reporting

by Viktor Suha

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

Course Overview

Course FAQ

What is SSRS?

SQL Server Reporting Services (SSRS) is a server-based report generating software system that is offered by Microsoft.

What will I learn in this SSRS troubleshooting course?

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.

What are the benefits of SSRS?

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.

What is SQL management studio?

SQL Management Studio is a software application that is used to configure, manage, and administer all the components within a Microsoft SQL Server.

What are T-SQL queries used for?

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

Ready to upskill? Get started