We added additional temp data files to match our 8 cores. We were expecting performance improvement after adding the files but instead the jobs are taking longer than before. We always encountered the I/O request on this drive where the temp files reside. We have enough memory. Temp data and log files are on the same drive. User databases data and log files are on different drives. Nothing major changed after adding temp datafiles but we see low in performance.
I need help with this issue.