Archive: February 2014

  • SSAS Tabular performance – NUMA update

    How does the SSAS 2012 Tabular model performance change when you add more CPU sockets / NUMA nodes? In my last post (SSAS Tabular NUMA and CPU Cores Performance) I presented the results of some testing I’d been doing on the scalability of the SSAS 2012 Tabular model. Specifically with the performance of distinct count measures over large data volumes (50-200m distinct customers). The conclusion was that moving from 1 NUMA node (CPU socket)…

    » Read more
  • Renaming an SSAS Tabular Model

    I came across a frustrating problem today. I’d just finished processing a large tabular cube (SQL Server 2012), which had taken 11 hours in total. On trying to connect to the cube to test it, I’d made a schoolboy error; The database was named correctly, but the model inside it was named MyCubeName_Test instead of MyCubeName. No problem, I’ll just right click the cube in SSMS and rename it. Well, no, there is no option to rename…

    » Read more