Professional Microsoft® SQL Server® 2008 Administration

Chapter 7. Analysis Services Administration and Performance Tuning

We continue our discussion of business intelligence administration and performance tuning by looking at how the DBA can perform Analysis Services administrative and performance tuning tasks. Our focus is the regular activities that a DBA may be called upon to perform, rather than the various details that may be performed by developers. First, you will take a quick tour of Analysis Services so that you have some common frame of reference for both the administrative and optimization aspects that are covered. Next, you'll look at the administration of the Analysis Server itself, including reviewing server settings and required services. You will also learn how to script various administrative activities such as moving an Analysis Services database from development to production and backing up an Analysis Services database. With that covered, you will review the management of the Analysis Services databases, including deployment, backup, restore, and synchronization, and then look at how you can monitor the performance of Analysis Services. Next is a look at administration of storage, including storage modes and configuring partitions, as well as the design of aggregations. With storage concepts in mind, you'll turn next to administration of processing tasks used to connect your designs with the data. Last, of course, you will learn how to configure security for Analysis Services.

A discussion of how to use Analysis ...