Customization of automatic statistics update - by Stefano Takamatsu

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 801214 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 9/17/2013 12:31:13 PM
Access Restriction Public


Trace Flag 2371 was a huge advance to statistics sampling in SQL Server 2008 R2, but it would be extremely useful to know more about those thresholds (ex: with this 2371 flag enabled, EXACTLY how many rows need to be updated in order to trigger the automatic update of statistics in a 1-million row table? What is the equation?)

Also, it would be useful to set the % of rows changed to trigger the statistics update in specific tables.  I have a nightly job that update the statistics in some extreme-DML tables, but if i could set this thru Management Studio, it would be great.
Sign in to post a comment.
Posted by Argenis Fernandez on 2/11/2014 at 8:50 AM
There's this explanation: - looks like it's indeed SQRT(1000 * NumRows)
Posted by Manbeen [MSFT] on 9/19/2013 at 5:46 PM
Thank you for submitting this feedback. We are investigating the issue and will update you when we have more information.