…brew your own Business Intelligence

Archive for 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

DAX: Performance Gains via Aliases and Variables

  Consider the following DAX snippet: SWITCH ( TRUE() ,SUM(‘Internet Sales'[Sales Amount]) > 1000000, “A” ,SUM(‘Internet Sales'[Sales Amount]) > 100000, “B” ,”C” ) Very straightforward, right? If the sum of sales amount is > 1mm, return “A”… if its between 1mm and 100k, return “B”… otherwise, return “C”. Note: SWITCH-statements […]

Read more

Reflections: SQL Saturday 452 (Charlotte BI Edition)

This past weekend, I drove up to Charlotte, NC to attend what has become one of my favorite SQL Saturdays on the east coast. The folks at CBIG (the local SQL Server Business Intelligence user group) are always super-enthusiastic and have done a fantastic job growing this event into what […]

Read more

PowerShell Scripts for Collecting SSAS-related Perfmon and xEvent Trace Data

Here are two more PowerShell scripts I’ve been using for a while now to collect SSAS-related performance data. Each script is structured as a PowerShell function w/ a single call at the bottom of the script so that they can be executed ad-hoc. One cool thing about these scripts is […]

Read more

Accessing SSAS Instance Configuration Info via Powershell

Over the past few months I’ve been working on a lot of scripts for collecting SSAS-related configuration and performance information. So far, most of the scripting has been done via PowerShell (which I’m really starting to appreciate) but on a few rare occasions I’ve had to dip my toes into […]

Read more

Quickly Analyze Large Objects in #SSAS Databases with WinDirStat

There are tons of solid free tools out there that make life much easier for SSAS developers. A while ago, I blogged about the Top FREE tools for SSAS 2012 Developers most of which I still use on a daily basis. But even that list is getting a bit stale […]

Read more

Troubleshooting #SSAS Performance Issues

For the past 2 years, I’ve spent quite a bit of time across several clients addressing performance issues with Analysis Services solutions. Now that may sound like your own personal hell, and I totally understand why. Analysis Services is complicated enough just to get it off the ground and into production. […]

Read more

Performance Monitoring for Analysis Services – Part1

One of the really cool benefits of being a Linchpin Teammate, besides working with some wicked smart SQL-people, is getting to participate in the Notes From the Field series over at site SQLAuthority.com. Note: SQLAuthority.com is a site that was built by Pinal Dave (b | t) and has become […]

Read more