SYBASE参数设置[精选].docVIP

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_