Analysis Services Configuration Properties
Analysis Services configuration properties are important for fine tuning your system. For example, to make query log behavior consistent with your requirements, you can set the relevant properties. All of the properties can be changed by using SQL Server Management Studio. For more information about configuration properties, see SQL Server 2005 Analysis Services (SSAS) Server Pro p erties. For more information about performance issues related to configuration properties, see the section “Tuning Server Resources” in the SQL Server 2005 Analysis Services Performance Guide.
In This Section
The following topics explain the various Analysis Services configuration properties:
| Topic | Description |
|---|---|
The general properties are both basic and advanced properties, and include properties that define the data directory, backup directory, and other server behaviors. |
|
The data mining properties control which data mining algorithms are enabled and which are disabled. By default, all of the algorithms are enabled. |
|
The DSO properties specify connections to remote and local server repositories, and to remote and local directories used to control locking. |
|
The feature properties pertain to product features, most of them advanced, including properties that control links between server instances. |
|
The file store properties are for advanced use only. They include advanced memory management settings. |
|
The lock manager properties define server behaviors pertaining to locking and timeouts. Most of these properties are for advanced use only. |
|
The log properties controls if, where, and how events are logged on the server. This includes error logging, exception logging, flight recorder, query logging, and traces. |
|
The memory properties control how the server uses memory. They are primarily for advanced use. |
|
The network properties control server behavior pertaining to networking, including properties that control compression and binary XML. Most of these properties are for advanced use only. |
|
The OLAP properties control cube and dimension processing, lazy processing, data caching, and query behavior. These include both basic and advanced properties. |
|
The security section contains both basic and advanced properties that define access permissions. This includes settings pertaining to administrators and users. |
|
The thread pool properties control how many threads the server creates. These are primarily advanced properties. |
See Also
Other Resources
Administering Analysis Services