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.

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.