Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Statistics Collection Expand / Collapse
Posted Thursday, November 13, 2008 8:53 AM


Group: General Forum Members
Last Login: Thursday, December 22, 2011 7:03 AM
Points: 104, Visits: 272

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?

Post #602194
Posted Thursday, November 13, 2008 9:36 AM



Group: General Forum Members
Last Login: Yesterday @ 5:58 PM
Points: 41,313, Visits: 37,901

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 2008, MVP
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

Post #602227
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse