question

Apeman avatar image
Apeman asked

Statistics on Tempdb

I discovered that "auto create statistics" and "auto update statistics" are enabled on Tempdb. Since no large tables / indexes are created in Tempdb (in my environment) I was wondering if statistics maintenance was necessary. It saves some resources...

Note: MSSQL 2005 x64, SP3, Hf7

tempdbstatistics
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Jeff Moden avatar image
Jeff Moden answered

You and your people aren't the only ones that use TempDB. It is the lifeblood of SQL Server right along with memory. I wouldn't touch any of the factory default settings on TempDB except for Growth settings.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered

See some of the discussion here : http://ask.sqlservercentral.com/questions/5109

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.