Document the tempdb usage by UPDATE STATISTICS

Welcome, guest Sign in | Your Profile | Help

HOME

YOUR DASHBOARD

CONNECTION DIRECTORY

SQL Server Home Downloads Feedback Surveys

Document the tempdb usage by UPDATE STATISTICS by Linchi

Active

Type:	Suggestion
ID:	483247
Opened:	8/16/2009 6:09:28 PM
Access Restriction:	Public

Workaround(s)

view

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.

Details (expand)

English

SQL Engine

Document how UPDATE STATISTICS may use tempdb.

Improved Performance

0 attachments

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.