It is recommended to set up a log cache for most ASE databases - as this can have a positive impact on overall transaction performance. A few hundred meg is recommended - set a majority of the cache have a pool allocated for I/O = @maxpagesize * 2.
-- Set up a log cache, for a database with 4K @@maxpagesize
sp_cacheconfig 'PUBS2_logcache', '100M', logonly
go
sp_dboption 'PUBS2db','single user',true
go
sp_poolconfig 'PUBS2_logcache','90M','8K'
go
use PUBS2db
go
checkpoint
go
sp_bindcache 'PUBS2_logcache','PUBS2db','syslogs'
go
sp_logiosize '8K'
go
use master
go
sp_dboption 'PUBS2db','single user',false
go
use PUBS2db
go
checkpoint
go
|
|
