We have SDE (10.3) running on SQL Server (SQL Server 2012 on Windows Server 2012 R2)

Over time we've noticed our GIS performance degrade, and can have good days and bad days. We run versioned editing, replication, have geometric and network datasets, and have archiving enabled. We run regular (several times a day) compresses to keep things running smoothly.

My question is whether having archiving enabled on our heavily edited datasets would have a noticible effect on performance? We are not in a position to test this, so wonder if anyone else has experience with testing the performance of archiving heavily edited data. Some of our feature classes could have anywhere from 100 to 10,000 edited records in a day.

We've had our geodatabase with all our different types of datasets and functions running for a number of years, and it's only since we migrated from arcsde 9.3 to 10.3 (about a year ago) that we've noticed the significant performance issues.

closed as too broad by Vince, PolyGeo Jan 15 '16 at 1:26

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    The obvious answer is "Yes, enabling archiving can have an impact on performance", but the exact impact is very dependent on local factors, and therefore doesn't lend itself to "we found this, so you can do it too" solutions. – Vince Jan 14 '16 at 20:16
  • @Vince - without a doubt it'll have an impact, I'm rather trying to find whether it's likely to have a significant impact compared to other causes. Someone may have investigated this for themselves, and I'm interested in feedback on this. It's very hard to test heavy edits on anything other than production data, and we don't (at this stage) want to remove the Archive (due to not being able to re-link the archive table later) – Midavalo Jan 14 '16 at 23:32
  • 1
    I think you're overestimating the number of organizations that have anything like your environment. This is really a conversation to be having with Esri. – Vince Jan 15 '16 at 0:19
  • possibly, but all it takes is one, right? – Midavalo Jan 15 '16 at 0:23
  • 1
    No, you just have to get your distributor (or vertical market manager) to reach back to Redlands. This is too complex to handle via GIS SE. No one here is going to give you a hundred hours of consulting time. – Vince Jan 15 '16 at 0:32