SQL2K: DBREINDEX and Locking Table

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL2K: DBREINDEX and Locking Table

Author

Topic

dewacorp.alliances

452 Posts

Posted - 2006-11-17 : 01:49:59

Hi there

My understanding that if you have DBREINDEX running 12 minutes @ 9.30PM, if there is an import to the database and hitting on the table while DBReindex running, will the inserting record hold till the table is unlock or not.

Please clarify this cause I'm thinking to turn off this for temporarily cause we have a migration happening.

Thanks

dewacorp.alliances

452 Posts

Posted - 2006-11-17 : 01:53:46

quote:
Originally posted by valdyv

Hi there

My understanding that if you have DBREINDEX running 12 minutes @ 9.30PM, if there is an import to the database and hitting on the table while DBReindex running, will the inserting record hold till the table is unlock or not?

Please clarify this cause I'm thinking to turn off this for temporarily cause we have a migration happening.

Thanks

Kristen
Test

22859 Posts

Posted - 2006-11-17 : 02:41:34

Use DEFRAG instead of REINDEX as it is non-invasive.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Rebuilding%20Indexes,DBCC%20CHECDB,Reindex,INDEXDEFRAG,Tara%20Blog%20Houskeeping%20Routines

Kristen

Kristen
Test

22859 Posts

Posted - 2006-11-17 : 02:43:32

And see http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=74827 where I already made this suggestion

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources