Home Dashboard Directory Help
Search

Analysis Services Tabular is not NUMA aware by Alex Whittles - Purple Frog


Status: 

Active


5
0
Sign in
to vote
Type: Suggestion
ID: 839732
Opened: 3/24/2014 1:48:04 AM
Access Restriction: Public
0
Workaround(s)
view

Description

SQL Server Analysis Services 2012 Tabular model is not NUMA aware. Testing evidence shows that adding a second NUMA node to SSAS Tabular decreases single query performance by up to 2x.
This significantly limits the scalability of the Tabular model, rendering it unsuitable for larger cubes.

http://www.purplefrogsystems.com/blog/2014/02/ssas-tabular-performance-numa-update/

There is also no mechanism available within SQL Server to assign the CPU/NUMA affinity in order to work around this problem and maximise cube performance.
Details
Sign in to post a comment.
Posted by Yitzhak Khabinsky on 3/24/2014 at 5:54 AM
SSAS shall support latest Intel Xeon E7 v2 processors, i.e. be fully multi NUMA aware, and support Intel Xeon E7 v2 high-memory capacity up to 4TB addressable RAM memory under Windows Server 2012 R2 OS.

Sign in to post a workaround.