cancel
Showing results for 
Search instead for 
Did you mean: 
patu
Level 7
Report Inappropriate Content
Message 1 of 2

Clean Database

Hi,

My existing ePO server is performance slow and Database is exceed 100GB. McAfee support told me that it not healthy, overload and it might corrupted. (ePO and DB are separate server, same subnet different IP.) I have a migration plan which migrate existing ePO to higher spec server. Hostname and Ip remain the same. What im concern is, The issue will still remain even if ePO server had migrated to higher spec server, as the Database size still exceed 100GB. Therefore, i plan to reinstall my database or purge not necessary event. After reinstall/purge event(except agent info.), i need all agent still able contact to ePO server. Is it possible to achieve this goal? As i need a permenant solution to solve this issue, the best way is reinstall the database. Kindly need you advice.

Thank you

1 Reply

Re: Clean Database

Purge the events you do not need first, then see how much space you save and also if the performance improves.

You should also check to see if it's the Sql transaction log that is big rather than the actual database. If it's the transaction log, then truncate it - we don't use it for recovery with ePO.

You don't say which version of ePO or Sql is used, but you might also want to run some basic database maintenance too.

Perhaps use the sqlmaint utlity to rebuild the indexes and squish the dead space in the database.

See how you are after all that before thinking about moving ePO.

Rgds,

Rob.

More McAfee Tools to Help You

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