This year I’ve spent quite a bit of time tracing Analysis Services events. In the lab, my goto has always been SQL Profiler for it’s mere simplicity. At clients, I usually take the extra step … Continue reading Extended Events for Analysis Services
ADLC: Final Thoughts
This is the 7th, and final, post in a series of posts covering the Aggregation Design Life-Cycle (ADLC). Introduction Create Initial Aggregation Designs Remove Ineffective Aggregations Capture Query Workload Run Usage-Based Optimization (UBO) Wizard Create … Continue reading ADLC: Final Thoughts
ADLC Step 5: Create Custom Aggregations
This is the sixth post in a series of posts covering the Aggregation Design Life-Cycle (ADLC). Introduction Create Initial Aggregation Designs Remove Ineffective Aggregations Capture Query Workload Run Usage-Based Optimization (UBO) Wizard Create Custom Aggregations … Continue reading ADLC Step 5: Create Custom Aggregations