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

    Analyzing the SW Nightly Database Maint Logs

    nick_scott

      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.