DBCC DBREINDEX 20 Hours and counting....HELP!!
Posted on 2008-06-18
I'm running SQL Server 2000 Enterprise Edition. HP Proliant , Quad 3.6Mhz, 8GB RAM, RAID 5, 4 146GB 15k rotational speed drives. The RAID controller died a week ago and I replaced it and everything came up without issue. I could issue a query and get results.
Since the server has been back up, an insert into a 105 million row table of 1,000 records is taking 15 minutes. It used to take 10 seconds. I have detailed process logs that track the duration and in three years it's never taken more than 20 seconds. Also, the weekly Backup Exec SQL "pre-process" never completed and I cancelled it at 35 hours. It used to take 30 minutes. Backup Exec is able to backup small (500MB) databases from the same server without issue.
I thought of corruption so I ran DBCC CHECKTABLE ('inv_detail', repair_fast) and it ran in 23 minutes and found no errors. Since a reindex had not been done in a few months I started a DBCC DBREINDEX. I wrongly assumed I would get status as it completed each index as the Book OnLine shows. It does not.
I'm 20 hours into the reindex and if I'm only through the first index I need to stop and use another approach. If I kill the process how long will the kill process take? Will I leave thousands of pages marked as allocated wrongly? How can I figure out what indecies are complete? How can I stop and keep the indecies that are complete?
I am 3 days late on monthly invoicing already. Not good.