October 18, 2007 at 8:14 am
Hi,
We have sql 2000 what is the normal time for dbcc dbreindex command to complete exceution & if it takes long time whats the problem
October 18, 2007 at 8:38 am
Hi - that depends on the size of the indexes that need to be recreated, also filesystem fragmentation can play a role (a defragged filesystem speeds that up a bit). It´s an I/O heavy operation that locks the reindexed tables and makes heavy use of tempdb - hth 🙂
October 18, 2007 at 8:40 am
How large is your database? How large are the tables? How many indexes do you have? How fragmented are the indexes? How low is the load on your database when you are planning to run dbreindex. How fast disks your tempdb is on? All of these questions influence the time dbreindex will need. Are you experiencing longer execution times than you were expecting?
Regards,
Andras
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply