Post reply

Statistics Collection

  • November 13, 2008 at 8:53 am

    #126875

    Hi,

    How does update statistics mechanism work in sql server 2000 and 2005?

    Does engine collect data in a periodic time? How often it collects? Can i change this period, how?

    How can i update statistics at the moment?

    Thanks.

  • November 13, 2008 at 9:36 am

    #898176

    http://sqlinthewild.co.za/index.php/2008/11/04/what-are-statistics-and-why-do-we-need-them/

    You can't change the frequency. The % of changes that kicks off a stats update is hardcoded. You can update stats manually using UPDATE STATISTICS.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply