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 !!!
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
Last week, I got an opportunity to present on BI SQLPASS Virtual Chapter on All about Kerberos in Microsoft BI. Kerberos Troubleshooting is one of the highest call volume generator for Microsoft CSS and hence I thought I would choose this topic to educate our Customers on steps to configure Kerberos for SQL & SQL… Continue reading All about Kerberos in Microsoft BI
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
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