O'Reilly logo

Professional Microsoft® SQL Server® 2008 Administration by Steven Wort, Ross LoForte, Wayne Snyder, Ketan Patel, Brian Knight

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

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

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