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 |
|
Larry Van Brocklin
Starting Member
8 Posts |
 Posted - 2010-01-06 : 14:22:47
|
| What is considered to be best practice when installing multiple instances on one physical server.On a single instance server I have the number of tempdb drives equal to the number of processors on the box. On a four proc box I have four tempdb drives.On a multi-instance server, with a four proc physical server, is the optimal configuration to still have four tempdb drives for each instance?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
behrman
Yak Posting Veteran
76 Posts |
Posted - 2010-01-09 : 11:32:40
|
| Hi.Please refer to the url below:http://msdn.microsoft.com/en-us/library/aa174516(SQL.80).aspxRegards,behrman.RAQ Report: Web-based Excel-like Java reporting tool |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-01-10 : 10:16:55
|
| Its not TempDB Drives you Create, You split TempDB Data Files according to number of processors.I would certainly put TEMPDB in Highly read/write drives like RAID 10. |
|
|
|
|
|
|
Multiple Instances - No. of tempdb vs. procs