Re: Online Maintenance
- From: Andy David {MVP} <adavid@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 01 Aug 2007 19:17:32 -0400
On Wed, 1 Aug 2007 16:08:06 -0700, Dan <Dan@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
Hey guys,
After reading some posts yesterday I decided to do some diving into my
event logs in order to see how many online defrags were running in a typical
5-6 day period (events 701 and 703). What I discovered was that some of the
smaller databases were having the defrag's complete several times and the
larger one's were getting fully defragg'ed once or maybe twice over that same
period.
My question is this, should I cut the schedules for the smaller databases
down so they don't have the online maintenance run so often? I was thinking
to limit them to one or two days a week to ensure a single or maybe two
passes in that time frame.
I've been reading that you don't want to run too many scans so I'm thinking
of knocking down the schedules. Sound reasonable?
Thanks,
D
Naw, let it do its thing. It wont hurt you.
.
- Follow-Ups:
- Re: Online Maintenance
- From: John Fullbright
- Re: Online Maintenance
- From: John Fullbright
- Re: Online Maintenance
- Prev by Date: Re: Restrict outgoing message size per domain
- Next by Date: Re: Journal/Outlook/Sort
- Previous by thread: Re: Restrict outgoing message size per domain
- Next by thread: Re: Online Maintenance
- Index(es):
Relevant Pages
|