Chapter 8. Administering and Monitoring Analysis Services
In this chapter, we will cover:
- SSAS instance configuration options
- Creating and dropping databases
- Monitoring SSAS instance using Activity Viewer
- Monitoring SSAS instance using DMVs
- Cancelling a session
- Checking whether cubes are accessible
- Checking SSAS object sizes programmatically
- Backup and restore
- Synchronization
- Detaching and attaching databases
Introduction
As you have learned throughout the various chapters of this book, SQL Server Analysis Services (SSAS) is a data container in its own right, separate and apart from the SQL Server relational database engine. As such, SSAS has numerous configuration options, many of which alter its behavior. You can use dynamic management views, SQL Server ...
Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
