Server Architecture (Analysis Services)
The server component of Microsoft SQL Server 2005 Analysis Services (SSAS) is the msmdsrv.exe application, which ordinarily runs as a Windows service. This application consists of security components, an XML for Analysis (XMLA) listener component, a query processor component and numerous other internal components that perform the following functions:
- Parsing statements received from clients
- Managing metadata
- Handling transactions
- Processing calculations
- Storing dimension and cell data
- Creating aggregations
- Scheduling queries
- Caching objects
- Managing server resources
Note
Fore more information, see the SQL Server 2005 Analysis Services Performance Guide.
XMLA Listener
The XMLA listener component handles all XMLA communications between Analysis Services and its clients. The Analysis Services Port configuration setting in the msmdsrv.ini file can be used to specify a port on which an Analysis Services instance listens. A value of 0 in this file indicates that Analysis Services listen on the default port. Unless otherwise specified, Analysis Services uses the following default TCP ports:
| Port | Description |
|---|---|
2725 |
Existing instances of SQL Server 2000 Analysis Services. |
2383 |
Default instance of SQL Server 2005 Analysis Services. |
2382 |
Redirector for other instances of SQL Server 2005 Analysis Services. |
Dynamically assigned at server startup |
Named instance of SQL Server 2005 Analysis Services. |
See Also
Tasks
Specifying and Restricting Ports
Concepts
Analysis Services Architecture
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
14 April 2006 |
|