Professional SQL Server™ 2005 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 will be on the regular activities that a DBA may be called upon to perform rather than discussing the various details that may be performed by developers. First, we will take a quick tour of Analysis Services so that you will have some common frame of reference for both the administrative and optimization aspects that will be covered. Next, we'll look at the administration of the Analysis Server itself, including reviewing server settings and required services. We will also address 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, we 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, we will look at administration of storage, including storage modes and configuring partitions, as well as discussing the design of aggregations. With storage concepts in mind, we will turn next to administration of processing tasks used to connect our designs with the data. Last, of course, we will discuss how to configure security for Analysis Services. ...