Summary information |
|
|---|---|
Default value |
500 |
Range of values |
0–32767 |
Status |
Dynamic |
Display level |
Comprehensive |
Required role |
System Administrator |
Configuration group |
SQL Server Administration |
number of sort buffers specifies the number of 2K buffers used to hold pages read from input tables and perform index merges during sorts.
Sybase recommends that you leave this parameter set to the default except when you are creating indexes in parallel. Setting the value too high can rob non-sorting processes of access to the 2K buffer pool in caches being used to perform sorts.
If you configure a high number of sort buffers, a sort on a large table may require more procedure cache. The effect is more pronounced with tables that have smaller row sizes, because the number of rows per page is higher.
This equation estimates the amount of proc cache required:
Number of sort buffers X rows per page X 100
If you do not configure enough procedure cache for the number of sort buffers, the sort may fail with error message 701. If this occurs, reconfigure Adaptive Server with a lower number of sort buffers and retry the sort.
For more information on configuring this value for parallel create index statements, see “Caches, sort buffers, and parallel sorts” in the Performance and Tuning Guide: Optimizer and Abstract Plans.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
