SQL Server Performance

'Auto Update statistics' make performace degrade

Discussion in 'General DBA Questions' started by aaronsandy, Mar 21, 2005.

  1. aaronsandy New Member

    Does setting 'Auto Update statistics' On , make performace degradation.As I am wondering that keeping this option on can make the server run 'update statistics' even during the busiest time of the day.How the sql server choose when to schedule such tasks?
  2. satya Moderator

    The auto update statistics option can slow down your system, but don't disable the option simply because you're concerned that it might affect performance.

    If you load a lot of data into a table during a peak processing period, SQL Server's automatic statistics update on that table might further degrade performance.

    Take help of this KBAhttp://support.microsoft.com/support/kb/articles/Q195/5/65.ASP to know how autostats will work.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page