Do not leave master as the default device, database creates without a device
specification will be created in master.
1> sp_diskdefault master, defaultoff
2> go
(return status = 0)
1> sp_diskdefault device26, defaulton
2> go
Routine memory check
dbcc traceon(3604)
go
dbcc memusage
go
dbcc traceoff(3604)
go
/* sample post-install config, for 12.5 ASE */
-- send results, no wait
sp_configure 'tcp no delay',1
go
-- allocate 1.2 gb to sybase
sp_configure 'max memory',600000
go
-- allocate at sybase boot time
sp_configure 'lock shared memory',1
go
-- additional data cache
sp_cacheconfig 'default data cache','600M'
go
-- additional procedure cache
sp_cacheconfig 'procedure cache','50M'
go
-- cache for tempdb
sp_cacheconfig 'cache01','80M'
go
/* reboot ASE */
-- Additional config, for server w/several CPUs
sp_configure "number of user connections",500
go
sp_configure "number of worker processes",100
go
sp_configure "max parallel degree",3
go
sp_configure "max scan parallel degree",3
go
sp_configure "global cache partition number",2
go
sp_configure "number of locks",50000
go
sp_configure "number of open objects",50000
go
sp_configure "number of open databases",32
go
sp_configure "number of devices",50
go
/* reboot ASE */
-- Additional config, for system using text/blob data
sp_configure 'additional network memory',4096
go
sp_configure 'max network packet size',2048
go
sp_configure 'default network packet size',1024
go
sp_configure 'heap memory per user',4096
go
/*
UNIX Sybase >= 11.9, allow device buffering in O/S;
- improves performance
- increases chance of device corruption during failure
*/
sp_deviceattr "device21","dsync","false"
go
/* LINUX: may need to set shared memory */
echo 134217728 > /proc/sys/kernel/shmmax
echo 999999999 > /proc/sys/kernel/shmmax
Extend tempdb:
size should be about 20% of the main production database's size.
/* configure tempdb to 20 mb ... this command adds an additional
18 meg to the 2 mb already present on the master device */
1> alter database tempdb on device26 = 18
2> go
/* Add local server name */
sp_addserver snoopy, local
go
|
|