SQL Server Performance Baselining Reports Unleashed for Enterprise Monitoring !!!

In my previous blog post, I had shared how you can leverage SQL Server Performance Dashboard SSRS Reports for monitoring and point in time troubleshooting for large deployments of SQL Server. In this post, we will talk about why dbas should establish SQL Server Performance baselines for their environment and how you can leverage the… Continue reading SQL Server Performance Baselining Reports Unleashed for Enterprise Monitoring !!!

SQL Reporting Services Performance Tuning Tips & Tricks

It has been really long time since I have blogged. However I will try to blog as often as I can. Very Recently, I performed a SSRS Performance Review to tune performance reports for one of our customers. While analyzing some long running reports we identified some usual issues which may not be aware while we are… Continue reading SQL Reporting Services Performance Tuning Tips & Tricks

Analytics for Report Server Execution Log using PowerPivot

As we all know, Report Server Execution Log plays a significant role and is the first place to look into in order to analyse & optimize the Performance of Reporting Services. Hence in each version of SQL Server, the ExecutionLog view in Report Server database is enhanced to gather more and more information. If you… Continue reading Analytics for Report Server Execution Log using PowerPivot

Unable to use Calculated Measures in MDX inside Category Groups of Chart Report Item in Reporting Services

Recently, one of our customers came across an interesting issue which many of us face while working with Reporting Services which fetches the data from Analysis Services cube using MDX. So I thought I will share this in this blog post for the benefit of the community. We have a following MDX query with Calculated… Continue reading Unable to use Calculated Measures in MDX inside Category Groups of Chart Report Item in Reporting Services