cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Highlighted

Help - Solidcore db table .... exploding...

details of the implementation

running since 2014

and in addition to common components we have

a small install with about 1000 clients (700 workstations)

now the issue - in few weeks the DB jumped to 100GB !!!!

and the culprit is

any idea on what to do to clean it - i hardly believe that this is a normal size....

thanks

2 Replies
Highlighted

Re: Help - Solidcore db table .... exploding...

does anyone kows what is scor_async_job table and how to purge/clean it ?

Highlighted

Re: Help - Solidcore db table .... exploding...

Observations from endpoints are initially entered in this table, an internal ePO task runs every few minutes to process the observations, they are then deleted from the table. When the scor_async_job table gets too large the task does not have time to finish and never deletes the rows. You will also see very high traffic on the network between ePO and the SQL server when this is happening too.

I've seen this after an agent handler crash that went unnoticed. The solution in my case was to delete all rows in the table to allow the task to get on top of things.

Create a support ticket and confirm with them the correct action, they will provide the SQL to run to clear the table.

You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community