Perry Whittle (1/15/2014)
Paulo A. Nascimento (1/15/2014)
Well if tempdb database was, say, 640 MB in size, then that would not seem strange to me :-). 64 MB is exactly exactly 10% of the size of tempdb.Ah the old 10% theory I wondered when this little scallywag would rear its head. Bad idea, period.
Growing in small increments not only stalls writes due to the continual file growth operations but the fragmentation at the physical file level becomes an issue too.
Ideally you don't want tempdb to grow if it does then certainly not in small increments.
The 10% theory is an old and good one, as long one doesn't take it literally.
As already said, data file growth is not an issue if Instant File Initialization is used (available since W2K3) as the growth operations is instantaneous with no performance penalties. The concern should always be put in not using percentual file growth.