SqlServer Spaital View slow rendering

Question

I am working as GIS Consultant. Client is using ArcGIS Enterprise Standard. They have developed some spatial views in Sql-Server. These views return the result within one second in Management Studio. But when we load that view in ArcGIS Desktop it is taking 5-10mins to open the attribute table and sometime give invalid field error. Can someone assist in this matter.

thanks.

Scott_Tansley · Answer

So many potential reasons, but I'll ask this:

A lot of people test with SSMS will be using it on the machine where SQL is installed, which could be in your local server room.  But ArcGIS Enterprise 'could' be in the cloud, and in a completely different physical location.

Do you know the physical locations of your database and application servers?

The impacts of bandwidth and latency can have a drastic impact on performance, so we need to rule that out.

dewright_ca · Answer

Is this coming from a Spatial DB? meaning enabled by ArcGIS? If so have you registered the views with ArcCatalog? Once you have you can add indexes to help speed spatial performance.

Randy.Kreuziger@dfw.wa.gov_wdfw · Answer

Are all the fields in the spatial view value ESRI field types?

How many records?

Are you using Definition Queries in Desktop or are you using the all the records?

Are you bringing the whole dataset in as is or have you set symbolization?