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

General Properties

The general properties are both basic and advanced properties, and include properties that define the data directory, backup directory, and other server behaviors.

Data Mining Properties

The data mining properties control which data mining algorithms are enabled and which are disabled. By default, all of the algorithms are enabled.

DSO Properties

The DSO properties specify connections to remote and local server repositories, and to remote and local directories used to control locking.

Feature Properties

The feature properties pertain to product features, most of them advanced, including properties that control links between server instances.

Filestore Properties

The file store properties are for advanced use only. They include advanced memory management settings.

Lock Manager Properties

The lock manager properties define server behaviors pertaining to locking and timeouts. Most of these properties are for advanced use only.

Log Properties

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.

Memory Properties

The memory properties control how the server uses memory. They are primarily for advanced use.

Network Properties

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.

OLAP Properties

The OLAP properties control cube and dimension processing, lazy processing, data caching, and query behavior. These include both basic and advanced properties.

Security Properties

The security section contains both basic and advanced properties that define access permissions. This includes settings pertaining to administrators and users.

Thread Pool Properties

The thread pool properties control how many threads the server creates. These are primarily advanced properties.

See Also

Other Resources

Administering Analysis Services

Help and Information

Getting SQL Server 2005 Assistance