I have a 24 GB raster dataset on my sde that I wish to have pyramids build. When I created the raster file initially via arctool box, I made sure none of the pyramids or statistic are built by unchecking the boxes under raster storage environment. I double checked using sderaster command line to ensure no pyramids were created. Initially, when I ran the pyramid building process via arctool box, it ran for 2 weeks and never finished. I killed the process even though arccatalog told me there were pyramids. However, I cannot view it unless I zoomed way in. I removed the pyramids via sderaster command and decided to use the sderaster command to rebuild. Now, it has been running for 24 hours, and still not yet finish. However, when I use the sderaster command line to describe the raster, it tells me the pyramids are there. Should I stop the process? The last time I ran this on a different sde, it took less than 1 hour. Why is it taking longer? Could it be the set up of the database causing the issue? I am running on 9.3.1 on all platform.
