We have done DBCC DBREINDEX for our production database which size is about 300 gb, it was running for 12+ hours, but i found that DBCC DBREINDEX is obsolete and recommended approach is using ALTER INDEX command with rebuild, also, we have performance problems right now with database, could it be related to using old method for reindexing ? We have MS SQL Server 2008 (11.2)

  • did the dbcc dbreindex finish or did you kill it? – Tom V Jun 2 '15 at 9:27

As it states on the ALTER INDEX documentation, using ALTER INDEX ...REBUILD is equivalent to DBCC DBREINDEX.

ALTER INDEX has far more functionality in terms of other arguments and DBCC DBREINDEX is deprecated, however the performance issues you face should not be related to using the old method of re-indexing.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.