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.
| Author |
Topic |
|
1384
Starting Member
9 Posts |
 Posted - 2006-09-15 : 10:24:23
|
| I understand that this is an offline process. However, what happens when this is executed without database exclusivity? Does it simply pass over tables that are in use? The reason I ask is that my company has a nightly cleanup process that runs DBREINDEX on fragmented tables. At times I have noticed that processes have been run concurrent with this. Moving forward I will make sure the system is not being used while DBREINDEX is running. However, I wanted to get an understanding of the impact of running this in that manner historically. Any insight would be appreciated. Thanks. |
|
|
Luis Martin
Yak Posting Veteran
54 Posts |
Posted - 2006-09-15 : 10:28:59
|
| If you are running DBREINDEX, suppose with table "X1", and other user, job, etc., try to work with the same table you will have a lock there. |
 |
|
|
1384
Starting Member
9 Posts |
Posted - 2006-09-15 : 11:26:19
|
| Thanks Luis. For a related question, now say you are running an automated cleanup routine. This script runs DBREINDEX on table 'A', completes that reindex, and attempts to move on to table 'B'. However, table 'B' is currently being used by another process. Given this scenario, does DBREINDEX abort, disregard B1 (because it is in use), and move on to reindex table 'C'? Does it compete? What happens here. |
|
|
|
Kristen
Test
22859 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
1384
Starting Member
9 Posts |
Posted - 2006-09-15 : 13:35:34
|
| Lots of excellent advice! Thank you! |
|
|
|
|
|
|
|
|
DBCC DBREINDEX Question