O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required