Categories
Uncategorized

Analysis Services Class Libraries

References to these libraries are required when writing .NET applications that interface with Analysis Services. However, as I’m not a serious .NET developer (thank god! /jk /sortof) I don’t use them that much. But when I do, I usually waste the first 10 minutes searching for it in windows explorer before giving up and wasting another 5-10 minutes bingl’ing […]

Categories
Uncategorized

Performance Monitoring for SSAS – Extended Events Cheat Sheet

Welcome back! This is the 3rd 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 Monitoring for SSAS – […]

Categories
Uncategorized

Ever wondered what’s captured in the SSAS Flight Recorder?

During a recent engagement involving an Analysis Services health assessment, one of the things I noted was that the Flight Recorder was enabled. During the post-assessment review with the client, where we walked through the report and recommendations, I quickly explained what the Flight Recorder was, why it should be disabled (answer: never used, wasted […]

Categories
Uncategorized

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 Monitoring for SSAS – Extracting […]

Categories
Uncategorized

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 fire up some traces and […]

Categories
Uncategorized

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 with some new heavy hitters […]

Categories
Uncategorized

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. Throw in a few performance […]

Categories
Uncategorized

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 one of the (if not […]

Categories
Uncategorized

SSAS Tabular, Telerik, Multi-Value Parameters with DAX

Earlier this summer, I started working with a new client to develop the next version of their reporting platform. This client already had the reporting requirements and good jump start on the underlying data model but had run into some serious performance issues when trying to report directly from the relational data model using stored procedures. After some […]

Categories
Uncategorized

Automating SSAS Dump Collections using SQLDumper.exe

Last year I was involved with standing up an Analysis Services Scale-Out Query Server architecture to handle a heavy concurrent user load. Unfortunately, we didn’t get around to stress-testing the system until a few months later and we uncovered an issue requiring escalation to Microsoft. In this post, I’ll share a few details about the issue […]