SolarWinds.DataProcessor.exe *32 very high CPU utilization

Hi,

is this caused by upgrade?

From which version you upgraded?

Do you receive a lot of traps or syslogs?

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

The problem was solved by an upgrade to NPM v10.6.