View 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