Updated February 9, 2017
The NCM CacheDiffResults table in the Orion Database has been noted as being large and maybe impacting NCM or Orion performance. This article provides steps to trim it down.
Not restricted by NCM version or SQL server
NCM has a job set up for the routine cleaning of tables in the database as well as the Config Archive folder on the NCM server.
- From the Web Console, go to NCM jobs.
- Select Job Default Database and Archive Maintenance Job, and then click Edit.
- Set the Frequency of the job to run, (generally, weekly is sufficient), and then click Next.
- There are no options to select on Choose Nodes section, and then click Next.
- Notifications and logging page at your discretion, and then click Next.
- Add Job Specific Details. This is the core of the job: purge configs from the config archive folder older than xx.
- Generally, you can uncheck this unless space is becoming an issue, but if it is, recommend to back up and move these to store for disaster recovery, before deleting regardless.
- The location is determined by the settings > NCM settings > Config Archive Folder Locations.
- These are the device configurations downloaded to the Server and not the database.
- Purge config cache data older that: XX
- Generally, Resources are maintained at as of last update, but could be looking over a specified period of time. Use this as well as the frequency of how often devices are backed up and what type of configs you are backing up. Three months is a general rule of thumb for the data retention here, but the value is up to the the user and the policies in place as have these on a view.
- Each time a config is downloaded, it will compare to the same config type, then each of the others and then write an entry for each in the table, per config per device.
- This data is what is used to populate the Charts regarding the Config Differences (Running, Run vs start, Run vs Baseline.
- Purge Job Log: These logs can be purged frequently and default settings should be sufficient.
- Purge Config Transfer request older than XX
- The size of this table is dependent on manual operations such as download configs, execute scripts via NCM. Actions performed by jobs will not impact this table.
- the size of this table can impact the operations of these manual tasks if the table gets large, but is a good place to look for troubleshooting or validating work.