☰
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Former Member
Not applicable
Report Inappropriate Content
Message 1 of 3
‎11-25-2018 02:32 AM

EPO 5.3.2 , DATABASE optimization ?

Jump to solution

Hello,

 

Do you have any suggestions or tools to optimize our server database ?

I'm taking about the database it self, right now the DB size is :219539.31 MB. (213GB ~)

Do we have any optimization sql queries or any thing you have heared ?

 

 

Please advice.

 

Alexey.

0 Kudos
Reply
2 Solutions

Accepted Solutions
SWISS
Reliable Contributor
Reliable Contributor
Report Inappropriate Content
Message 3 of 3
‎11-26-2018 07:12 AM

Re: EPO 5.3.2 , DATABASE optimization ?

Jump to solution

Wrote down some stuff during years of EPO managment with Standard and SQL Express.

Always the same problem too many Events too much data in the SQL's.

1) Start what you can DO in GUI (Web from Mcafee)

2) IF EPO fails or too slow use SQL Management Studio

3) IF SQL GUI fails use osql.exe cmd line tool

https://www.butsch.ch/post/Mcafee-EPO-Server-4X-Database-or-Space-growing-EPOevents.aspx

https://www.butsch.ch/post/MCAFEE-EPO-SQL-shrink-large-files-in-small-steps.aspx

http://www.butsch.ch/post/McAfee-EPO-Server-SQL-Server-Performance-tips.aspx

 

Greetings from Switzerland

View solution in original post

0 Kudos
Reply
2 Replies
SWISS
Reliable Contributor
Reliable Contributor
Report Inappropriate Content
Message 3 of 3
‎11-26-2018 07:12 AM

Re: EPO 5.3.2 , DATABASE optimization ?

Jump to solution

Wrote down some stuff during years of EPO managment with Standard and SQL Express.

Always the same problem too many Events too much data in the SQL's.

1) Start what you can DO in GUI (Web from Mcafee)

2) IF EPO fails or too slow use SQL Management Studio

3) IF SQL GUI fails use osql.exe cmd line tool

https://www.butsch.ch/post/Mcafee-EPO-Server-4X-Database-or-Space-growing-EPOevents.aspx

https://www.butsch.ch/post/MCAFEE-EPO-SQL-shrink-large-files-in-small-steps.aspx

http://www.butsch.ch/post/McAfee-EPO-Server-SQL-Server-Performance-tips.aspx

 

Greetings from Switzerland
0 Kudos
Reply
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 our Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

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

TrellixSkyhigh Security | Support Trellix.com SkyhighSecurity.com

Legal Privacy Copyright © 2023 Musarubra US LLC