优化sybase数据库.cfg

number of oam trips = DEFAULT
number of index trips = DEFAULT
procedure cache percent = DEFAULT
memory alignment boundary = DEFAULT
[Named Cache:default data cache]
disable character set conversions = DEFAULT
[Network Communication]
default network packet size = DEFAULT
max network packet size = DEFAULT
remote server pre-read packets = DEFAULT
##############################################################################
#
# Configuration File for the Sybase SQL Server
#
# Please read the System Administration Guide (SAG)
[General Information]
[Backup/Recovery]
recovery interval in minutes = DEFAULT
print recovery information = DEFAULT
tape retention in days = DEFAULT
[Cache Manager]
table lock spinlock ratio = DEFAULT
[User Environment]
#user connections
number of user connections = 500
stack size = DEFAULT
stack guard size = DEFAULT
systemwide password expiration = DEFAULT
tcp no delay = DEFAULT
allow sendmsg = DEFAULT
syb_sendmsg port number = DEFAULT
[O/S Resources]
max async i/os per engine = DEFAULT
max async i/os per server = DEFAULT
permission cache entries = DEFAULT
user log cache size = DEFAULT
user log cache spinlock ratio = DEFAULT
[Lock Manager]
# lock for table
number of locks = 10000
# before changing any of the values in this file.
#
##############################################################################
[Configuration Options]
[Processors]
#max engines database
max online engines = 1
min online engines = DEFAULT
[SQL Server Administration]
number of open objects = DEFAULT
number of open databases = DEFAULT
size of auto identity column = DEFAULT
identity grab size = DEFAULT
lock promotion HWM = DEFAULT
lock promotion LWM = DEFAULT
lock promotion PCT = DEFAULT
number of pre-allocated extents = DEFAULT
event buffers per engine = DEFAULT
cpu accounting flush interval = DEFAULT
i/o accounting flush interval = DEFAULT
#配置缓冲大小，一般为配置内存的1/4
cache size = 256M
cache status = default data cache
#配置2k 4k 16k的缓冲池，加快数据库读取速度，但总字节数不能超过总缓冲大小
[2K I/O Buffer Pool]
pool size = 50.0000M
audit queue size = DEFAULT
default database size = DEFAULT
identity burning set factor = DEFAULT
allow nested triggers = DEFAULT
allow updates to system tables = DEFAULT
cpu grace time = DEFAULT
number of sort buffers = DEFAULT
sort page count = DEFAULT
number of extent i/o buffers = DEFAULT
number of large i/o buffers = DEFAULT
housekeeper free write percent = DEFAULT
partition groups = DEFAULT
partition spinlock ratio = DEFAULT
dump on conditions = DEFAULT
maximum dump conditions = DEFAULT
number of remote connections = DEFAULT
allow remote access = DEFAULT
number of remote logins = DEFAULT
number of remote sites = DEFAULT
max number network listeners = DEFAULT
[Physical Resources]
[Physical Memory]
#2k per unit ，
total memory = 312000
additional network memory = DEFAULT
lock shared memory = DEFAULT
shared memory starting address = DEFAULT
deadlock checking period = DEFAULT
freelock transfer block size = DEFAULT
max engine freelocks = DEFAULT
address lock spinlock ratio = DEFAULT
page lock spinlock ratio = DEFAULT
wash size = DEFAULT
[4K I/O Buffer Pool]
pool size = 50.0000M
wash size = DEFAULT
[16K I/O Buffer Pool]
pool size = 50.0000M
wash size = DEFAULT
[Disk I/O]
print deadlock information = DEFAULT
default fill factor percent = DEFAULT
number of mailboxes = DEFAULT
number of messages = DEDEFAULT
sql server clock tick length = DEFAULT
runnable process search count = DEFAULT
i/o polling process count = DEFAULT
time slice = DEFAULT
deadlock retries = DEFAULT
allow sql server async i/o = DEFAULT
disk i/o structures = DEFAULT
page utilization percent = DEFAULT
number of devices = 50
#允许最大设备号