Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By : Satya Shyam K Jayanty
Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By: Satya Shyam K Jayanty

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2008 R2 Administration Cookbook
Credits
Foreword
About the Author
Acknowledgment
About the Reviewers
www.PacktPub.com
Preface
More DBA Manageability Best Practices

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 depends on the technology limits of Symmetric Multi-Processing (SMP) scalability.

While most server applications today can scale up to eight logical processors, it is possible to ramp up Analysis Services with 16, or 32 logical processors. This...