3 Replies Latest reply on Jun 11, 2013 9:10 AM by byrona

    Interface Detail Data Retention Concerns?

    byrona

      I am looking to increase interface detail data retention from 10 days to 45 days but I am concerned about any problems this may cause.  Are there certain numbers to watch out for regarding database table size or row count on the tables that this will affect?   What specifically should I watch for to see if this is having a negative impact on my system?

       

      Thanks in advance for any pointers here!

        • Re: Interface Detail Data Retention Concerns?
          Scott Sadlocha

          I don't think I have a set answer for you, but can provide information on what I did with similar situations. I tend to be an overly cautious type and have been a bit nervous with situations where I increased retention times for various aspects of the environment. Prior to increasing, I took note of database sizes, pertinent table sizes, etc, as well as system resource utilization , so I could have some type of baseline with which to compare after I made the changes. I did this on both the DB server as well as the Orion management server and additional pollers. I also noted the information under the Polling Information statistics under the Admin Settings in the console.

           

          After making my changes, I did a comparison frequently to note changes, finding that many of my changes had little to no impact. Also, when I was feeling very cautious and had a bit more time with which to make the changes, I didn't do them all at once, but rather incrementally, for instance going from 10 to 20 to 30.

          • Re: Interface Detail Data Retention Concerns?
            byrona

            Any other thoughts on this?