物理内存：4G，数据库4G,日志库1G,临时库1.6G,下列的参数配置是否合理，SYBASE的内存使用，CACHE使用，引擎使用是否合理，谢谢！！
[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
[Unicode]
enable unicode normalization = DEFAULT
enable surrogate processing = DEFAULT
enable unicode conversions = DEFAULT
size of unilib cache = 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
内存的调整倒都不是很怎么样
tempdb 的绑定 我不知道有多少 好处.......
你的logcache是准备做什么？绑定用户数据库日志？
Hello_bluesky 回复于：2003-04-18 10:58:30
这个参数配置不是我做的，是别人的找我看看，我看到以后，有疑问才来请教各位老大的，有什么不合理的尽管提出来呀，多谢
Blackrose 回复于：2003-04-18 11:06:45
谈不上不合理
他这样配置也有他的道理
跑起来如果有问题，再找 瓶颈吧
alex2003 回复于：2003-04-18 17:08:45
和应用，环境有很大关系，所以不能简单的说配置好还是坏，要根据实际情况不断调整。
Hello_bluesky 回复于：2003-04-18 22:13:03
现在出现的问题是，读的速度挺快的，写的速度特别慢。
hawker 回复于：2003-04-20 00:16:57
问一下你的系统管理员，你的阵列的划分方式，如果是raid 0+1的话，可以考虑在操作系统级别将类似"write to mirror disk"这类开关关闭。
Blackrose 回复于：2003-04-21 10:43:50
观察一下 写入时 是否存在阻塞等情况？可以考虑表分区等方式缓解。
另外，让操作系统工程师做监控，看看 是否 io 已存在 瓶颈.......
|
