Perry Whittle (1/14/2014)
growing data files in 64MB chunks is a really bad idea. Ideally create them to the size required including a little for contingency measures. If you must autogrow files and you have followed the best practice for enabling "Perform volume maintenance tasks" local policy for the sql service account, grow the files in at least 512MB or 1GB increments.Personally, don't touch TEMPDB unless you can confirm you're hitting allocation issues.
Hi Perry
Shown numeric values, along with file paths, are just "illustrative". Anyway I'm glad you brought this to our attention. Regarding "Perform volume maintenace tasks" please see article http://tinyurl.com/osyg7au
Required size, contigency, safety factors, as you probably know already are always kind of subjective.
Regards,
--
Paulo