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.