Does anyone truncate sde.sde_compress_log?

212
2
02-28-2024 02:20 PM
Labels (2)
JefferyGregg
New Contributor II

Hi all,

Does anyone truncate sde.sde_compress_log on a regular basis?  We are looking to manage our logs and this question came up.  Why or why not truncate the compress_log?

0 Kudos
2 Replies
MarceloMarques
Esri Regular Contributor

@JefferyGregg - the sde.compress_log table will not get many rows even if you are running the sde compress every day for years. The question is do you need to keep the history if you are troubleshooting any sde compress issues, I suggest to not truncate the table, and instead delete rows older than 30 days, 60 days, 90 days, the period that you do not need the history anymore.

| Marcelo Marques | Principal Product Engineer | Esri |
| Cloud & Database Administrator | OCP - Oracle Certified Professional |
I work with Enterprise Geodatabases since 1997.
“ I do not fear computers. I fear the lack of them." Isaac Isimov
JefferyGregg
New Contributor II

Thank you Marcelo.  Yes, I agree with your logic.  I don't think we need all the history... just 90 days or so.  

jg

0 Kudos