Querying system table for space usage information

You may want to write some of your own queries for additional information about physical storage. For example, to determine the total number of 2K blocks of storage space that exist on Adaptive Server, you can query sysdevices:

select sum(high - low)
from sysdevices
where status in (2, 3)
-------------------
               7168

A 2 in the status column represents a physical device; a 3 represents a physical device that is also a default device.