HOW TO

Save the SDE_Compress_Log table in a format for Esri Support

Last Published: January 31, 2024

Summary

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:

  • It removes unreferenced states and their associated delta table rows.
  • It moves entries in the delta tables common to all versions into the base tables, reducing the amount of data the database needs to search through for each version query, thereby improving query performance and system response time.

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. 

Procedure

To save the SDE_Compress_Log table in a format to send to Esri Support, perform the appropriate workflow below.

Microsoft SQL Server

  1. Start SQL Server Management Studio.
  2. Connect to the relevant instance and database.
  3. Locate the SDE_compress_log table.
  4. Right-click and activate Select Top 1000 Rows.
  5. When the query completes go to File > Save Results As.
  6. Save the file in CSV format.

PostgreSQL Server

  1. Start PGAdmin.
  2. Connect to the relevant server and database.
  3. Locate the SDE_compress_log table in the schema for the sde user and highlight/select it.
  4. In the main menu bar navigate through Object > View/Edit Data > All Rows.
  5. in the Query Editor press the Save results to file button shown below, or press F8.
  6. Save the file in CSV format.

Article ID: 000031780

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options