Implementing Scale-Out of SQL Server Analysis Services
Scalability describes a system's ability to utilize additional resources for an increase in system capacity to perform additional work. The system capacity is important in achieving maximum scalability. There are two types of Scalability: 'scale-up' and 'scale-out'.
- Scale-up: It enables the data platform to support the increasing numbers of users, or applications, taking SSAS abundance of internal optimization and performance tuning techniques to support the system resource utilization.
- Scale-out: It provides the path to inherent limitation in a scale-up architecture, increasing server performance by fine-tuning the worker threads, pre-allocation of memory, and disk resource allocation. It purely ...