…brew your own Business Intelligence

Archive for December 2015

Implementing a Data Strategy and Roadmap

At the very last minute (just before unplugging for the holiday break) I decided to attend a workshop hosted by Georgia chapter of Data Management International (DAMA-GA)…and what a good decision that turned out to be! I’d be lying if I told you I was looking forward to this event. […]

Read more

Performance Monitoring for Analysis Services – Data Collection

Welcome back! This is the second post in a series of posts focusing on performance monitoring for Analysis Services. Performance Monitoring for SSAS – Intro Performance Monitoring for SSAS – Data Collection Performance Monitoring for SSAS – Extended Events Cheat Sheet Performance Monitoring for SSAS – Perfmon Counter Cheat Sheet Performance […]

Read more

3 Methods for Shredding Analysis Services Extended Events

Troubleshooting Analysis Services performance issues is hard. In complex and/or high concurrency environments (e.g. scale-out solutions) it can be a nightmare. Throw in a transient issue (i.e. one that can’t be reproduced on command or at some predictable time) that only occurs in production and you’re only option is to […]

Read more