Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
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:

share|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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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