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

more ▼

asked Mar 31 '10 at 06:16 AM in Default

Apeman gravatar image

311 12 13 15

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.

more ▼

answered Apr 10 '10 at 03:45 PM

Jeff Moden gravatar image

Jeff Moden
1.7k 2 8

(comments are locked)
10|1200 characters needed characters left

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

more ▼

answered Mar 31 '10 at 06:24 AM

Kev Riley gravatar image

Kev Riley ♦♦
50.7k 43 49 76

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 31 '10 at 06:16 AM

Seen: 1750 times

Last Updated: Mar 31 '10 at 06:16 AM