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.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉