Post reply

Update statistics

  • October 14, 2013 at 2:40 pm

    #284502

    During maintenance plans (means dbcc checkdb,update statistics and index rebuild) will increase I/O workload?

    Thanks

  • October 14, 2013 at 2:58 pm

    #1658354

    Yes, all this operations are generating much IO, and should be performed during a maintenance window

  • October 15, 2013 at 1:14 am

    #1658414

    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?

    [font="Times New Roman"]There's no kill switch on awesome![/font]

  • October 15, 2013 at 7:57 am

    #1658533

    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