May 19, 2003 at 2:48 pm
Greetings all.
I have a machine which I am being forced to reuse. It's a Dual P3 600(?) ZEON.
2 GB memory, RAID 5 (5 Disks) 36GB each.
I have been give the go-ahead to buy another machine but budget restraints limit me to a P4 (not ZEON) 2GB memory, 5 * 18GB SCSI. I could get more memory at a push.
The setup will be: one machine running IIS and the other running SQL 2000 Ent.
Question:
Should I run SQL or IIS on the faster machine?
Should I keep SQL on the single with more memory?
Config of disks? Straight RAID 5? or one for OS + SQL, 2 (Raid 0) for Data, 2 (Raid 0) for Logs?
I want to sqweese as much as possible out of a slowish machine.
Thanks!
Cheers,
Crispin
Why don't you try practicing random acts of intelligence and senseless acts of self-control?
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
May 19, 2003 at 3:22 pm
IIS on the slower machine since in truth IIS will have the smallest workload unless you have some major server side script in mind.
Also, I doubt you will require all the space for the web so you might remove all but 2 disks from the RAID 5 and make a RAID 1 (mirror may be 0 I forget) and put in the new SQL machine and consider putting the Logs and tempDB on a seperate RAID 5 array on another controller or channel to get maximum performance. May even try to get another matched 36 GB drive and make a RAID 10 to get best read/write performance. But not being a big hardware guy these are thoughts which may not translate to what you will be getting in a workable fashion.
But IIS on slower box is a yes.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply