James Rogers
3 posts.
- Tuning Analysis Services (SSAS) for better Parallel Aggregation/Index ProcessingOne of the key performance concepts in Analysis Services is the design and use of good Aggregations to support user queries. However, Analysis Services…
- SSAS Usage-Based Optimization, OlapQueryLog (Enabling and Disabling), Aggregations and Structure Changes.Analysis Services has a useful feature called Usage-Based Optimization. This feature is used to design aggregations based on actual user queries using…
- Finding and killing SSAS SessionsIf you have a reasonably large Analysis Services implementation with users running adhoc queries via multiple tools (ProClarity, Excel, etc...) then you…