Processing Tab (Properties Dialog Box)
Use this tab to change optimization settings.
Options
Read-ahead buffer size
Set 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, in the Read-ahead buffer size box, specify the buffer size in MB. Only integers are valid.
Process buffer size
Set how much data is processed in memory before an I/O is performed. The larger the value, the fewer the I/Os.
Default: 4 MB.
To change the process buffer size, in the Process buffer size box, specify the buffer size in MB. Only integers are valid.
Server timeout
Set the maximum time Microsoft® SQL Server™ 2000 Analysis Services waits for a reply from a query to the data source when an object is processed. If the Server timeout check box is selected and the specified time elapses without a reply, a timeout occurs, and processing fails.
Default: 0 (disabled).
Valid range: 0 (disabled) - 1,000,000 seconds (approximately 11 days, 13 hours, 46 minutes).
To enable a server timeout, select the Server timeout check box. Then, in the Seconds box, specify the amount of time that elapses between submission of a query and timeout. Only integers are valid.