Skip to main content

SQL Server Reporting Services Performance Tuning - MSBI


Monitoring by Using Execution Log 2

The reporting services Execution log2 view is a good starting point from which to analyze your current workload and understad its dataset size, performance and complexity characteristics.
 
In particular, this view contains a new Addition Info column.
Execution Log2 Addition Info contains Information related to the size of memory pressure responding data structures.
 
One way this information can be useful is to check whether you have reports with high values (10s or 100s of MBs) – these reports might be candidate for further review, focusing on the design of those reports and the dataset query sizes.
 
FREE Demo Class From Industry Experts - Enroll Now.!! MSBI training
 
Some tips on how to view thaw ExecutionLog2 view to quickly understand potential performance bottlenecks are given below Linked is the Review Execution Logs reporting services project which create summary and detail reporting services reports on the last 1,000 entries into the executionLog2 view.
 
 
                                                     Fig: Review Execution Log s (Execution Log2) Summary report
 

Execution Log Details:

Query the most recent 1000 execution log details to better understand what is happening with RS server.
Instance Name Report PathUser NameRequest TypeFormat ParametersReport Action Source Status
My server/Review Exe logs/Exe log User A Interactive RPL Render Livers Success
My server /Review Exe logs/ User A Interactive RPL Render Livers Success
My server/SQL Auditing Reports/ Overview –DDL ActionsUser BInteractive RPLPmin Date = 01/09/200000 and max Date= 01/13/2009 00 00 and report key = 102Render Livers Success
 

Long – Running:

Sorting by Elapsedsec or RowCount helps you identify long – running reports.
If the value for TimeDataRetrieval is high, the data source is your bottleneck and you may want to optimize.
 
If there is a high value for RowCount a lot of data is being retrieved and aggregated by reporting servers – perhaps have your data source do this to reduce the load on your report server.
 
 
Subscriptions or Interactive:
Sorting by the RequestType field allows you to determine whether you have a lot of subscriptions.
you can then determne the bottlrnecks and stager – schedule the report (that is schedule the subscription execution times of the reports at different times.)
 
Live Data or Snapshots:
Sorting by the Source field allows you to determine your reports are typically live data or snapshots . If the reports can be snapshots (for example, yesterday’s report), create snapshots so you can avoid query execution, report processing and report rendering.
 
Laod Balanced:
Sorting by the Instance field can help you see whether your network load balancer is handling report request in a balanced fashion. You can also see if some nodes are down or not processing request.

Comments

Post a Comment

Popular posts from this blog

Blue Prism Free Totorial

Enterprise Robotic Process Automation Software RPA  Software Robots that Automate Business Processes across your entire Enterprise Robotic Process Automation (RPA) is an emerging technology of process automation based on Software Robots/Artificial Intelligence workers. RPA is the significant technological innovation of screen scraping. RPA provides new platforms which are sufficiently mature, scalable and reliable for use in large enterprises. Robotic Process Automation delivers profits by enhancing the reliability across numerous industries and organizations. These software robots interpret, trigger, compare, acquire results, and communicate with other systems just like a human. They perform a vast range of repetitive tasks without tire and mistakes. These robots even integrate readily and are easy to maintain. Interested in mastering  RPA Training ? Enroll now for FREE demo at   Tekslate . Empowering your Business with RPA Incorporating RPA t...
21 comments
Read more

Selenium interview Questions

If you're looking for Selenium Interview Questions and Answers for Experienced & Freshers, you are at right place. There are a lot of opportunities for many reputed companies in the world. According to research Selenium has a market share of about 27.7%. So, You still have opportunities to move ahead in your career in Selenium. Mindmajix offers advanced Selenium Interview Questions 2018 that helps you in cracking your interview & acquire your dream career as Selenium Developer. Top 35 Selenium Interview Questions And Answers : The entire set of Selenium interview questions is divided into three sections: Basic level Advanced level TestNG framework for Selenium Accelerate your career with Selenium Online Training and become an expert in Selenium. A. Basic Level  – Selenium Interview Questions 1. What are the significant changes in upgrades in various Selenium versions? Selenium v1 included only three suite of tools: Selenium I...
10 comments
Read more

What Is Salesforce? A Beginner’s Guide To Understanding Salesforce

In recent years, there has been a big surge in  Cloud Computing  Technologies. One such technology which has had an immense impact on the world of computing is Salesforce. In this blog, I will introduce you to Salesforce and will answer: What is Salesforce? Why use Salesforce? Where is Salesforce being utilized? And why companies are looking for professionals with  Salesforce Certification Training ? How It All Began? Before Salesforce, Customer Relationship Management (CRM) solutions were hosted on a company’s own server. Can you imagine the cost and time it took for companies to have their own CRM solutions? Well, it used to take months or even years to set it up and the cost went up to millions of dollars. Even after setting up, they were extremely hard to use. What would be a feasible solution to this? I am sure you guessed it – building an affordable CRM software and delivering it entirely online as a service. This was the main idea behind Salesforce. Star...
3 comments
Read more