question

molly avatar image
molly asked

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 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.

performance-tuning
i-o-temp.jpg (135.9 KiB)
3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·

Were you seeing this message before adding tempdb files?

What can you tell us about the G: drive ? Is it local to the server or on a SAN? Is it a traditional HDD or an SSD? Is it dedicated to tempdb, or are there other files on there?

What version of SQL Server is running?

0 Likes 0 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·

You've put all the temp devices on the same drive? Why not spread them around a bit?

0 Likes 0 ·
molly avatar image molly commented ·

G: Drive is just solely dedicated to the temp files. It is on SAN.Drives are spinning disks. SQL Server- 2012 Enterprise version.

If I have to spread the files, Can I move the temp log file with User database's log drive?

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.