Chapter 21

Analysis Services Administration and Performance Tuning


  • Overview of the Two Types of Analysis Services Instances
  • Administer the SSAS Server Properties
  • Performance Tune SSAS
  • Secure an SSAS Instance

Now that you’ve learned how to administer SSAS, you will now continue your exploration of business intelligence administration and performance tuning by looking at how the DBA can perform Analysis Services administrative and performance tuning tasks. The focus is on the regular activities that a DBA may be called upon to perform, rather than the various details that developers might perform. First, take a quick tour of Analysis Services so that you have some common frame of reference for both the covered administrative and optimization aspects. Next, you look at the administration of the Analysis Server, including reviewing server settings and required services. You 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 can 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 turn next to the administration ...

Get Professional Microsoft SQL Server 2012 Administration now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.