Chapter 7: Analysis Services Administration and Performance Tuning


Overview

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.

Note

A discussion of how to use Analysis Services from a developer's prospective is beyond the scope of this book, so we will not examine that issue here. If you're interested in learning more, see Professional SQL Server Analysis Services with MDX, by Sivakumar Harinath and Stephen R. Quinn (Wrox, 2006).



Professional SQL Server 2005 Administration
Professional SQL Server 2005 Administration (Wrox Professional Guides)
ISBN: 0470055200
EAN: 2147483647
Year: 2004
Pages: 193

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net