Re: What is the recommended sequence of maintenance tasks??

Tech-Archive recommends: Fix windows errors by optimizing your registry

I know about the online and logging aspects.

My question is which should be done before the other -- rebuild first
or reorganize first??

The databases involved are all small -- 4 GB or less...and we do have
downtime windows, plus enough space for the logs etc.

Presently we do a weekly maintenance: 1) check db integrity; 2)
rebuild indexes; 3) clean up history.

I'm just wondering how often to do a reorganize or whether to do
rebuild less often and to reorganize every week instead (means also
adding in the statistics task too).

Thank you, Tom

On Aug 22, 2:01 pm, Ekrem Önsoy <ek...@xxxxxxxxxxxx> wrote:
Rebuilding Indexes online is a SQL Server (2005\2008) Enterprise Edition
feature.

You don't have to rebuild or reorganize your indexes unless necessary. These
operations can be costly in resect of your databases and workload. Also,
these are logged operations. Which means, they are going to be recorded in
your Transaction Log file which means IO work. However, if you set your
database's recovery model to Bulk Logged than this burden will not be that
scary. I don't know about your databases nor your indexes, however you want
you keep these cautions in your mind.

Also, offline index rebuilding will lock your related tables and they'll not
be available to your users (to modify data) during this operation.

I suggest you to read (even a little bit) about these operations before
deploying them. So, you'll have a better understanding about their
effects\side effects on your system. You can find good technical info in
Books Online. (http://msdn.microsoft.com/en-us/library/bb418498.aspx)

--
Ekrem Önsoy

"tlyczko" <tlyc...@xxxxxxxxx> wrote in message

news:fda0edf7-48e4-4372-807f-1750cdbbd797@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Presently we have:

Check Database Integrity -- all dbs
Rebuild Index -- all dbs, keep indexes online is UN-checked, job fails
otherwise, SS says this is only for enterprise??
Clean Up History

Should Reorganize Index be included and where??
How does one decide this??

Thank you, Tom

.

Relevant Pages

  • Re: What is the recommended sequence of maintenance tasks??
    ... If you rebuild an index then you don't need to reorganize it. ... Because when you rebuild an index as it's name says, it's rebuilt all over again. ... This depends on the fragmentation of your indexes and if you say that your databases and indexes are not that huge, ... 3- Check Database Integrity ...
    (microsoft.public.sqlserver.setup)
  • Re: Error while rebuilding a text index
    ... Alter index rebuild textidx1; ... Sorry, no, you're not rebuilding this index online as you never told ... Alter index rebuild textidx1 online; ...
    (comp.databases.oracle.server)
  • Re: Error while rebuilding a text index
    ... Alter index rebuild textidx1; ... Oracle you wanted to do that by using the ONLINE directive in the ... ALTER INDEX statement: ... during a rebuild, online or not. ...
    (comp.databases.oracle.server)
  • Re: 9i creating indexes with the ONLINE option
    ... in 9iR2 specifying the ONLINE option? ... This means the rebuild has to wait for all current ... Once current sessions complete, the rebuild starts ... lock - waits for current transactions on the table to ...
    (comp.databases.oracle.server)
  • Re: order of execution in maintenance plans?
    ... If you are on 2005 - do not use the Update Statistics task. ... not to have two resource intensive tasks such as a backup and a reindex ... There is no need to rebuild and reorganize as they do almost the ...
    (microsoft.public.sqlserver.tools)