Monday, 30 January 2012

Finding Sybase ASE database page size


1) t-sql



select @@pagesize, @@maxpagesize
2) t-sql

select pagesize("master..sysobjects")




3) t-sql (works across all Sybase version)

select

v.low as 'pagesize'
from master.dbo.spt_values v
where v.number = 1
and v.type = "E"

4) check database log file:


 grep "pagesize" logfile.txt

No comments:

Post a Comment