We have just built and new ArcGIS/ArcSDE system with SQL Server 2012 SP1. We are experiencing very long periods (up to 2 minutes) just to connect to the database in Desktop. Desktop does connect and we can publish map services, but everything is painfully slow. We have ruled out network issues, and wonder if we are missing something. Has anyone experienced this?

  • Have you re-indexed after upgrading?
    – Mapperz
    Commented Feb 12, 2013 at 16:15
  • analyzed and rebuilt with no change
    – Derek
    Commented Feb 18, 2013 at 14:22
  • Is it also slow if you create a query layer in arcmap? You can create it via File>Add Data>Add Query Layer... Commented Mar 1, 2013 at 4:16

2 Answers 2


Esri just released a patch addressing this exact problem. Identified as bug NIM082657 - When working with a SQL Server 2012 geodatabase and Geometry or Geography type data, ArcMap drawing performance is slower than it was using SQL Server 2008. This affects all rendering and editing operations.

Downloads and instructions here -- http://support.esri.com/en/downloads/patches-servicepacks/view/productid/160/metaid/1954

  • Applied with no change. Both ArcGIS Server and SDE database are on VMs, would that cause any issues?
    – Derek
    Commented Feb 18, 2013 at 14:23
  • 1
    It could explain if the VMs are under resourced - we run ours with VMs exclusively. Are you using a direct connect to the database or an SDE connection? Again, it shouldn't make too much difference but direct connect is the new recommended way. Do published services have the same problem when data is in fgdb? You can always open a support ticket with Esri as well.
    – awesomo
    Commented Feb 18, 2013 at 23:21

we had the same problem...and while not ideal the solution for us was to use SDE Binary storage type...super fast after that!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.