Properties Dialog Box - Processing Tab

Return to: Properties dialog box

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

The Processing tab enables you to change optimization settings.

Options

Read-ahead buffer size

Determines the maximum amount of data placed into memory during each read of the database. Setting this option as high as possible minimizes the number of disk accesses.

Default: 4 megabytes (MB).

To change the read-ahead buffer size

1. In the Read-ahead buffer size box, specify the buffer size in MB. Only integers are valid.
2. Click OK.

Process buffer size

Determines how much data is processed in memory before an input/output (I/O) is performed. The larger the value, the fewer I/Os are required.

Default: 4 MB.

To change the process buffer size

1. In the Process buffer size box, specify the buffer size in MB. Only integers are valid.
2. Click OK.

OLE DB timeout

Determines the maximum time Microsoft® SQL Server™ OLAP Services waits for a response from a data source before it stops attempting to connect.

This option may be overridden by the timeout defined for the data source. If in the Data Link Properties dialog box, in the Advanced tab, a connect timeout value is specified for the data source, and the value in Connect timeout is shorter than the value in OLE DB timeout, the value in Connect timeout is used. If a value in Connect timeout is not specified, or it is longer than the value in OLE DB timeout, the value in OLE DB timeout is used.

Default: 0 (disabled).

Valid range: 0 (disabled) - 10,000 seconds (approximately 2 hours, 46 minutes).

To enable the OLE DB timeout

1. Select the OLE DB timeout check box.
2. In the Seconds box, specify the amount of time that elapses between an attempt to connect and timeout. Only integers are valid.
3. Click OK.