I have a ArcSDE 10.0 geodatabase with SQL Server 2008 enterprise, the database is about 160 gb, one datafile(.mdf).
Last Friday, I just upgraded to 10.1.
Everything thing is fine with the database except deleting feature dataset or feature class. Deleting is really slow, it takes 2-15 minutes from ArcCatolog, even the feature dataset is small. The problem ( 10.1) is the same as in 10.0.
Any suggestion about how to improve the issus will be appreciated.