To display information about Adaptive Server’s limits:
Run dbcc serverlimits, which includes the size of your server’s logical page size in its output. For example, enter:
dbcc serverlimits
Search for the string “logical page size” in the error log.
Run select using the @@maxpagesize global variable, which displays the server’s logical page size:
select @@maxpage size ----------- 8192
