Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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?

share|improve this question
    
Have you re-indexed after upgrading? –  Mapperz Feb 12 '13 at 16:15
    
analyzed and rebuilt with no change –  Derek Feb 18 '13 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... –  Kirk Kuykendall Mar 1 '13 at 4:16
add comment

2 Answers

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

share|improve this answer
    
Applied with no change. Both ArcGIS Server and SDE database are on VMs, would that cause any issues? –  Derek Feb 18 '13 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 Feb 18 '13 at 23:21
add comment

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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