Sybase parameter settings

[Disk I/O]
Number of devices=20
[Physical Memory]
Total Memory = 512000 # #数据库可用物理内存, in 2k
[Processors]
Max Online engines=2 # #CPU数
U

Hpwg.cfg full text as follows:
##############################################################################
#
# 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 the 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]
#数据库可用物理内存, in 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
Enable Housekeeper GC = DEFAULT
Partition groups = DEFAULT
Partition Spinlock ratio = DEFAULT
Allow Resource limits = DEFAULT
Number of aux scan descriptors = DEFAULT
SQL Perfmon integration = DEFAULT
Allow backward scans = DEFAULT
row lock Promotion HWM = DEFAULT
row lock Promotion LWM = DEFAULT
row lock Promotion PCT = DEFAULT
License Information = DEFAULT

[User Environment]
Number of user connections = # #用户连接数
Stack size = DEFAULT
Stack Guard size = DEFAULT
Permission Cache entries = DEFAULT
User log Cache size = DEFAULT
User log cache Spinlock ratio = DEFAULT

[Lock Manager]
Number of locks = 50000 #锁数
Deadlock Checking period = DEFAULT
Freelock transfer block size = DEFAULT
Max engine freelocks = DEFAULT
Lock Spinlock ratio = DEFAULT
Lock hashtable size = DEFAULT
Lock scheme = DEFAULT
Lock wait period = DEFAULT
Read Committed with lock = DEFAULT

[Security Related]
systemwide Password expiration = DEFAULT
Audit Queue size = DEFAULT
Curread change W/open cursors = DEFAULT
Allow Procedure grouping = DEFAULT
Select on Syscomments.text = DEFAULT
Auditing = DEFAULT
Current Audit table = DEFAULT
Suspend audit when device full = DEFAULT
Max roles enabled per user = DEFAULT
Unified login Required = DEFAULT
Use Security services = DEFAULT
msg Confidentiality REQD = DEFAULT
msg Integrity REQD = DEFAULT
MSG Replay Detection REQD = DEFAULT
msg origin Checks Reqd = DEFAULT
Msg out-of-seq Checks reqd = DEFAULT
Secure Default login = Default
Dump on conditions = DEFAULT

[Extended Stored Procedure]
ESP Unload DLL = DEFAULT
ESP Execution priority = DEFAULT
ESP execution stacksize = DEFAULT
xp_cmdshell context = DEFAULT
Start Mail session = DEFAULT

[Error Log]
Event logging = DEFAULT
Log Audit Logon success = DEFAULT
Log Audit Logon failure = DEFAULT
Event Log Computer name = DEFAULT

[Rep Agent Thread Administration]
Enable REP Agent threads = DEFAULT
Maximum Dump conditions = DEFAULT

[Component Integration Services]
Enable CIS = DEFAULT
CIS Connect Timeout = DEFAULT
CIS BULK INSERT Batch size = DEFAULT
Max CIS remote connections = DEFAULT
Max CIS remote Servers = DEFAULT
CIS Packet size = DEFAULT
CIS Cursor rows = DEFAULT
CIS RPC handling = DEFAULT