SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Temp Db configuration
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

egemen_ates
Yak Posting Veteran

Turkey
76 Posts

Posted - 11/07/2012 :  09:14:48  Show Profile  Reply with Quote
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.ndf

so is this scenario provide advantage by performance ?

chadmat
The Chadinator

USA
1974 Posts

Posted - 11/07/2012 :  13:15:51  Show Profile  Visit chadmat's Homepage  Reply with Quote
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
Go to Top of Page

jeffw8713
Aged Yak Warrior

USA
806 Posts

Posted - 11/08/2012 :  16:33:08  Show Profile  Reply with Quote
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.
Go to Top of Page

chadmat
The Chadinator

USA
1974 Posts

Posted - 11/09/2012 :  02:41:01  Show Profile  Visit chadmat's Homepage  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000