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
  • Subscription Service Notification (SNS)
  • How-to: Endpoint Removal Tool
  • Support: Endpoint Security
  • eSupport: Policy Orchestrator