AnsweredAssumed Answered

Slow SDE Feature Class Performance

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



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.