Entries Published On June, 2013
Extended Events for Analysis Services
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 of creating a server side trace (example) to reduce the “observer overhead”. Both of these options have served me well. …
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 Custom Aggregations Final Thoughts This post is a catch-all for additional considerations that should be factored in before, during, and …
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 Final Thoughts In the last post, we discussed the Usage-Based Optimization (UBO) Wizard and some of the factors that might …