Useful article on tempdb and the numbers of files required :
tempdb article. I tend to start with just two files and extend if experiencing performance problems simply because I've had a number of cases where tempdb activity is slower spread across lots of small files than running everything against fewer, large files.
No comments:
Post a Comment