By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,265 Members | 1,333 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,265 IT Pros & Developers. It's quick & easy.

Third party reindexing utilities

P: n/a
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.

Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.