3 Replies Latest reply on Oct 16, 2013 7:52 AM by tollifi

    SolarWinds.DataProcessor.exe *32 very high CPU utilization

    tollifi

      Hello!

       

      Orion

      Module NameOrion Platform
      Version2013.1.0
      Service PackNone
      Nodes currently monitored93
      Total nodes in license100
      Volumes currently monitored22
      Total volumes in license100

       

      NPM
      LicenseProduction
      Product NameNetwork Performance Monitor
      Version10.5
      Service PackNone
      Current number of interfaces96
      Allowed number of interfaces100

       

      NTA
      LicenseProduction
      Module NameNetFlow Traffic Analyzer
      Version3.11.0
      Service PackNone

       

      IVIM

      Module NameIntegrated Virtual Infrastructure Monitor
      Version1.6.0
      Service PackNone

       

      SQL

      Local SQL Express

       

      Windows Server 2008 R2

      Intel(R) Xeon(R) CPU  E5530 @2.40GHz 2.40GHz (2 processors)

      Installed Memory (RAM): 4,00 GB

      System type: 64-bit Operating System

       

      Problem Description

      I noted that CPU is permanently loaded by process SolarWinds.DataProcessor.exe * 32 for 75-100%. Why so occurs? How to lower loading?

        • Re: SolarWinds.DataProcessor.exe *32 very high CPU utilization
          ET

          Hi,

          is this caused by upgrade?

          From which version you upgraded?

          Do you receive a lot of traps or syslogs?

            • Re: SolarWinds.DataProcessor.exe *32 very high CPU utilization
              tollifi

              I,m upgrade NPM from 10.4 to 10.5. But I am not sure that it because of an upgrade. I didn't track CPU loading until now.

              Comments from techsupport Solrawinds Orion:

               

              "...From reviewing the logs it appears that the Multicast routing is causing problems within the Data Processor.


              I have the following suggestions:

              ** Before doing any work on your database please make sure that you have a current backup as this will make a permanent change to your database. **

              Please stop all the Orion Services using the Orion Service Manager (Start > All Programs > Solarwinds Orion > Advanced Features)


              Next run this script against your DB:


              IF (dbo.GetNpmDbVersion() = 8)    -- version is equal to 10.5

              BEGIN

                  IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NPM_RoutingNeighbor]') AND type in (N'U'))

                  BEGIN

                      IF EXISTS (SELECT * FROM sys.indexes WHERE name='IX_NPM_RoutingNeighbor' AND object_id = OBJECT_ID('NPM_RoutingNeighbor'))

                      BEGIN

                          --drop index

                          ALTER TABLE NPM_RoutingNeighbor DROP CONSTRAINT IX_NPM_RoutingNeighbor

                          --recreate the unique constraint

                          ALTER TABLE NPM_RoutingNeighbor

                          ADD CONSTRAINT IX_NPM_RoutingNeighbor UNIQUE (

                              [NeighborIdentifier] ASC,

                              [NodeID] ASC,

                              [ProtocolID] ASC)

                      END


                  END

              END


              Next restart the Orion Services using the Orion Service Manager. Monitor the CPU usage.


              If this does not improve we can try disabling Multicast Routing completely:

              1) Ensure you have a good back up of your Database.

              2) Modify pollers table


              Connect to your Database Using SQL Server Management Studio

              Right Click on your Database -> New Query...


                  DELETE FROM Pollers WHERE PollerType LIKE '%Multicast%'


              Click Execute


              Monitor the CPU usage on the Orion Server.

              If this does not help I would recommend upgrading your Orion installation to the latest version 10.6..."

               

              Now I'm upgrade Orion NPM from 10.5 to 10.6, I track CPU loading... while everything is silent