cancel
Showing results for 
Search instead for 
Did you mean: 

ePO 5.10 SQL Database "_Events" large

Jump to solution

Hi,

since the upgrade from ePO 5.9 to 5.10 we noticed a new Database. Database size is 12GB.
What about that database? How to shrink it?

Regular sjhrinking does not work, because minimum filesize of each "monthly file" is set to 1GB.
I realy do not want a 12GB default event-database. 😉

 

Regards
Daniel

1 Solution

Accepted Solutions

Re: ePO 5.10 SQL Database "_Events" large

Jump to solution

OK, so now - after speaking to the american McAfee support I have the facts, I need.

- The new "ePO_Servername_Events" Database is just a split-off from the events-tables, which resided in the regular "ePO_Servername" Database

- Because of flooding-problems in the past (thousands of generated events in special situations), McAfee decided to create a new database and store the events inside, so that the "productive" ePO database stays as small as possible

- The initial size of _Events database is variable. If you use SQL-Express, the created DB-Files are about 100MB (x12 for each month), if you use a regular SQL Server, they where about 1GB(!) each file - so 12GB in total

- Resizing the files minimum usage from 1GB to 8MB is no problem - as we did. That intuitive change we made was right

 

View solution in original post

3 Replies
McAfee Employee cdinet
McAfee Employee
Report Inappropriate Content
Message 2 of 4

Re: ePO 5.10 SQL Database "_Events" large

Jump to solution

You control the size of that by purging events in epo via server tasks.  You can purge audit logs, client and threat events, server task log, etc.  It can also be controlled by what events are sent to epo.  For example, in server settings, event filtering, you can disable unwanted events.  Also, in your policy settings for point products, such as vse or ens, you can control access protection events that get sent by enabling/disabling reporting for those events.  If you don't use the info from certain event types, it does you no good to store them.  It is also not advised to limit the size of the database.  It is normal for events to take up a lot of space, depending on how many systems you are managing, number of products installed and the settings for each regarding which events are sent. 

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

Re: ePO 5.10 SQL Database "_Events" large

Jump to solution

Hello cdinet,

don't get me wrong, but your answer is some kind of generic.
I know that already. 

It's not regarding the regular events. It is regarding the new *database* since 5.10(?) called
"ePO_SERVERNAME_Events. It creates files for every month with 1GB space!

 

ePO-before.JPG

Since I did not find a single answer in the documentation (is there one?) or in the KB,
I cleared it up by reducing the minimal size of the files from 1GB to 8MB minimum size.

Where may I find informations regarding that new created database and how to handle it?


Regards
Daniel

Re: ePO 5.10 SQL Database "_Events" large

Jump to solution

OK, so now - after speaking to the american McAfee support I have the facts, I need.

- The new "ePO_Servername_Events" Database is just a split-off from the events-tables, which resided in the regular "ePO_Servername" Database

- Because of flooding-problems in the past (thousands of generated events in special situations), McAfee decided to create a new database and store the events inside, so that the "productive" ePO database stays as small as possible

- The initial size of _Events database is variable. If you use SQL-Express, the created DB-Files are about 100MB (x12 for each month), if you use a regular SQL Server, they where about 1GB(!) each file - so 12GB in total

- Resizing the files minimum usage from 1GB to 8MB is no problem - as we did. That intuitive change we made was right

 

View solution in original post

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