Third party reindexing utilities

[ceadtinneh]

Folks,

I work on a system which is growing rapidly, with the number of
transactions we process growing on a daily basis. While this is good
news or the business, maintenance is starting to become an issue as the
database is the backend for a website which cannot be down for a
lengthy period of time.

While I do defrag the indexes, periodically the indexes do need to be
rebuilt. When this happens, the process locks pages and transactions
start getting bounced out.

Are their any third party utilities which will rebuild an index
without this locking occuring? Any help in pointing me in the right
direction would be appreciated.

[Erland Sommarskog]

ceadtinneh (su*****@yahoo.com) writes:

I work on a system which is growing rapidly, with the number of
transactions we process growing on a daily basis. While this is good
news or the business, maintenance is starting to become an issue as the
database is the backend for a website which cannot be down for a
lengthy period of time.

While I do defrag the indexes, periodically the indexes do need to be
rebuilt. When this happens, the process locks pages and transactions
start getting bounced out.

Are their any third party utilities which will rebuild an index
without this locking occuring? Any help in pointing me in the right
direction would be appreciated.

I doubt that there is a third-party product that rebuilds indexes,
since this is something that requires communication with the storage
engine from within.

Have you looked at DBCC INDEXDEFRAG? This is a online operation and does
not lock out users.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp