Chapter 54

Configuring and Administering Analysis Services

In This Chapter

Installing Analysis Services

How to Configure Analysis Services Settings

Exploring Advanced Analysis Services Deployments

Evaluating Analysis Services Performance

The focus of this chapter is on deploying and administering a SQL Server Analysis Services Server. Key new SQL Server Analysis Services features require your attention, which are also discussed. Analysis Services provides a specialized storage and query engine optimized for handling queries that often require large result sets to be scanned and aggregated. An important enabler of these impressive data retrieval capabilities are Analysis Services storage engine optimizations, most notably Aggregations.

Get Microsoft SQL Server 2012 Bible 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.