September 12, 2006 at 8:44 am
Hi All,
I would like to know how the best Server specification for a box that would have SQL standard edition.
Both SQL 2000 and SQL 2005, I am trying to avoid buying enterprise licence but rather a standard edition with Xenon CPU’s on the boxes.
I know there are restrictions etc, but I want to get the best out of the box. I am also on a Windows 2000 standard edition platform.
Any advice would be appreciated.
Thanks in advance
September 12, 2006 at 9:03 am
I think the biggest thing you can do to get this runing well is to make sure you put the best disk config in possible. SQL standard will only support 2Gb on SQL 2000 (i think it's unlimited in 2005) and you're on windows 2000 so you're limited in RAM anyway
proboably best creating the following arrays (note not partitions of a large array)
c: (o/s mirrored)
d: (mdf files?? raid 1+0)
e: (ldf files?? raid 1+0) anything but raid 5!!!
f: (tempdb mirrored) (not raid 5) (also possibly backups??)
if you can afford it also use 2 controllers and mirror across the controllers not across channels on the same controller. not only will this not choke up the controller, but you'll also have redundancy if one of yor controllers fails.
try to also use many small disks - 32Gb disks are (usually) faster than 72Gb and if you can fit in twice as many disks you'll have twice as many spindles
MVDBA
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply