In a recent post, I mentioned something called Super DAX without giving it a very detailed explanation. If you’ve been working with SSAS for a few years and have a couple of Tabular projects under … Continue reading What is Super DAX?
Analysis Services Tabular Is (Finally) NUMA-Aware!
Wow, right on the heals of Azure AS and just when you thought things couldn’t get any better for SSAS geeks of the world… Microsoft releases SP1 for SQL Server 2016… an voila, Tabular is … Continue reading Analysis Services Tabular Is (Finally) NUMA-Aware!
How to Detect Locking and Blocking In Your Analysis Services Environment
This past weekend, after one of my presentations on Analysis Services at SQL Saturday 520, an attendee described a performance issue in his environment that he thought could be related to locking and blocking and … Continue reading How to Detect Locking and Blocking In Your Analysis Services Environment
Choosing the Right Instance in Perfmon
There’s been quite a bit posted on this blog regarding the collection of perfmon counters to monitor Analysis Services instances and troubleshoot performance problems. And some of the recommended perform counters (e.g. Process: % Processor … Continue reading Choosing the Right Instance in Perfmon
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 … Continue reading Performance Monitoring for SSAS – Extended Events Cheat Sheet
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 … Continue reading Performance Monitoring for Analysis Services – Data Collection
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 … Continue reading 3 Methods for Shredding Analysis Services Extended Events
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 … Continue reading Performance Monitoring for Analysis Services – Part1
PSA: Stop Putting Sorts in SSIS Data Flows…
…or any fully-blocking transforms for that matter. SSIS 101 The primary function of SSIS is to move data from location A to location B with the option of performing transformations to the data along … Continue reading PSA: Stop Putting Sorts in SSIS Data Flows…
MDX Script: Calculated Members (vs Named Sets)
In the previous blog post I discussed the benefits of defining MDX calculations in the cube (instead of in the query using the WITH-clause). The primary benefit was having named sets computed ahead of time … Continue reading MDX Script: Calculated Members (vs Named Sets)