Tag Archive For "Performance"
What is Super DAX?
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 your belt, you may already be familiar with some of the performance improvements that roll up under the term “Super …
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 now NUMA-Aware! Unfortunately, I don’t have any way to test this at the moment… but it certainly makes sense that …
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 asked if there was a way to confirm if this was the cause. The short answer is yes, absolutely! While …
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 Time) are “instance”-specific… meaning you need to select the name of the process for which you want to collect counter …
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 – …
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 …
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 …
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 …
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 the way. That’s certainly an over simplification but it gives you the general framework from which to build. Note: there …
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 (when the MDX Script is executed) and available via the global cache which greatly improves query response time. The first …