Analysis Services Instance Management
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. 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 xVelocity in-memory analytics engine (VertiPaq) 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.
[!NOT]
The exception is PowerPivot for SharePoint. Server administration of a PowerPivot deployment is always within the context of a SharePoint farm. PowerPivot differs from other server modes in that it is always single-instance, and always managed through SharePoint Central Administration or the PowerPivot Configuration Tool. Although it is possible to connect to PowerPivot for SharePoint in SQL Server Management Studio or SQL Server Veri Akışı Araçları (SSDT), it is not desirable. A SharePoint farm includes infrastructure that synchronizes server state and oversees server availability. Using other tools can interfere with these operations. For more information about PowerPivot server administration, see PowerPivot for SharePoint (SSAS).
In This Section
Link |
Task Description |
|---|---|
Describes the required and optional tasks that complete or modify an installation of Analysis. |
|
Describes connection string properties, client libraries, authentication methodologies, and steps for establishing or clearing connections. |
|
Describes tools and techniques for monitoring a server instance, including how to use Performance Monitor and SQL Server Profiler. |
|
Explains how to automate many administrative tasks, including processing. |
Ayrıca bkz.
Kavramlar
Comparing Tabular and Multidimensional Solutions (SSAS)
PowerPivot Configuration Tools
PowerPivot Server Administration and Configuration in Central Administration