[Named Cache:default data cache]
cache size = 1000M
cache status = default data cache
cache replacement policy = DEFAULT
local cache partition number = DEFAULT
[16K I/O Buffer Pool]
pool size = 200.0000M
wash size = DEFAULT
local async prefetch limit = DEFAULT
[Named Cache:logcache]
cache size = 200M
cache status = log only
cache replacement policy = DEFAULT
local cache partition number = DEFAULT
[Named Cache:tempdb_cache]
cache size = 500M
cache status = mixed cache
cache replacement policy = DEFAULT
local cache partition number = DEFAULT
[Named Cache:tempdbcache]
cache size = 200M
cache status = mixed cache
cache replacement policy = DEFAULT
local cache partition number = DEFAULT
[Meta-Data Caches]
number of open databases = DEFAULT
number of open objects = 5000
open object spinlock ratio = DEFAULT
number of open indexes = 5000
open index hash spinlock ratio = DEFAULT
open index spinlock ratio = DEFAULT
partition groups = DEFAULT
partition spinlock ratio = DEFAULT
[Disk I/O]
disk i/o structures = DEFAULT
number of large i/o buffers = DEFAULT
page utilization percent = DEFAULT
number of devices = 20
disable disk mirroring = DEFAULT
allow sql server async i/o = DEFAULT
[Languages]
disable character set conversions = DEFAULT
[Network Communication]
default network packet size = DEFAULT
max network packet size = DEFAULT
remote server pre-read packets = DEFAULT
number of remote connections = DEFAULT
number of remote logins = DEFAULT
number of remote sites = DEFAULT
max number network listeners = DEFAULT
tcp no delay = DEFAULT
allow sendmsg = DEFAULT
syb_sendmsg port number = DEFAULT
allow remote access = DEFAULT
[O/S Resources]
max async i/os per engine = DEFAULT
max async i/os per server = DEFAULT
[Parallel Query]
number of worker processes = 15
memory per worker process = DEFAULT
max parallel degree = DEFAULT
max scan parallel degree = DEFAULT
[Physical Resources]
[Physical Memory]
max memory = 1164000
additional network memory = DEFAULT
shared memory starting address = DEFAULT
allocate max shared memory = DEFAULT
dynamic allocation on demand = DEFAULT
lock shared memory = DEFAULT
heap memory per user = DEFAULT
[Processors]
max online engines = DEFAULT
number of engines at startup = DEFAULT
Blackrose 回复于:2003-04-17 13:52:07
为什么要设置
number of worker processes = 15
你是准备使用并行?如果是,应该相应设置
max parallel degree = DEFAULT
max scan parallel degree = DEFAULT
这两个值
Hello_bluesky 回复于:2003-04-17 14:45:43
我有两个CPU,应该怎么设置?
default data cache、logcache、tempdb_cache和tempdbcache的大小设置合理吗?
Blackrose 回复于:2003-04-17 17:52:37
可以配到2或者3看看
max parallel degree = 2
max scan parallel degree = 2