x

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, 2010 at 06:16 AM in Default

avatar image

Apeman
311 13 15 19

(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, 2010 at 03:45 PM

avatar image

Jeff Moden
1.9k 3 7 12

(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, 2010 at 06:24 AM

avatar image

Kev Riley ♦♦
64k 48 61 81

(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.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x72
x46

asked: Mar 31, 2010 at 06:16 AM

Seen: 2074 times

Last Updated: Mar 31, 2010 at 06:16 AM

Copyright 2016 Redgate Software. Privacy Policy