…brew your own Business Intelligence

Archive for 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 […]

Read more

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 […]

Read more

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 […]

Read more