|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > sp_Configure Options - DQL 7.0 vs. SQL 2000
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
sp_Configure Options - DQL 7.0 vs. SQL 2000
|
|
| J Delaney 2002-11-20, 6:23 am |
| I have gone through a long tunning process with SQL 7.0 in terms of a few
sp_configure options. Specifically:
sp_configure 'max degree of parallelism', '0'
sp_configure 'priority boost', '0'
sp_configure 'max worker threads', '256'
sp_configure 'min server memory (MB)', 0
sp_configure 'max server memory (MB)', -1
sp_configure 'set working set size', 0
We are now ready to upgrade to SQL 2000. The question I have is how do the
above configuration options relate to SQL 2000?
| |
| linda deng[MS] 2002-11-21, 9:23 am |
| Hi,
It is recommended that you keep the default value for these server options.
The default values for these options are:
'max degree of parallelism', '0'
'priority boost', '0'
'max worker threads', '256'
'min server memory (MB)', 0
'max server memory (MB)', 2147483647
'set working set size', 0
By default, SQL Server automatically adjusts the total amount of the memory
resources it will use. For more information on these options, please refer
to Microsoft SQL Server Books Online.
Sincerely,
Linda Deng
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
|
|
|
|
|