SYBASE参数设置
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
SYBASE参数设置
主要修改参数为：
[Disk I/O]
number of devices=20
[Physical Memory]
total memory = 512000 ##数据库可用物理内存，以2k为单位
[Processors]
max online engines=2 ##CPU数
[U]
HPWG.cfg全文如下：
##################################################################### #########
#
# Configuration File for the Sybase SQL Server
#
# Please read the System Administration Guide (SAG)
# before changing any of the values in this file.
#
##################################################################### #########
[Configuration Options]
[General Information]
[Backup/Recovery]
recovery interval in minutes = DEFAULT
print recovery information = DEFAULT
tape retention in days = DEFAULT
[Cache Manager]
number of oam trips = DEFAULT
number of index trips = DEFAULT
procedure cache percent = DEFAULT
memory alignment boundary = DEFAULT
global async prefetch limit = DEFAULT
global cache partition number = DEFAULT
[Named Cache:default data cache]
cache size = DEFAULT
cache status = default data cache
cache replacement policy = DEFAULT
local cache partition number = DEFAULT [Meta-Data Caches]
number of open databases = DEFAULT number of open objects = DEFAULT
open object spinlock ratio = DEFAULT number of open indexes = DEFAULT
open index hash spinlock ratio = DEFAULT open index spinlock ratio = DEFAULT [Disk I/O]
allow sql server async i/o = DEFAULT
disk i/o structures = DEFAULT
page utilization percent = DEFAULT number of devices =20
disable disk mirroring = DEFAULT
disable character set conversions = 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 allow remote access = DEFAULT
number of remote logins = DEFAULT number of remote sites = DEFAULT
max number network listeners = 15
tcp no delay = DEFAULT
allow sendmsg = DEFAULT
syb_sendmsg port number = DEFAULT
[O/S Resources]
max async i/os per engine = 500
max async i/os per server = DEFAULT [Parallel Query]
number of worker processes = DEFAULT memory per worker process = DEFAULT max parallel degree = DEFAULT
max scan parallel degree = DEFAULT
[Physical Resources]
[Physical Memory]
#数据库可用物理内存，以2k为单位total memory = 512000
additional network memory = DEFAULT lock shared memory = DEFAULT
shared memory starting address = DEFAULT max SQL text monitored = DEFAULT [Processors]
max online engines = 2 #CPU数
min online engines = DEFAULT
[SQL Server Administration]
default database size = DEFAULT
identity burning set factor = DEFAULT allow nested triggers = DEFAULT
allow updates to system tables = DEFAULT print deadlock information = DEFAULT default fill factor percent = DEFAULT default exp_row_size percent = DEFAULT number of mailboxes = DEFAULT
number of messages = DEFAULT
number of alarms = DEFAULT
number of pre-allocated extents = DEFAULT event buffers per engine = DEFAULT
cpu accounting flush interval = DEFAULT i/o accounting flush interval = DEFAULT sql server clock tick length = DEFAULT runnable process search count = DEFAULT i/o polling process count = DEFAULT
time slice = DEFAULT
deadlock retries = DEFAULT
cpu grace time = 200
number of sort buffers = DEFAULT number of large i/o buffers = DEFAULT size of auto identity column = DEFAULT identity grab size = DEFAULT
page lock promotion HWM = DEFAULT page lock promotion LWM = DEFAULT page lock promotion PCT = DEFAULT housekeeper free write percent = 10