Chapter 7

Administration and Management

What's in this chapter?

  • Administering Analysis Services with Management Studio
  • Backing up your databases
  • Basic Analysis Services database maintenance
  • Monitoring Analysis Services databases
  • Administering Analysis Services programmatically with AMO

Administration is an important task on any server product. As an administrator of SQL Server Analysis Services (SSAS) you need to make sure Analysis Services is secure and reliable, and provides efficient access to the end users. You can administer Analysis Services in two ways: through the SQL Server 2012 Tool set — SQL Server Management Studio (SSMS) and SQL Server Data Tools (SSDT) — or programmatically using an object model called Analysis Management Objects (AMO).

In Analysis Services 2012 you now have the option to run SSAS in tabular or multidimensional mode. Multidimensional mode is what was available in SSAS 2005/2008/2008r2. Sometimes you may hear this referred to as UDM, MOLAP, or legacy SSAS mode. Tabular mode uses the VertiPaq in-memory engine instead of the traditional SSAS engine; if you worked with PowerPivot for Excel/SharePoint, this is the same engine updated from personal and corporate BI applications to Enterprise applications. Now in SQL Server 2012 you have the ability to use the VertiPaq engine outside of Excel or SharePoint.

Management operations on multidimensional and tabular Analysis Services are different. If Analysis Services runs in tabular mode, you have the following ...

Get Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX now with the O’Reilly learning platform.

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