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

ePO - Understanding DB Maintenance Plans & Maximizing DB Performance

I’m writing this in hopes to help out other ePO admins understand the importance of establishing a proper maintenance plan for their DB, understanding that maintenance plan, and other ways to maximize their DB performance. I’ve been a DBA for a number of years and more recently gotten into being an ePO admin as well.

Most of the ePO setups I have come across are not run by DBAs – nor do they have a DBA managing their database. I am not sure if this is just due to a lot of organizations having the requirement to have their ePO setup off the domain, and thus a DBA not looking at it, or just lack or resources and not having a DBA. Either way, not many ePO admins are DBA’s – and that’s OK, but attention is still needed on the DB.

Now, McAfee does a good job of outlining in this McAfee article (KB67184) on how to setup a basic maintenance plan for your ePO DB. But that is about all it does. What does the integrity check actually do? What do you do if it finds something? What if I don’t want to use McAfee’s recommend recovery model? How else can I improve my DB performance?

Attached is to be a guide to understanding and hopefully aiding you in setting up a proper maintenance plan, understanding what to do with that maintenance plan, and other ways to maximize the performance of your DB. Feel free to add to anything on here, or if you have any questions, please ask.

2 Replies
notime
Level 10
Report Inappropriate Content
Message 2 of 3

Re: ePO - Understanding DB Maintenance Plans & Maximizing DB Performance

I would like to say thnak you

Re: ePO - Understanding DB Maintenance Plans & Maximizing DB Performance


notime wrote:



I would like to say thnak you


No problem.. let me know if you have any questions..

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