Sybase parameter settings

Source: Internet
Author: User
Tags bulk insert character set flush sybase
[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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.