I am using SQL Server for my application and one of the table is very active (insert/delete) and I have to rebuild the index for that table on a regular basis. However, I don't want to stop my application when the index rebuilding is going on. Ideally, I would like to have a script automatically kicked off on a scheduled time.
My question is:
Is there any risk from rebuilding index while my app is actively updating that table? Will my app becomes slow or fails due to DB not responding or is there any risk of DB hung?
Thanks,
Jeff
You app will just wait until the index rebuilding finished as soon as it will try to read or modify the index. Anyway, try to rebuild indexes when your database load is minimal.
No comments:
Post a Comment