Varied Performance of Spatial View based on Desktop Version

[John_Spence]

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.

[CraigSwadner]

If these are on different databases, have you ran the query though an analyzer ?

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

[John_Spence]

Good thought, unfortunately it's all in the same database.  I checked all the indexes too thinking that maybe one was corrupt or something along those lines.  

I did pull the database to another server just in case there was something up there and repeated the experiment.  I may try the empty container method too, depending on what I get back from the tuning advisor.

[CraigSwadner]

You may check your compatibility settings ? I know when we went to sql 2017 we had to do some tweaks.

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]

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

[CraigSwadner]

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

[NanaDei]

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.