Performance Tuning Visualising Analysis Services Trace Information in Reporting Services
| Visualising Analysis Services Trace Information in Reporting Services |
| Written by Chris Webb |
| Tuesday, 18 March 2008 17:20 |
|
More fun with Reporting Services. The other week I was working with a customer who I suspected was experiencing query performance problems as a result of the issue described here: http://blogs.msdn.com/sqlcat/archive/2007/10/19/ssas-small-big-query-interaction.aspx Certainly in Profiler I could see some fairly trivial queries which were taking much longer than they should have done, and which when I ran them on a test system ran much faster. And certainly when I ran a 'big query' and a 'small query' simultaneously I saw the 'small query' run slow, and when I got the secret ini file settings from PSS my 'small queries' ran much faster. But there was still some doubt in my mind over the extent to which the customer was suffering this problem - just by looking at my Profiler traces from the Production servers I couldn't tell whether lots of small queries were overlapping with the big queries. What I then thought was that it would be useful to be able to visualise the information from a Profiler trace in some way. I did some experiments with different chart types and different tools, mainly Excel 2007, but in the end I went with Reporting Services 2005 and the Dundas Gantt chart control. I'm not sure whether the Gantt chart has made it into the current RS2008 CTP but I guess it will soon if it hasn't; in any case the data was coming from a 2005 system so that's what I used.
|
Latest Author Articles
- NonEmpty() and that all-important second parameter
- Reporting Services-generate MDX, Subselects and Formula Caching
- Calculated members are better than assignments to real members (at least sometimes)
- Using AS Data Mining to Add Forecast Values to a Cube
- Displaying totals at the bottom
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Using AS Data Mining to Add Forecast Values to a Cube
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
