SYBASE_系统参数调整(国外英语资料).docVIP

SYBASE_系统参数调整(国外英语资料) Sybase performance optimized personal notes Sybase optimization summary = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = One. SYBASE system parameter adjustment 1. The memory LINUX operating system memory tuning: / sbin/sysctl-w kernel. Shmmax = 3416386150 Shmmax is Shared memory segment, if no other applications on the server and use raw device can adjust the parameter to 90% of the physical memory, if using the file system device corresponding to the small, because the file system overhead memory buffer need! Restart the system after modification. Sp_configure Max memory, 1500000 restart (set to 75% of Shared memory) Sp_configure allocate Max Shared mem, which automatically allocates Max memorys maximum memory when it starts. (if sybase is installed on Windows, you can see that the footprint is really 3G in the Windows task manager) The sp_cacheconfig default data cache, 1500m sets the data cache (set to half of Max memory) The sp_cacheconfig default data cache, cache_partition = 2 is a multiple of the number of cpus, the data buffer partition Sp_poolconfig default data cache, 64m, 16k set 16k data cache Sp_poolconfig default data cache, 128m, 8k sets the 8k data cache The sp_configure procedure cache size, 90000 stored procedure data cache Sp_cacheconfig tempdb_cache, 200m, mixed creates a named cache Sp_poolconfig tempdb_cache, 50M, 16K optional: configure the memory pool if there is a large I/O The sp_bindcache tempdb_cache, the tempdb restart takes effect. Bundle the temporary database to the tempdb_cache cache 2. The CPU Sp_configure Max online engines, 2 sets the amount of CPU used The sp_configure number of engines at startup starts with the number of cpus 3. The network Sp_configure default network packet size, 2048 sets the size of the network transfer package (restart takes effect) Sp_configure Max network packet size, 2048 Use other resources Sp_configure number o