Configuration Options (Level 1)
Administrative scripts may have used these configuration options. For more information about configuration options, see Setting Configuration Options.
| SQL Server 6.x | SQL Server 2000 |
|---|---|
| backup buffer size specified the size of the dump and load buffer (used to increase backup speed). | Removed; no longer supported. Remove all references to backup buffer size. |
| backup threads specified the number of threads to be reserved for striped dump and load operations. | Removed; no longer supported. Remove all references to backup threads. |
| database size set the default number of megabytes (MB) allocated to each new user database. | Removed; no longer supported. Remove all references to database size. |
| free buffers determined the threshold of free buffers available to the system. | Removed; no longer supported. Remove all references to free buffers. |
| hash buckets set the number of buckets used for hashing pages to buffers in memory. | Removed; no longer supported. Remove all references to hash buckets. |
| LE threshold maximum determined the maximum number of page locks to hold before escalating to a table lock. | Removed; no longer supported. Remove all references to LE threshold maximum. |
| LE threshold minimum determined the minimum number of page locks required before escalating to a table lock. | Removed; no longer supported. Remove all references to LE threshold minimum. |
| LE threshold percent specified the percentage of page locks needed on a table before a table lock is requested. | Removed; no longer supported. Remove all references to LE threshold percent. |
| logwrite sleep specified the number of milliseconds that a write to the log will be delayed if the buffer is not full. | Removed; no longer supported. Remove all references to logwrite sleep. |
| max lazywrite IO tuned the priority of batched asynchronous I/O operations performed by the lazy writer. | Removed; no longer supported. Remove all references to max lazywrite IO. |
| memory set the size of available memory, in 2K units. | Removed; no longer supported. Memory is configured automatically based on need and available memory. To control the range of memory configured automatically, use the min server memory and max server memory options. Remove all references to memory. |
| open databases set the maximum number of databases that can be open at one time on SQL Server. | Removed; no longer supported. Remove all references to open databases. |
| procedure cache specified the percentage of memory allocated to the procedure cache after the SQL Server memory needs are met. | Removed; no longer supported. Remove all references to procedure cache. |
| RA cache hit limit specified the number of cache hits that a read-ahead request could have before it was canceled. | Removed; no longer supported. Remove all references to RA cache hit limit. |
| RA cache miss limit specified the number of cache misses that occurred during a horizontal traversal before read-ahead started for that command. | Removed; no longer supported. Remove all references to RA cache miss limit. |
| RA delay specified the delay of read-ahead, in milliseconds. | Removed; no longer supported. Remove all references to RA delay. |
| RA pre-fetches determined how far ahead the read-ahead manager read (on an extent basis) before the pre-fetch manager idled. | Removed; no longer supported. Remove all references to RA pre-fetches. |
| RA slots per thread specified the number of simultaneous requests each read-ahead service thread managed. | Removed; no longer supported. Remove all references to RA slots per thread. |
| RA worker threads specified the number of threads used to service read-ahead requests. | Removed; no longer supported. Remove all references to RA worker threads. |
| recovery flags determined what information SQL Server displayed in the error log during recovery. | Removed; no longer supported. Remove all references to recovery flags. |
| remote conn timeout specified a time limit to break a server-to-server connection. | Removed; no longer supported. Remove all references to remote conn timeout. |
| SMP concurrency specified the maximum number of CPUs that would be used by SQL Server. | Removed; no longer supported. Remove all references to SMP concurrency. |
| sort pages specified the maximum number of pages to be allocated to sorting per user. | Replaced by min memory per query. For more information about the min memory per query option, see Server Memory Options.
Replace all references of sort pages with min memory per query and index create memory. |
| tempdb in ram placed the tempdb database in RAM, if needed. | No longer supported because SQL Server 2000 has been optimized for maximum performance.
Remove all references to tempdb in ram. |
| trace flag 204 supported queries containing sort columns in the ORDER BY clause not included in the select list when the DISTINCT keyword was supplied. | No longer supported. Remove all references to trace flag 204. For more information about supported trace flags, see Trace Flags. |
| user connections set the maximum number of simultaneous connections to SQL Server allowed. | Now an advanced option. Default value of 0 indicates automatic growth. Remove all references to user connections. |
For more information about other changes to configuration options, see SQL Server 2000 and SQL Server version 7.0.