August 1, 2002 at 4:38 pm
I'm running SQL server 7.0 service pack 3 on NT 4.0 sp6A. Can I run a reindex while my system is in production or will it cause a significant performance problem. Some of the tables are rather large and frequently accessed.
August 1, 2002 at 8:36 pm
You can rebuild the indexes while the system is online, but it can cause performance issues. How much of a performance hit is dependent upon the size of the files making up the indexes, the number of records, and the hardware, so it's really dependent on the environment.
Typically the best thing to do is to reindex during a period of light activity if the system is up "24 x 7." We run ours during weekend hours where few users are on the system.
K. Brian Kelley
http://qa.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply