Nadrek (1/14/2014)
For adding multiple tempdb files, if you're not going to support spreading them out over multiple spindles, I'd at least get the current tempdb location out of sys.master_files or similar and put the new files in the same place.
This is how the article gets misunderstood. Its not recommending to put the files on separate disks they're all in the same filegroup. You're simply creating multiple files on the same disk to alleviate the meta page contention.
Spreading files across multiple disks is designed to relieve storage I\O contention, different things altogether.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉