sybase数据库参数调整案例

说明:gdkkx是建好的空数据库,hrj是服务器名

在ms-dos窗口中，登录进入isql。

1．扩展master数据库

c:/>isql –Usa –P –Shrj
alter database master on master = "300M"
go

2．数据库选项参数
登录进ms-dos窗口

isql –Usa –P –Shrj
exec master.dbo.sp_dboption gdkkx, "select into/bulkcopy", true
go
exec master.dbo.sp_dboption gdkkx, "trunc log on chkpt", true
go
exec master.dbo.sp_dboption gdkkx, "abort tran on log full", true
go
exec master.dbo.sp_dboption gdkkx, "allow nulls by default", true
go
exec master.dbo.sp_dboption gdkkx, "ddl in tran", true
go

3．性能参数
1.登录进ms-dos窗口
isql –Usa –P –SXXX_DB
sp_configure "max memory", 7680000
go
sp_configure "number of user", 100
go
sp_configure "number of device", 60
go
sp_configure "number of locks", 100000
go
sp_configure "number of open object", 30000
go
sp_configure "number of open indexes", 30000
go
sp_configure "shared memory starting address", 23662592
go
sp_configure "procedure cache size", "300M"
go
sp_cacheconfig "default data cache", "500M"
go
sp_poolconfig "default data cache", "150M", "16K"
go
sp_configure "max online", 2
go
sp_configure "number of engines at startup", 2
go