NCM CacheDiffResults table is too large.

5/12/2020 6:59 PM

6/21/2023 6:51 PM

What data does NCM_CacheDiff table hold?
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. This can be safely truncated if needed as NCM_CacheDiff will be rebuilt automatically itself upon the next Services to start.

The NCM CacheDiffResults table in the Orion Database has been noted as being large and maybe impacting NCM or Orion performance. After completing the troubleshooting from this article  Decrease NCM CacheDiffResults table  This article provides the alternative way to reduce the size of this table.

 

Network Configuration Manager

Truncate this table - NCM_CacheDiffResults
 

1. Stop Orion services  
   1. Click Start > All Programs > SolarWinds Orion > Orion Service Manager.
   2. Click Stop Everything (Top Left of Service manager)
2. To truncate the table
   1. Click Start > All Programs > Solarwinds Orion >  Database Manager.
   2. Add the database if it does not exist by clicking on add default server.
   3. Right click on the database and select new query.
   4. Type the following Query into the query box in the middle.

      -- Scripts are not supported under any SolarWinds support program or service.
      -- Scripts are provided AS IS without warranty of any kind. SolarWinds further
      -- disclaims all warranties including, without limitation, any implied warranties
      -- of merchantability or of fitness for a particular purpose. The risk arising
      -- out of the use or performance of the scripts and documentation stays with you.
      -- In no event shall SolarWinds or anyone else involved in the creation,
      -- production, or delivery of the scripts be liable for any damages whatsoever
      -- (including, without limitation, damages for loss of business profits, business
      -- interruption, loss of business information, or other pecuniary loss) arising
      -- out of the use of or inability to use the scripts or documentation.
      
      TRUNCATE TABLE [NCM_CacheDiffResults]

   5. Click Execute Query to run the query.