Recommended SDE database maintenance in branch versioning environment

05-11-2020 08:49 AM
Occasional Contributor II

We are using branch versioning for the first time in an SDE database (SQL Server 2016). 

For our existing traditional versioning DBs, we use the recommended compress, rebuild indexes, and analyze datasets in our nightly routines similar to ESRI documentation below. This methodology is not recommended with branch versioning, however. 

Is anyone using certain GP tools on a regular basis for database maintenance for an SDE database that uses branch versioning? If so, what methods are you using? Do branch versioned DBs require daily maintenance as traditional versioned DBs require?

Enterprise geodatabase maintenance tasks—Manage geodatabases in SQL Server | Documentation 

1 Reply
New Contributor III

Hello Brian,

We are also in the same boat as of a few weeks ago and we are experiencing some issues with latency.  Did you ever get an answer for your question?


0 Kudos