《sybase参数设置》由会员分享,可在线阅读,更多相关《sybase参数设置(5页珍藏版)》请在金锄头文库上搜索。
1、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 va
2、lues 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
3、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
4、 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 p
5、ercent = 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
6、 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 p
7、er 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
8、 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
9、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 = DEFAUL
10、T 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
11、 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
12、= 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 =
13、 DEFAULT license information = DEFAULT User Environment number of user connections = 100 #用户连接数 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 c
14、hecking 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 aud
15、it 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 Proce