SQL Server 2016 gets improved analysis performance and scalability in Service Pack 1

The SQL Server 2016 Analysis Services were updated to Service Pack 1 (SP1) with a list of new feature improvements. This update brought better modeling performance processing for tables, and increased query efficiency across the board. Here’s what they’ve added in SQL Server 2016 SP1 Analysis Services:

  • NUMA awareness – For better NUMA support, the in-memory (VertiPaq) engine inside Analysis Services SP1 maintains a separate job queue on each NUMA node. This means that the segment scan jobs run on the same node where the memory is allocated for the segment data. Note, NUMA awareness is only enabled by default on systems with at least four NUMA nodes. On two-node systems, the costs of accessing remote allocated memory generally doesn’t warrant the overhead of managing NUMA specifics.
  • Memory allocation – Analysis Services SP1 uses an Intel TBB-based scalable allocator that provides separate memory pools for every core. As the number of cores increases, the system can scale almost linearly.
  • Heap fragmentation – The Intel TBB-based scalable allocator is also expected to help mitigate performance problems due to heap fragmentation that have been shown to occur with the Windows Heap. For more information, see the Intel TBB product brief at https://software.intel.com/sites/products/collateral/hpc/tbb/Intel_tbb4_product_brief.pdf.

According to the announcement blog, you should be seeing significant gains in performance and scalability while using this service pack with larger enterprise servers. You can download the updated SQL Server 2016 SP1 Analysis Services by visiting the Microsoft Download Center as of today.

Share This
Further reading: , ,