Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

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

 
discard

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.