Properties Dialog Box - Environment Tab

Return to: Properties dialog box

Other tabs: General, Processing, Query Log, Add-Ins.

The Environment tab enables you to change performance and memory settings.

Options

Maximum number of threads

Determines the number of threads that can simultaneously utilize the CPUs in the server computer.

Default: 2 times the number of CPUs in the server computer.

Valid range: 1-1000.

To change the maximum number of threads

1. In the Maximum number of threads box, specify the maximum number. Only integers are valid.
2. Click OK.

Large level defined as

Determines the minimum number of members a dimension level must contain to be processed as a “large” level.

Microsoft® SQL Server™ OLAP Services classifies dimension levels into “large” and “small” categories based on the number of level members. These two categories are processed differently. For example, large levels are not sent to the client unless they are specifically requested, but small levels are sent to the client even if the entire level is not requested.

Default: 1,000 members.

Valid range: 1-10,000 members.

To change the definition of large levels

1. In the Large level defined as box, specify the minimum number of members a dimension level must contain to be processed as a “large” level. Only integers are valid.
2. Click OK.

Minimum allocated memory

Determines the amount of memory allocated exclusively to OLAP Services. Actual memory usage may exceed this value.

Default: one-half of server computer’s memory.

To change the amount of memory allocated to OLAP Services

1. In the Minimum allocated memory box, specify the allocated memory in megabytes (MB). Only integers are valid.
2. Click OK.

Memory conservation threshold

Determines the memory threshold near which memory usage decreases. When the amount of memory used by OLAP Services approaches this threshold, usage decreases as memory management becomes more efficient. Actual memory usage may exceed this value unless the default value is used.

Default: all of server computer’s memory.

To change the threshold for memory usage

1. In the Memory conservation threshold box, specify the threshold in MB. Only integers are valid.
2. Click OK.