cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

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.

2 Solutions

Accepted Solutions
McAfee Employee hem
McAfee Employee
Report Inappropriate Content
Message 2 of 3

Re: EPO 5.3.2 , DATABASE optimization ?

Jump to solution

Performance optimizer.

 

https://kc.mcafee.com/resources/sites/MCAFEE/content/live/PRODUCT_DOCUMENTATION/26000/PD26602/en_US/...

 

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

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?please select Accept as Solution in my reply and together we can help other members?
Reliable Contributor SWISS
Reliable Contributor
Report Inappropriate Content
Message 3 of 3

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

 

2 Replies
McAfee Employee hem
McAfee Employee
Report Inappropriate Content
Message 2 of 3

Re: EPO 5.3.2 , DATABASE optimization ?

Jump to solution

Performance optimizer.

 

https://kc.mcafee.com/resources/sites/MCAFEE/content/live/PRODUCT_DOCUMENTATION/26000/PD26602/en_US/...

 

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

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?please select Accept as Solution in my reply and together we can help other members?
Reliable Contributor SWISS
Reliable Contributor
Report Inappropriate Content
Message 3 of 3

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

 

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