Re: Request for Comment - SQL\WSS on the same server setup

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Ariel:

I wouldn't recommend partitioning your first array (RAID 1 setup) at
all. One large 36GB partition would work fine. For serious
performance, I'd also recommend doubling the amount of RAM on the
machine and turning off your pagefile.

As for the second array (RAID 10), you should store both the SQL
databases and transacted logfiles there. If you store the transactions
on the RAID 1 array, you won't have performance gains over what the
second array would have provided, but you'll lose the redundancy
aspect.

Sounds like you've got a great setup there, though. You'll have to
post some benchmarks, or at least come back and boast about it. :-)

Best of Luck,
Charlie Holmes
RGA

.

Relevant Pages

  • Win XP remaster Hell, hole network rail IT helpdesk stumped!!
    ... I have a dual athon mp1900+processor setup with dual WD ... THe raid array has ben setup as striped, ... install and then blue screened as it couldn't load the OS. ...
    (microsoft.public.windowsxp.setup_deployment)
  • Re: installing XP Pro SP2 on SATA RAID
    ... Just a curious question from someone who is completely untutored in Raid ... Raid1 setup for "data". ... I am trying to install XP Pro SP 2 on a new machine with a SATA ... recognizes the array and even partitions/formats it. ...
    (microsoft.public.windowsxp.setup_deployment)
  • Re: Compaq Server Hard Drive Upgrade
    ... *should* work just fine over a single channel. ... setup is that you have the option of creating the desired RAID 5 array ... ability to create a second array on the same channel. ... I'm wanting my setup at the end to look like this: ...
    (microsoft.public.windows.server.sbs)
  • Raid Help Please
    ... that I cannot change the RAID Array to RAID 0. ... It keeps showing as RAID 10 ... setup RAID 0 but after I save the changes and reboot the Array is back to ...
    (alt.comp.hardware.pc-homebuilt)
  • Software RAID-1 with Mandrake9.0 problems - LONG
    ... I have configured RAID -1 ... md: md0: raid array is not clean -- starting background reconstruction ... ...trying to set up timer as Virtual Wire IRQ... ... host bus clock speed is 132.8612 MHz. ...
    (comp.os.linux.setup)