sp_helpsegment, when used without an argument, displays information about all of the segments in the database where you execute it:
sp_helpsegment
segment name status ------- ----------------------------- ------ 0 system 0 1 default 1 2 logsegment 0 3 seg1 0 4 seg2 0
For information about a particular segment, specify the segment name as an argument. Use quotes when requesting information about the default segment:
sp_helpsegment "default"
The following example displays information about seg1:
sp_helpsegment seg1
segment name status ------- ------------------------------ ------ 4 seg1 0 device size free_pages ---------------------- ---------------- ----------- user_data10 15.0MB 6440 user_data11 15.0MB 6440 user_data12 15.0MB 6440 table_name index_name indid ---------------------- --------------------- ------ customer customer 0 total_size total_pages free_pages used_pages --------------- ----------- ----------- ----------- 45.0MB 23040 19320 3720
