AnsweredAssumed Answered

Slow SDE Feature Class Performance

Question asked by mmorisette on Jun 21, 2016
Latest reply on Nov 28, 2018 by pauldj22

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