• Gilla thanks for quick explanation. We had microsoft vendor who came in past and recommended to use 8 data files of equal size as we have lot of tempdb contention issues. Also, I am looking at the following article "http://support.microsoft.com/kb/328551" and it is recommending the same. We are no more in finance to get new hardware. So, the thought is to divide the .mdf files into two drives and to place .ldf into one of the drives with around 5 GB and have mdf's around 70 GB of each and setting no autogrowth.