Thank you for the information.
As you said that if I have 8 processor and I have 8 tempdb datafiles, then each processor will use one file. I just want to know, do I need to do anything to assign one file for one processor or SQL server will automatically assign one processor for one file.
My second question is how can I assign the file size if autogrowth is off for all the files. How to measure the size?
Ryan
//All our dreams can come true, if we have the courage to pursue them//