…brew your own Business Intelligence

Posts Tagged ‘Performance’

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 […]

Read more

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 […]

Read more

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 […]

Read more

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 […]

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

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

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 […]

Read more

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 […]

Read more

MDX Performance Tip: Move Calculations From the Query to the MDXScript

In the world of business intelligence, most people prefer to embed as much business logic as possible into the ETL and materialize it in the data model (i.e. data mart, cube, tabular model, etc). After all, if we can take the hit during our batch processing window – then that’s […]

Read more