Panning or zooming in ArcMap creates larger spike in CPU usage for SQL Server Geometry data compared to SDEBINARY.
Last Published: October 20, 2016ArcSDE/Enterprise Geodatabase
Bug ID Number
April 15, 2015
June 11, 2020
After review by the development team, it has been determined that this issue is related to a known limitation with the software that lies outside of Esri's control. The issue's Additional Information section may contain further explanation.
Microsoft has implemented improved spatial query performance in SQL Server 2016 that includes invoking the native implementation of many spatial methods, avoiding the Unmanaged to Managed to Unmanaged transitions, improving performance.