February 10, 2014 at 5:26 am
Hi all,
I've got a script that pulls config values out of the SysConfigures/SysCurConfigs tables, and I'd like to export the same settings (by runnning EXEC SP_Configure) to the new 2K8 server. Do any config settings exist in SS2K8 under different names? Any best practices/gotcha's???
Here's a list....
affinity mask
allow updates
awe enabled
c2 audit mode
cost threshold for parallelism
Cross DB Ownership Chaining
cursor threshold
default full-text language
default language
fill factor (%)
index create memory (KB)
lightweight pooling
locks
max degree of parallelism
max server memory (MB)
max text repl size (B)
max worker threads
media retention
min memory per query (KB)
min server memory (MB)
nested triggers
network packet size (B)
open objects
priority boost
query governor cost limit
query wait (s)
recovery interval (min)
remote access
remote login timeout (s)
remote proc trans
remote query timeout (s)
scan for startup procs
set working set size
show advanced options
two digit year cutoff
user connections
user options
February 10, 2014 at 8:43 am
I don't recall any of those having changed but you'll have to review the appropriateness of each setting for your new setup.
I've seen quite a few old SQL 2000 instances with "priority boost" enabled. I'd make sure that's turned off now.
You'll need to consider the min and max memory sizes on your new server.
Max degrees of parallelism will need checking. Current recommendations vary slightly but its normally 4 or (Numa nodes / CPU) up to a maximum of 8.
Best to check your local security policy for settings like Lock Pages in Memory etc.
Finally, is it worth considering skipping to SQL2012 and saving a future migration?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply