Chapter 1: Building Servers Using dataserver

Viewing the current server limits

To display information about Adaptive Server’s limits:

dbcc serverlimits 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.
The global variable @@maxpagesize displays the server’s logical page size. At the isql prompt, issue:
```
select @@maxpage size
----------- 
    8192
```