Checking and Indexing

31 Mar 2006 1:27 AM

Amir Marathonian

Hi,

Does running the SQL maintenance tools such as indexing and checking while
users are using the database cause problems?

Thanks

31 Mar 2006 1:42 PM

Andrew J. Kelly

Any maintenance activity such as DBCC CHECKDB and DBREINDEX will have some
effect due to their resource intensive nature. But DBCC CHECKDB can be run
while users are accessing the system without stopping normal access to the
tables. The system may be slower due to the CPU usage of the command but it
will not prevent them altogether. DBCC DBREINDEX on the other hand will
stop any access to the table it is currently working on. From the time it
starts to reindex anything in that table it takes an exclusive table lock
and holds it until it finish's with that table.

--
Andrew J. Kelly SQL MVP

Show quote

"Amir Marathonian" <AmirMarathon***@discussions.microsoft.com> wrote in
message news:193BC0D7-1BF7-415B-8B74-1FBCBC4C649F@microsoft.com...
> Hi,
>
> Does running the SQL maintenance tools such as indexing and checking while
> users are using the database cause problems?
>
> Thanks