…brew your own Business Intelligence

Archive for May 2013

ADLC Step 4: Run Usage-Based Optimization (UBO) Wizard

This is the fifth 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 previous post, we discussed how to configure the Query Log table […]

Read more

ADLC Step 3: Capture Query Workload

This is the fourth 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 previous post, we discussed the characteristics of effective/ineffective aggregations and why […]

Read more

ADLC Step 2: Remove Ineffective Aggregations

This is the third 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 previous post, we discussed the process for creating the initial set […]

Read more