October 14, 2013 at 2:40 pm
During maintenance plans (means dbcc checkdb,update statistics and index rebuild) will increase I/O workload?
Thanks
October 14, 2013 at 2:58 pm
Yes, all this operations are generating much IO, and should be performed during a maintenance window
October 15, 2013 at 1:14 am
depends on how big your tables/indexes/stats are. For example I have an instance with 15 dbs on it, each db around 5-6gb in size and updating stats using sp_updatestats takes < 1 min in total. If done during a maint window is it really going to cause much of a problem?
October 15, 2013 at 7:57 am
checkdb and index rebuild are I/O intensive.
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy