topic Re: SqlServer Spaital View slow rendering in ArcGIS Enterprise Questions

SqlServer Spaital View slow rendering

adnanmacor — Tue, 25 Oct 2022 07:17:06 GMT

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.

Re: SqlServer Spaital View slow rendering

RandyKreuziger1 — Tue, 25 Oct 2022 23:25:24 GMT

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?

Re: SqlServer Spaital View slow rendering

DEWright_CA — Wed, 26 Oct 2022 00:04:38 GMT

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.

Re: SqlServer Spaital View slow rendering

Scott_Tansley — Wed, 26 Oct 2022 00:24:09 GMT

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.