Professional Microsoft SQL Server 2014 Administration

Chapter 21Analysis Services Administration and Performance Tuning

WHAT'S IN THIS CHAPTER?

• Understanding the two types of Analysis Services instances
• Administering the SSAS server properties
• Performance-tuning SSAS

Now that you've learned how to administer SQL Server Integration Services (SSIS), you will now continue your exploration of business intelligence (BI) administration by looking at how the DBA can perform SQL Server Analysis Services (SSAS) administrative tasks. The focus of this chapter is on the regular activities that a DBA may be called upon to perform, rather than the various details that developers might perform.

This chapter first takes 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 learn about 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 an examination of the administration of storage (including storage modes and configuring partitions), as well as the design of aggregations. With storage ...