Using sp_iqestdbspaces With Other System Stored Procedures

You need to run two stored procedures to provide the db_size_in_bytes parameter needed by sp_iqestdbspaces.

Results of sp_iqestdbspaces are only estimates, based on the average size of an index. The actual size depends on the data stored in the tables, particularly on how much variation there is in the data.

Sybase strongly recommends that you create the spare dbspace segments, because you can delete them later if they are unused.

Run sp_iqestjoin for all the table pairs you expect to join frequently.
Select one of the suggested index sizes for each pair of tables.
Total the index sizes you selected for all tables.
Run sp_iqestspace for all tables.
Total all of the RAW DATA index sizes returned by sp_iqestspace.
Add the total from step 3 to the total from step 5 to determine total index size.
Use the total index size calculated in step 6 as the db_size_in_bytes parameter in sp_iqestdbspaces.