Compress Geodatabase

513
2
Jump to solution
08-30-2021 01:59 PM
Colin_Schut
New Contributor III

Hi all,

I need to automate compressing the geodatabase, and am checking if there are any additional considerations to take into account concerning the ALRS. 

I'm primarily thinking about rebuilding indexes and analyzing datasets. 

  • Do they need to be done for both SDE and data owner?
  • Include system tables? Include the lrs tables like Lrs_edit_log, Lrs_event behavior...does it matter in anyway if they aren't versioned?
  • Any other things I should be aware of?

Thanks

 

0 Kudos
1 Solution

Accepted Solutions
AmitHazra
Esri Contributor

Here’s a plan to get you going. This pattern should be implemented on a very regular basis to optimize editing performance in the LRS.

  1. Identify connected users
  2. Prevent the geodatabase from accepting new connections
  3. Stop AGS services and disconnect users
  4. Validate (and clear) orphaned connections if any (check sde.process_information)
  5. Reconcile lockroot version (if applicable) and post changes to Default (If this was completed before the process then you can skip)
  6. Compress the geodatabase (Connect as SDE)
  7. Allow the geodatabase to begin accepting new connections
  8. Start AGS services
  9. Rebuild indexes on system tables (Connect as SDE, Uncheck Rebuild Delta Tables Only)
  10. Update statistics on system tables (Connect as SDE, check System Tables and check all the Analyze options)
  11. Rebuild indexes (Connect as data owner, Uncheck Rebuild Delta Tables Only)
  12. Update statistics (Connect as data owner, check all the Analyze options)

In case you are interested in GDB automation, you could reference the following:

 

-amit@esri  
Esri Transportation LRS Team

View solution in original post

2 Replies
AmitHazra
Esri Contributor

Here’s a plan to get you going. This pattern should be implemented on a very regular basis to optimize editing performance in the LRS.

  1. Identify connected users
  2. Prevent the geodatabase from accepting new connections
  3. Stop AGS services and disconnect users
  4. Validate (and clear) orphaned connections if any (check sde.process_information)
  5. Reconcile lockroot version (if applicable) and post changes to Default (If this was completed before the process then you can skip)
  6. Compress the geodatabase (Connect as SDE)
  7. Allow the geodatabase to begin accepting new connections
  8. Start AGS services
  9. Rebuild indexes on system tables (Connect as SDE, Uncheck Rebuild Delta Tables Only)
  10. Update statistics on system tables (Connect as SDE, check System Tables and check all the Analyze options)
  11. Rebuild indexes (Connect as data owner, Uncheck Rebuild Delta Tables Only)
  12. Update statistics (Connect as data owner, check all the Analyze options)

In case you are interested in GDB automation, you could reference the following:

 

-amit@esri  
Esri Transportation LRS Team

Colin_Schut
New Contributor III

This is perfect, thanks again Amit. 

0 Kudos