up vote 1 down vote favorite
share [g+] share [fb]

When we setup multiple data files for tempdb I understand SQL Server uses a Proportional Fill algorithm. How does it work? Does it use the same method for user databases aswell.

I have tried to understand it using the SQL Internals Viewer but was unable to get consistent results and hence am a bit confused.

link|improve this question
feedback

1 Answer

up vote 2 down vote accepted

It does use the same fill mechanism as user databases. It basically uses a proportional "round robin" format. You can read the BOL version of how it works here: http://msdn.microsoft.com/en-us/library/ms187087.aspx

link|improve this answer
Thanks for the pointer Scott, I'll verify the explaination on the link for tempdb tomorrow and feedback. – Chirag Sep 8 '09 at 20:09
I tested the theory with same sized tempdb data files. It is all good with Same size files though there is still a minor point as to whether the proportional fill is based on available free space or the actual data file size. Rest all tallys with the explaination. – Chirag Sep 11 '09 at 21:53
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.