October 9, 2007 at 2:09 am
Hi All,
Our company is doing monthly reboot activity and our infrastructure team is asking whether they are allowed to start up the websphere applications while we are doing the reindexing.
Appreciate all your feedback and comments.
Cheers
October 9, 2007 at 5:59 am
If you're using SQL Server 2000, then DBCC DBREINDEX will lock the table it's indexing. That means you're likely to encounter timeouts and so on in your application as it tries to access data in tables that are locked.
John
October 9, 2007 at 6:09 am
it depends upon a number of factors, such as table size and how fast your disk subsystem is and how busy the application is. Mostly index rebuilds are kept short in this situation. You might want to consider doing a selective index rebuild - check out dbcc showcontig in BOL for an example; however dbcc showcontig is intrusive so you might want to restore your database elsewhere and run the analysis on the copy and then apply to live.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
October 9, 2007 at 8:15 am
Bottom line is you can. You won't hurt the database server or data, but users might have app issues.
October 9, 2007 at 6:57 pm
Hi Steve,
Thanks for your response. I'll inform our infra team accordingly.
Cheers
October 9, 2007 at 10:42 pm
There is also the possibility that your application willl open a connection to the database that prevents your reindex, etc. from completing. If at all possible I would recommend taking the database server undergoing maintenance off-line until the reindex, etc. complete.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply