topic Re: Does anyone truncate sde.sde_compress_log? in Data Management Questions

Does anyone truncate sde.sde_compress_log?

JefferyGregg — Wed, 28 Feb 2024 22:20:00 GMT

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?

Re: Does anyone truncate sde.sde_compress_log?

MarceloMarques — Wed, 28 Feb 2024 22:51:52 GMT

@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.

Re: Does anyone truncate sde.sde_compress_log?

JefferyGregg — Mon, 04 Mar 2024 15:43:47 GMT

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