Report Portal

SSAS Tabular - NUMA and CPU Cores Performance

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...

Tags: performance, hardware

 

2007-2015 VidasSoft Systems Inc.