O'Reilly logo

Professional Microsoft SQL Server 2014 Administration by Brian Knight, Ross LoForte, Steven Wort, Bradley Ball, Adam Jorgensen

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

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