SSAS Tabular - NUMA and CPU Cores Performance
User Rating: / 1
PoorBest 
Written by Alex Whittles   
Tuesday, 17 December 2013 22:28

n my last post (SSAS Tabular Performance - DefaultSegmentRowCount) I presented some analysis of the query performance impact of changing the DefaultSegmentRowCount setting. This post describes the next tests that I ran on the same system, investigating the impact of restricting SSAS to just 1 NUMA node instead of the 2 avaiable on the server. It's well known that SSAS Tabular is not NUMA aware, so it's common to see advice recommending affiliating SSAS to a single NUMA node to improve performance.

Read more...

 

 

Pyramid Analytics