11 Replies Latest reply on Dec 23, 2016 9:32 AM by nick_scott

    Analyzing the SW Nightly Database Maint Logs


      In attempts to better understand the unique components that make up our SLW instance I have started looking at the DB main logs, trying to find ways to optimize our instance.  I have consistently seen what seem to be obvious problems when the DB attempts to consolidate data related to UNDP.  I do have a decent amount of UNDP in the environment, but nothing excessive.  I have also confirmed by retention times of UNDP data to be the following.


      7,20,65 days retention for detailed, hourly, and daily. 


      Attached are maint logs where UNDP is referenced, I have left out the rest as it appears normal without error.