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're running into some performance issues when accessing large enterprise geodatabases on a SQL Server 2008 R2 cluster. The database itself performs well and returns queries fine but presenting the information back to ArcGIS for Desktop 10.1 is prohibitively slow.

Connection is direct connect. Data type in SDE is DBO. Machines are VMs with 16Gb RAM.

Are there any tips or tricks or known documents for installs of these on SQL Server clusters where a node instance is presented?

Thanks Doylersa

share|improve this question
3  
Welcome to gis.SE. Perhaps you can edit your question (just click edit above) to add details of the type of queries that are causing problems, and some metrics of what is "prohibitively slow"? –  BradHards Jun 6 '13 at 9:40
1  
Just to clarify - you're talking about using SDE to store spatial data in SQL server? Or are you using the SQL server native spatial data type? –  mapBaker Aug 5 '13 at 18:13

5 Answers 5

This may apply to you (It fixed this same problem for us):

FIX: Performance might be slow when you run a parallel query against a table that has a large amount of spatial data in SQL Server 2008 R2

PS - We just discovered the same problem is back in SQL Server 2012.

share|improve this answer

See this article: "A common question that I see in Desktop Support is “Why is ArcMap performing so slowly?”"

http://blogs.esri.com/esri/supportcenter/2012/06/07/troubleshooting-slow-performance-in-arcgis-desktop/

share|improve this answer

I had a similar problem before and found using PerfQAnalyzer for ArcGIS to be very useful to analyze drawing and fetch speeds in the map.

share|improve this answer

Outside of the maps I found the Process Explorer helpful in getting a grip on what/where the problem was occurring.

Sorry have to keep re-posting as I am only allowed one link per post.

share|improve this answer

Are you working with ArcSDE Personal, Workgroup, or Enterprise level? That may cause limitations depending on what license level you are at. Take a look here and see if you are extended beyond your license level.

share|improve this answer

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.