AnsweredAssumed Answered

Slow SDE Feature Class Performance

Question asked by mmorisette on Jun 21, 2016
Latest reply on Jun 24, 2016 by RRobichaux-esristaff

Hello

 

I've been experiencing slower than usual performance (noticeably slow time to draw as well as query, compared to similar feature classes) with a specific feature class in my organizations enterprise geodatabase.  The feature class consists of tax parcel polygons in the Local Government schema (vector_data.DBO.ParcelPublishing/vector_data.DBO.TaxParcel).  It is a non-versioned feature class with archiving enabled.

 

I've tried the following to speed it up (with no success):

 

* We reconcile, post, and compress our GDB nightly

* Feature class has an attribute index as well as a spatial index

* I have run "rebuild indexes" as well as "analyze datasets" on the feature class with just about every combination of options possible

 

Any suggestions as to what I should try next?

 

Our enterprise geodatabase is on version 10.3 on top of SQL Server 2008.

Outcomes