Bug
When working with an 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.
| Bug ID Number | NIM082657 |
|---|---|
| Submitted | July 11, 2012 |
| Last Modified | April 2, 2025 |
| Applies to | ArcSDE/Enterprise Geodatabase |
| Version found | 10.1 |
| Operating System | Windows OS |
| Operating System Version | 2008 R2 64 Bit |
| Version Fixed | 10.2 |
| Status | Fixed |
Description
There is query and draw performance degradation when using the Geometry or Geography spatial type with SQL Server 2012 as compared to querying the same data from SQL Server 2008 and 2008 R2 databases. This affects all rendering and editing operations.The performance degradation varies with the complexity of the operations and the corresponding number of underlying queries. The performance difference is negligible for simple operations. For more complex operations, the performance difference becomes noticeable.
Cause
Esri has worked with Microsoft to identify the source of the problem: a difference in query support functions built into SQL Server 2012.Esri has modified its software to reduce the performance degradation. The change is available with ArcGIS 10.2.
Workaround
None.Steps to Reproduce
Bug ID: NIM082657
Software:
- ArcSDE/Enterprise Geodatabase
Get notified when the status of a bug changes
Related Information
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App