I've got a 'production' geodatabase on a 32-bit SQL Server 2008 R2 platform with ArcSDE 10 SP 3. The database has about 4-5 concurrent editors at any given time working a normal 40-hour work week.
My question is: How often do we need to 'tune' the database. We're compressing daily as part of an automated reconcile / post process, but I'm more concerned about 'Updating Statistics' and 'Re-building Indexes'.
Any thoughts out there?
Thanks in advance...