March 18, 2008 at 10:44 am
1.What do you guys think should be the way here. To dedicate one CPU to 4 drives or dedicate each drive a CPU?
2. Should it also contain data&log together or even break them down?
Please suggest.......
About to build a server here!:w00t:
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
March 18, 2008 at 1:05 pm
What is your hardware structure? What RAID do you use?
March 18, 2008 at 1:43 pm
Quad Core 4X2
16GB RAM
300 GB Hard Drive (8)
RAID 5
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
March 18, 2008 at 1:53 pm
If your whole server is configured as RAID 5, separating your data and log files will not enhance performance.
March 18, 2008 at 9:34 pm
Yap. That's what I thought. But what about dedication of the CPU's What do you think? These people here are planning on spending real big money for this one. I just had to let them know if it was okay to purchase more CPU's or not.
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
March 19, 2008 at 2:05 am
Hello,
Microsoft suggests to create datafiles equal to the number of CPU's.
For a quad core system, you have to create 4 datafiles for a critical database. This rule is also valid for tempdb.
As far as I'm concerned there is no rule about the number of CPU's per drive. But in a production environment you should have:
one disk for tempdb with RAID 10 or RAID5
one (or more) for database files with RAID 10 or RAID5
one for transaction log files with RAID 1
one for system databases with RAID 1
Regards,
PSA
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply