Microsoft® SQL Server® 2012 Bible

1223

CHAPTER

54

Confi guring and Administering

Analysis Services

IN THIS CHAPTER

Installing Analysis Services

How to Confi gure Analysis Services Settings

Exploring Advanced Analysis Services Deployments

Evaluating Analysis Services Performance

T

he 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 impor-

tant enabler of these impressive data retrieval capabilities are Analysis Services storage engine

optimizations, most notably Aggregations.

Installing Analysis Services

This section details the various ways in which Analysis Services may be installed along with key

options available within the different modes supported.

Analysis Services, in this release, supports three different modes of operation. These modes include

Multidimensional and Data Mining (the default mode), Tabular, and PowerPivot for SharePoint. As

a result, ensuring the correct mode is selected during installation is important because the only

available option to change the mode is to uninstall and reinstall Analysis Services selecting the

wanted mode. These server modes ultimately determine which features will be installed for use, and

as might be guessed, they each support different usage scenarios.

See the Microsoft Technet article Feature by Server Mode or Solution Type (SSAS) at http://msdn

.microsoft.com/en-us/library/hh212940.aspx for details about the various features

supported by each of the Analysis Services server modes.

c54.indd 1223c54.indd 1223 7/31/2012 10:31:01 AM7/31/2012 10:31:01 AM

http://www.it-ebooks.info