cancel
Showing results for 
Search instead for 
Did you mean: 

ePO Database size?

I need to get an estimate of how big my ePO database will be for approx. 4000 users/machines using ePO 5.3?

does anyone have any suggestions?

I currently have an ePO4.6 install and our database has increased to 35gb at the moment but don't think this is a realistic size!

thanks

Lawson

6 Replies
Reliable Contributor exbrit
Reliable Contributor
Report Inappropriate Content
Message 2 of 7

Re: ePO Database size?

Moved from Community Interface Help to Business > ePO for better attention.

---

Peter

Moderator

shaya
Level 7
Report Inappropriate Content
Message 3 of 7

Re: ePO Database size?

It's depend which product are using? VSE/DLP/HIPS etc. each product can increase the database size.

see this

https://kc.mcafee.com/corporate/index?page=content&id=KB52116

Try first to reduce the size of the db.

Highlighted
ajha1
Level 9
Report Inappropriate Content
Message 4 of 7

Re: ePO Database size?

I would suggest to run below SQL Query on ePO DB, to find out the top 10 events which are filling up you ePo DB

select top  10 E.ThreatEventid, EF.Description , Count(E.ThreatEventID) from epoevents E inner join EPOEventfilterDesc EF

ON E.ThreateventID = EF.EventID

Where EF.Language = '0409'

group by E.ThreatEventid, EF.Description

order by Count(e.ThreatEventID) Desc

This is will help you to understand, which product is generating high events. If you have expertise in SQL, You can further play around and find out the machine which is generating more events.

You future reference, review the below articles:

1. Recommended maintenance plan for ePO 4.x database using SQL Server Management Studio (KB67184)
[https://kc.mcafee.com/corporate/index?page=content&id=KB67184]

Also recommend to the below URLs to keep the ePO and DB in good health


2.  ePO Ecosystem Health
https://community.mcafee.com/people/petersimmons/blog/2012/08/27/epo-ecosystem-health

3. Database Maintenance: Part 1
https://community.mcafee.com/people/petersimmons/blog/2012/09/06/database-maintenance-part-1

4. Database Maintenance: Part 2
https://community.mcafee.com/people/petersimmons/blog/2012/09/17/database-maintenance-part-2

NOTE: ePO 4.6.x has reached EOL on 31st Dec 2015 and McAfee strongly recommends to upgrade ePO to Supported version ie; 5.1.x or later. version 5.3.1 is latest version.

Regards,

AJ

Reliable Contributor andrep1
Reliable Contributor
Report Inappropriate Content
Message 5 of 7

Re: ePO Database size?

Just wondering what you mean by realistic ? Your db is 35GB, so that is a fact as real as it can be.

Controlling DB size is two things: purge data using purge server tasks and product tuning where you reduce the events generate at the source (products)

Re: ePO Database size?

My DB is approximately 35gb as an average, but its pretty stable - the only time it went to 140gb was due to a problem.

I have about 7000 machines.

Reliable Contributor Troja
Reliable Contributor
Report Inappropriate Content
Message 7 of 7

Re: ePO Database size?

Hi all,

my customers are using EPO Environments with a DB size more than 100GB. From my Point of view there are some cirsumstances which can affect your database size. YOu can use different Support documents for databse sizing. But at the end of the day it depends on your configuration.

- The managed products (VSE/HIPS/Application Control.....)

- The product Settings: One customer generated 4 Million Events per hour with one wrong Access protection rule.

- How log the Events should be stored.

If your database grows to a high value, as described, take a look which Events are filling your database. Based on the Events you can see which product and which Setting are generating the Events.

Cheers

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