Analysis Services Instance Management
Applies To: SQL Server 2016
An instance of Analysis Services is a copy of the msmdsrv.exe executable that runs as an operating system service. Each instance is fully independent of other instances on the same server, having its own configuration settings, permissions, ports, startup accounts, file storage, and server mode properties.
Each instance of Analysis Services runs as Windows service, Msmdsrv.exe, in the security context of a defined logon account.
The service name of default instance of Analysis Services is MSSQLServerOLAPService.
The service name of each named instance of Analysis Services is MSOLAP$InstanceName.
Multi-instance means that you can scale-up by installing multiple server instances on the same hardware. For Analysis Services in particular, it also means that you can support different server modes by having multiple instances on the same server, each one configured to run in a specific mode.
Server mode is a server property that determines which storage and memory architecture is used for that instance. A server that runs in Multidimensional mode uses the resource management layer that was built for multidimensional cube databases and data mining models. In contrast, Tabular server mode uses the VertiPaq in-memory analytics engine and data compression to aggregate data as it is requested.
Differences in storage and memory architecture mean that a single instance of Analysis Services will run either tabular databases or multidimensional databases, but not both. The server mode property determines which type of database runs on the instance.
Server mode is set during installation when you specify the type of database that will run on the server. To support all available modes, you can install multiple instances of Analysis Services, each deployed in a server mode that corresponds to the projects you are building.
As a general rule, most of the administrative tasks you must perform do not vary by mode. As an Analysis Services system administrator, you can use the same procedures and scripts to manage any Analysis Services instance on your network regardless of how it was installed.
|Post-install Configuration (Analysis Services)||Describes the required and optional tasks that complete or modify an installation of Analysis.|
|Connect to Analysis Services||Describes connection string properties, client libraries, authentication methodologies, and steps for establishing or clearing connections.|
|Monitor an Analysis Services Instance||Describes tools and techniques for monitoring a server instance, including how to use Performance Monitor and SQL Server Profiler.|
|Script Administrative Tasks in Analysis Services||Explains how to automate many administrative tasks, including processing.|
|Globalization scenarios for Analysis Services||Explains language and collation support, steps for changing both properties, and tips for setting and testing language and collation behaviors.|
|Log operations in Analysis Services||Describes the logs and explains how to configure them.|
Comparing Tabular and Multidimensional Solutions (SSAS)
Power Pivot Configuration Tools
Power Pivot Server Administration and Configuration in Central Administration
Determine the Server Mode of an Analysis Services Instance