When you execute sp_helpdb within a database, and give that database’s name, you see information about the segments in the database.
For example:
sp_helpdb mydata
name db_size owner dbid created status --------- ---------- ----------- -------------- ------------ mydata 8.0 MB sa 4 May 27, 1993 no options set device_fragments size usage free kbytes ------------------- ---------- ----------------- ----------- datadev2 4.0 MB data only 3408 logdev 2.0 MB log only 2032 seg_mydisk1 2.0 MB data only 2016 device segment ------------------------------ ------------------------- datadev2 default datadev2 system logdev logsegment seg_mydisk1 seg1
