cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
petermason Reliable Contributor
Reliable Contributor
Report Inappropriate Content
Message 1 of 5

Database Tuning - Manual V's Automated

Hi All,

Is anyone using the automated tuning feature to perform their database tuning? If so have you encountered any issues with it?

Does it take longer than performing manual tuning?

Please share any advice or comments you have on manual or automated tuning and your experiences with it.

Thanks

Peter

4 Replies
petermason Reliable Contributor
Reliable Contributor
Report Inappropriate Content
Message 2 of 5

Re: Database Tuning - Manual V's Automated

It seems that the only way to tune large DB's is off line. The tuning task will fail after 4 hours if it is run online.

d_aloy Reliable Contributor
Reliable Contributor
Report Inappropriate Content
Message 3 of 5

Re: Database Tuning - Manual V's Automated

Hi Peter

Base don my own experience, automated db tuning works fine.

However we still see the requirement or running a manual purge every now and then (2-3 months) to keep the db size within limits

Regards

David

petermason Reliable Contributor
Reliable Contributor
Report Inappropriate Content
Message 4 of 5

Re: Database Tuning - Manual V's Automated

Hi David,

Thanks for your reply.

How large are your databases and how long does the tuning process take on them?

Regards

Peter

d_aloy Reliable Contributor
Reliable Contributor
Report Inappropriate Content
Message 5 of 5

Re: Database Tuning - Manual V's Automated

Hi Peter

Apologies for the (very) delayed response.

We've had 50-60GB databases going down to 15GB after manual purge with tuning. The process takes about an hour or a bit more depending on how big is the db when starting.

Regards

David

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 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