Common Sybase configuration parameters

Common Sybase configuration parameters
You can use sp_configure to view all the configurations of Sybase, or you can see "[database name] under the Sybase root directory. cfg "configuration, all items that the user has not changed in this file are displayed as default. If there is any change,
Value. Some common configurations are listed here. Refer to the article:
Http://www.blogjava.net/shanben/archive/2008/07/09/213731.html
Http://as400bks.rochester.ibm.com/tividd/td/tec/SC32-1233-00/zh_CN/HTML/ecoimst97.htm

-- Configure the maximum number of CPUs
Sp_configure 'max online engines ', 4
Go
-- Configure the number of started CPUs
Sp_configure 'number of engines at startup', 4
Go
-- Configure the maximum number of memories
-- The total memory is configured from the user input value. It defines the total memory allocated from the available memory of the operating system to the event database server, in 2 K. A higher value will allocate more internal buffers to the event database server.
-- And -- high-speed cache reduces the number of disk I/O and improves performance.
-- Note: The Event database server must be able to obtain the total memory size defined at startup, otherwise it will not start. If the server is not started, set a lower value for the server in the configuration file and restart the server.
Sp_configure 'max memory ', 2097151
Go
-- Allocate maximum Stored Procedure Cache
Sp_configure 'Procedure cache', 102400
Go
-- Configure high-speed cache
Sp_cacheconfig 'default data cache', '700m'
Go
-- Default cache allocation page size
Sp_poolconfig 'default data cache', '200m', '16k'
Go
-- Network Package Size
Sp_configure 'max network packet size', 1024
Go

-- Maximum number of connections
Sp_configure 'number of user connections ', 500
Go
-- Maximum opened object
Sp_configure 'number of open object', 9000
Go
-- Maximum Index
Sp_configure 'number of open Index', 10000
Go
-- Maximum number of locks
-- Set the number of locks to 10000. This value sets the number of locks on the event database server that all users can use.
Sp_configure Number of locks, 100000
Go

-- Increase network memory
Sp_configure 'additional network memory ', 1024
Go

-- Lock memory
Sp_configure 'lock shared memory ', 512
Go

-- Configure the number of devices
-- Set the number of devices to 25. It sets the number of devices that can be defined by disk init. The device number is initially set to 0 to 9. The event database can be configured with up to 11 additional devices, so the new value is 25.
-- If setting 25 does not allow the addition of 11 new devices, change it to a higher value.
Sp_configure 'number of devices', 50
Go

-- Configure a large number of I/O buffers
-- Set the number of large I/O devices to 12. This value sets the number of 16 K buffers available for large I/O utilities (such as database loading, database creation, and Database Change.
Sp_configure 'disk I/O structures ', 4096

-- Allocate the maximum shared memory
Sp_configure 'allocate Max shared memory ', 1

-- Allocate stack size for each user
Sp_configure 'heap memory per user'

-- Optimize tempdb
Select dbid, name, segmap
From sysusages, sysdevices
Where sysdevices. Low <= sysusages. Size + vstart
And sysdevices. High> = sysusages. Size + vstart-1
And dbid = 2
And (status = 2 or status = 3)
Go
Use tempdb
Go
Sp_drow.gment 'default', tempdb, Master
Go
Sp_drow.gment 'logsegment', tempdb, Master
Go

Select dbid, name, segmap
From sysusages, sysdevices
Where sysdevices. Low <= sysusages. Size + vstart
And sysdevices. High> = sysusages. Size + vstart-1
And dbid = 2
And (status = 2 or status = 3)
Go

Sp_cacheconfig tempdb_cache, '100m'
Go
Sp_poolconfig tempdb_cache, '50m', '16k'
Go
Sp_bindcache 'tempdb _ cache', tempdb
Go
Sp_helpcache tempdb_cache

Select name, ID from syscharsets

DBCC traceon (3604)
DBCC memusage

This article is from:Feng Libin's blog