DB Maintenance/Optimizations

When setting up a DB Maintenance plan, what do users
normally do with the options in the Optimizations tab?
Does it matter what application is using the database?
(In this case, it is Microsoft Business Solutions-
Solomon.) Thanks.It matters if the application is 24 x 7. The optimization routines for the
MP use DBCC DBREINDEX and that will take your table off line for the
duration of the reindexing. If you have a maintenance window for this then
it may not be a problem. I usually suggest creating your own scheduled
jobs that do exactly what you need done and when instead of using the MP.
--
Andrew J. Kelly
SQL Server MVP
"Roger" <anonymous@.discussions.microsoft.com> wrote in message
news:05ca01c3cef5$e589f980$a001280a@.phx.gbl...
> When setting up a DB Maintenance plan, what do users
> normally do with the options in the Optimizations tab?
> Does it matter what application is using the database?
> (In this case, it is Microsoft Business Solutions-
> Solomon.) Thanks.|||Is that Maintenance Wizard an inside joke?
Seems to me it's a great way for less-knowledgeable 'dba's' to get bollixed
up.
Other than that, it's like your appendix - it's there but it serves no
useful purpose.
James Hokes
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23fn3IwxzDHA.3900@.tk2msftngp13.phx.gbl...
> It matters if the application is 24 x 7. The optimization routines for
the
> MP use DBCC DBREINDEX and that will take your table off line for the
> duration of the reindexing. If you have a maintenance window for this
then
> it may not be a problem. I usually suggest creating your own scheduled
> jobs that do exactly what you need done and when instead of using the MP.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Roger" <anonymous@.discussions.microsoft.com> wrote in message
> news:05ca01c3cef5$e589f980$a001280a@.phx.gbl...
> > When setting up a DB Maintenance plan, what do users
> > normally do with the options in the Optimizations tab?
> > Does it matter what application is using the database?
> > (In this case, it is Microsoft Business Solutions-
> > Solomon.) Thanks.
>|||That's what I think the biggest problem of using the Maintenance Wizard is.
When someone new to sqls erver uses the wizard to get going they have no
knowledge of what is actually happening. So if something does go wrong they
are not in a good position to fix it. If they took a few minutes to learn
how to create their own job to do the task they are much more likely to have
a better handle on things overall.
--
Andrew J. Kelly
SQL Server MVP
"James Hokes" <noemail@.noway.com> wrote in message
news:eUkRxb1zDHA.2872@.TK2MSFTNGP09.phx.gbl...
> Is that Maintenance Wizard an inside joke?
> Seems to me it's a great way for less-knowledgeable 'dba's' to get
bollixed
> up.
> Other than that, it's like your appendix - it's there but it serves no
> useful purpose.
> James Hokes
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%23fn3IwxzDHA.3900@.tk2msftngp13.phx.gbl...
> > It matters if the application is 24 x 7. The optimization routines for
> the
> > MP use DBCC DBREINDEX and that will take your table off line for the
> > duration of the reindexing. If you have a maintenance window for this
> then
> > it may not be a problem. I usually suggest creating your own scheduled
> > jobs that do exactly what you need done and when instead of using the
MP.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "Roger" <anonymous@.discussions.microsoft.com> wrote in message
> > news:05ca01c3cef5$e589f980$a001280a@.phx.gbl...
> > > When setting up a DB Maintenance plan, what do users
> > > normally do with the options in the Optimizations tab?
> > > Does it matter what application is using the database?
> > > (In this case, it is Microsoft Business Solutions-
> > > Solomon.) Thanks.
> >
> >
>

DB Maintenance Plan ?

What steps must be taken to ensure that during every
backup the transaction log does not build up? What must
be checked on the Transaction Log tab under the DB
maintaenance plan?
Thanks in advanceChris,
What I do is check the box that says "Remove files older
than:" and put 1 day in the box next to it. Also, I have
it back up the transaction logs every 2 hours so they
don't get huge. Every night we do a backup of the
machine, so I can restore from tape and then backup the
database to any point in time.
Hope this helps.
>--Original Message--
>What steps must be taken to ensure that during every
>backup the transaction log does not build up? What must
>be checked on the Transaction Log tab under the DB
>maintaenance plan?
>Thanks in advance
>.
>|||If once every two hours is not often enough to contain the
size of your tran log file(s), you can increase the
frequency of the log backups. It's not uncommon to backup
the tran log once every 15 minutes.
Linchi
>--Original Message--
>Chris,
>What I do is check the box that says "Remove files older
>than:" and put 1 day in the box next to it. Also, I have
>it back up the transaction logs every 2 hours so they
>don't get huge. Every night we do a backup of the
>machine, so I can restore from tape and then backup the
>database to any point in time.
>Hope this helps.
>
>>--Original Message--
>>What steps must be taken to ensure that during every
>>backup the transaction log does not build up? What must
>>be checked on the Transaction Log tab under the DB
>>maintaenance plan?
>>Thanks in advance
>>.
>.
>|||How can you determine the size of your transactionlog
files?
Thanks for you help.
>--Original Message--
>If once every two hours is not often enough to contain
the
>size of your tran log file(s), you can increase the
>frequency of the log backups. It's not uncommon to backup
>the tran log once every 15 minutes.
>Linchi
>>--Original Message--
>>Chris,
>>What I do is check the box that says "Remove files older
>>than:" and put 1 day in the box next to it. Also, I
have
>>it back up the transaction logs every 2 hours so they
>>don't get huge. Every night we do a backup of the
>>machine, so I can restore from tape and then backup the
>>database to any point in time.
>>Hope this helps.
>>
>>--Original Message--
>>What steps must be taken to ensure that during every
>>backup the transaction log does not build up? What
must
>>be checked on the Transaction Log tab under the DB
>>maintaenance plan?
>>Thanks in advance
>>.
>>.
>.
>