Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
james_wells
Yak Posting Veteran
55 Posts |
 Posted - 2010-04-09 : 05:50:35
|
| When dividing the TEMPDB into multiple files to match the number of cores only the initial file seems to be growing and the rest of the data files that make up the tempDB have remained unchanged in size to date.This machine is not currently in production and therefore there has been a limited number of users on the system. My question is about the workings of SQL "Proportional Fill Methology".When pages are allocated from the TEMPDB to a core process are all the pages allocated from the same TEMPDB data file starting with the first data file and then the next process requiring TEMPDB data pages would be allocated from the second data file and so on which is more like load balancing then proportional fill.If so this would mean that the latter files that make up the TEMPDB would never grow as much as the first few files in the TEMPDB itself.Or is it supposed to allocate pages from all the TEMPDB data files as evenly as possible and does it always start with the initial data file regardless of size which also would have a baring on which TEMPDB file grows first.Although this means that the TEMPDB data files are too small to start with which can be fixed however i am more interested in how SQL proportional fill works |
|
|
|
|
|
TempDB proportional fill workings