Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
egemen_ates
Yak Posting Veteran
76 Posts |
 Posted - 2012-11-07 : 09:14:48
|
| Hello ;im sorry my english is not very well.my question explain via example,for example;I have one disck C:/,I have one data file for tempdb.ihave 4 processor.I think ;tempdb separate 4 data file tempdb.mdf,tempdb1.ndf,tempdb2.ndf,tempdb3.ndfso is this scenario provide advantage by performance ? |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-11-07 : 13:15:51
|
| You should do that, but it is doubtful that it will improve your perfomance at all. Given your configuration, I suspect disk latency to be your perfomance bottleneck, not tempdb contention.-Chad |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2012-11-08 : 16:33:08
|
| Are you seeing any type of contention in tempdb? Does your system utilize tempdb a lot with a lot of connections all creating temp tables continuously?The only reason you create multiple tempdb files is to eliminate contention on tempdb, unless you are creating multiple files across multiple drives then you are not going to see any performance improvements. |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-11-09 : 02:41:01
|
| I would do it regardless if you actually have contention or not. There is no downside, and you would rather be proactive than try to troubleshoot when/if you do have contention.-Chad |
|
|
|
|
|
|
Temp Db configuration