sql 2005 tempdb question

[kodaksmile]

Quick question - I added 7 tempdb files for a total of eight to match the number of cpu's on the server however, I noticed only 1 file is growing. Is there another setting that needs to be updated so that all files are used? I had read that it was recommended to increase the number of files to improve performance however, it doesn't seem that performance would be improved unless all the files were used. Thoughts?

 

[JayKusch]

It will depend on how large the files were made.

SQL will use the extra files in most cases (but not always).

I would suspect over time it will all equal out unless you have a couple CPU that are referenced more often for one reason or another thus the file growth


Thanks

J. Kusch

 

[mrdenny]

Make sure that all 8 files are the same size, and are set to grow by the same amount (it should be a fixed size not a percent). If they aren't the same size SQL will not use all the files.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog