Categories
Uncategorized

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

Categories
Uncategorized

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

Categories
Uncategorized

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

Categories
Uncategorized

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 and generate a query workload […]

Categories
Uncategorized

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 it is important to remove […]

Categories
Uncategorized

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 of aggregation designs which, from […]

Categories
Uncategorized

ADLC Step 1: Create Initial Aggregation Designs

This is the second 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 aggregations at a basic level…what they are, why we need them…and then […]

Categories
Uncategorized

Aggregation Design Life-Cycle: Introduction

This is the first 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 When it comes to maximizing Analysis Services query performance, nothing beats a solid dimensional data model with appropriately […]

Categories
Uncategorized

How To: Create a Copy of an Existing Aggregation Design

During the development and on going maintenance of a SSAS database, there are times when you’ll want to have a backup copy of an existing aggregation design.  The primary use case to consider is when you are creating customized aggregations (either manually or via the Usage-Based Optimization Wizard).  By having a backup copy of the […]

Categories
Uncategorized

Passed 70-466 and 70-467 Exams + Study Guides

Earlier this month, I passed the following two exams putting me 1 away (70-462) from the MCSE Business Intelligence certification. 70-466 – Implementing Data Models and Reports with Microsoft SQL Server 2012 70-467 – Designing Business Intelligence Solutions with Microsoft SQL Server 2012 Below is an outline of the material I worked through in preparation for these […]