Home Dashboard Directory Help
Search

Customization of automatic statistics update by Stefano Takamatsu


Status: 

Active


3
0
Sign in
to vote
Type: Suggestion
ID: 801214
Opened: 9/17/2013 12:31:13 PM
Access Restriction: Public
0
Workaround(s)
view

Description

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.
Details
Sign in to post a comment.
Posted by Argenis Fernandez on 2/11/2014 at 8:50 AM
There's this explanation: http://blogs.msdn.com/b/srgolla/archive/2012/09/04/sql-server-statistics-explained.aspx - looks like it's indeed SQRT(1000 * NumRows)
Posted by Microsoft 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.
Sign in to post a workaround.