Estimating SDE storage needs.

Discussion created by huffmanp on Jun 25, 2014
Latest reply on Jun 25, 2014 by vangelo-esristaff
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