Varied Performance of Spatial View based on Desktop Version

Question

Has anyone run into this issue?  We have a spatial view (registered) on a 10.5.1 SDE database in SQL Server 2016 that under ArcGIS Desktop 10.3.1 renders in 4 seconds.  This same view in 10.5.1, 10.6.1, and 10.7.1 will take about 4 minutes to complete.  The draw methods appear to be the same for 10.5.1-10.7.1 too so it appears they are reading the view the same way.  I checked SDE intercept between the 4 different versions and everything appears good to go there.  I even cleared out execution plans from SSMS and rebuilt them from the ground up to see if there was a way to get better performance from it.  Maybe I missing the boat.  Anyone run into something similar in the past?

Thanks ahead of time for your thoughts.

NanaDei · Answer

Is the underlying feature class a point, line or polygon?
Is the spatial view based on joining the feature class to other tables?
Are the tests based on rendering the spatial view at full extent?
Capture a trace to determine where the time is being spent. We need to review if the time is being spent querying or fetching the data.
Esri Technical Support can also assist to troubleshoot the behavior.

CraigSwadner · Answer

This happens sometimes also…

https://www.mssqltips.com/sqlservertip/4801/sql-server-does-not-use-all-assigned-cpus-on-vm/

Craig Swadner (GIS Coordinator)

City of Cape Coral

1015 Cultural Park Blvd.

Cape Coral, Fl 33990

Did you know the best way to report issues to ITS is to use the Service Desk system?  This will ensure someone in ITS gets your request and allows us to track the progress.  Please enter all your issues and/or questions by clicking https://breeze.cape.capecoral.net

CraigSwadner · Answer

We modified this on our spatial database properties.

Craig Swadner (GIS Coordinator)

City of Cape Coral

1015 Cultural Park Blvd.

Cape Coral, Fl 33990

Did you know the best way to report issues to ITS is to use the Service Desk system?  This will ensure someone in ITS gets your request and allows us to track the progress.  Please enter all your issues and/or questions by clicking https://breeze.cape.capecoral.net

image001.png