Document the tempdb usage by UPDATE STATISTICS - by Linchi Shea

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


17
0
Sign in
to vote
ID 483247 Comments
Status Closed Workarounds
Type Suggestion Repros 1
Opened 8/16/2009 6:09:28 PM
Access Restriction Public

Description

UPDATE STATISTICS may use tempdb. But this fact is not documented. Given the importance of the tempdb performance, how tempdb is used by UPDATE STATISTICS should be documented.

Additional info can be found here: http://sqlblog.com/blogs/linchi_shea/archive/2009/08/16/performance-impact-tempdb-and-update-stats.aspx.
Sign in to post a comment.
Posted by Microsoft on 4/6/2010 at 12:37 PM
After consulting developers, I added variations of the following sentence to the CREATE STATISTICS, UPDATE STATISTICS, and Capacity Planning for tempdb topics.
CREATE STATISTICS can use tempdb to sort the sample of rows for building
statistics.
And resolved the bug. Thank you for submitting it.
Posted by alphatross on 8/17/2009 at 5:47 AM
Agree - a one-liner in BOL for the UPDATE STATISTICS syntax would suffice. Even better would be an entry in BOL on what internal operations make use of tempdb.