HOW TO
As a versioned geodatabase is edited over time, delta tables increase in size and the number of states increases. The larger the tables and the more states, the more data ArcGIS must process every time you display or query a dataset registered as versioned. The greatest impact on performance, therefore, is not the number of versions but the amount of change contained in the delta tables for each version. As a result, versions can have different query response times.
To maintain database performance, the geodatabase administrator must periodically run the Compress tool to remove unused data and states. Only the geodatabase administrator can run a compression operation. Compressing performs two key tasks:
See the ArcGIS Pro documentation: Geodatabase administration with geoprocessing tools — Compress a versioned geodatabase
The outcome of the Compress workflow may be failure, or a partially compressed geodatabase. In these circumstances Esri Support may require the "compress logs" to determine the cause.
To save the SDE_Compress_Log table in a format to send to Esri Support, perform the appropriate workflow below.
Get help from ArcGIS experts
Download the Esri Support App