• Find out the Sybase ASE dataserver’s page size

    January 7th, 2009 @ 1:18 AM by Jean-Francois LEBON | Comments Off

    Find out the dataserver’s page size without using global variables like @@pagesize or @@maxpagesize.

    When you work with heterogeneous versions of Sybase Ase (12.0.x and 12.5.x or 15.x), this query can help you while coding your dba stored procedures…

    declare @page_size int
select  @page_size = low /1024 from master.dbo.spt_values
where type = 'E' and number = 1
go

    It will produce the result in Kb. This works with Sybase ASE from version 11.x to 15.x.

    Tags: , , , , , ,