Estimating SDE storage needs.

463
1
06-25-2014 02:50 PM
PaulHuffman
Occasional Contributor III
Lately I've been trying to figure out how much longer my storage on my ArcServer is going to last.  The major portion of the data storage is LIDAR data and its products that we procure every year.  I thought maybe one approach would be to see how much each year's LIDAR set is using,  then I might be able to guess how many more years of LIDAR data I can fit on the remaining disk space.  But because the data is all packed away in SDE storage,  I'm having difficulty figuring out how I can read disk usage for each year.

The only way I can figure out how to do it is backup the database, compact, look at remaining free disk space, delete a year's set, compact, then look at the increase in free disk space,  then restore.  Are there any other good ideas?

Arc Server 9.3.1 on a Windows Server platform, MS SQL Server
0 Kudos
1 Reply
VinceAngelo
Esri Esteemed Contributor
This is one of the many reasons why storing rasters inside databases has gone
out of favor, but all databases permit queries of both the storage allocated
to tables and either the free space within allocated storage, or the actual
storage used by objects.  For SQL-Server the utility is named sp_spaceused,
though you'll need to associate the BLK table by rasterstore ID to determine
the parent raster.

- V
0 Kudos