There is no ArcSDE command to report storage of database objects. Instead you must
use database tools to determine this information.
sp_space_used will report the storage of a table for SQL-Server, but you need to identify
the correct associated table (in the form SDE_blk_{n}, where {n} is the rastercolumn_id
value from sde.SDE_raster_columns table for the table_name associated with the raster).
There are other tables (and indexes) as well, but the BLK table generally holds 99% of
the overall allocation. Vector storage determination is trickier, since the three primary
tables are more nearly equal (except when you have thousands of vertices per feature),
and versioning makes the problem more complex (two more tables, which may be either
small or large, depending on your versioing state tree). The 'sdetable -o describe_reg'
command will identify the tables which participate with a business table in storage
of spatial data, but you may then need to determine the indexes of each table.
Finally, you need to consider high water marks, since storage isn't generally released
after a delete operation (on the assumption [by the RDBMS] that the table will grow
again anyway). Other databases also incorporate "extent" (or "chunk") management
overhead so that even a 10Kb LOB might use hundreds of Mb. Then there's block
overhead on the disk drive,... All in all, it's a rather complex issue.
- V
