Re: New Server Setup...Drive configurations

>From what I've read, I'd say:

1) a single R10 is a *bad* idea. You should not have the log files and the
databases on the same drive. It will have a significant performance impact.
2) The log files should be on an R1 and the data should be on R10 (R5 is OK,
but has a write speed penalty)
3) not sure what a LUN is...
4) The 2x36 array should be RAID-1

Also, it is recommended (once again, for performance) that each RAID array
be on it's own channel. This would require one or more RAID adapters. If
there are only two arrays, then you could get an adapter with two internal
channels.

I don't know where the tempdb file(s) should be..

Having said all this, you should really first analyze your database size,
complexity, number of users, transactions, etc. before you make a final
decision on the configuration. Without doing that, you are likely to over
build the machine and spend more than is necessary...... Multiple RAID
channels can be costly and a RAID-10 array will require at least 4 drives
while the same size for RAID-5 will require 3 drives...... However, be sure
to allow for future growth, since changing it later will be more costly and
take a lot of effort....

--
Regards,
Hank Arnold

"CD" <mcdye1@xxxxxxxxxxx> wrote in message
news:eZMwmxreFHA.2128@xxxxxxxxxxxxxxxxxxxxxxx
>I am setting up a new dedicated SQl server. The local 2x36 mirrored to
>house the OS and pagefile. I will be connecting to a SAN thru a 2gb card.
>
> a) They are wanting to give me a single R10, is this the best way to go?
> b) What would be the best setup to use for the SAN? (R1,R5,R10)
> c) How many LUNS?
> d) What to place where? (tempdb,logs,data)
>
> TIA
>


.

Relevant Pages

  • Re: [PHP] Getting mysql_query results into an array
    ... loop through mysql result set to build $array ... perform some kind of calculation upon $array ... Databases are highly optimized for this kind of thing, ... query is nasty and the PHP is fast and easy, ...
    (php.general)
  • Re: Help needed restoring tar of /
    ... I have databases so I: ... I bring up a minimal install with an array that matches the array ... However, for instance, sendmail which is `chkconfig sendmail off` on my ... on my backup and when I `service zimbra status`, ...
    (comp.os.linux.misc)
  • Re: 3310 RAID1 (mirror) Question
    ... connect another host to the array, or even the same host more than ... I select 5 drives ... I understand that the array will configure ... both channels as described in this short Sun Doc: ...
    (comp.unix.solaris)
  • Re: [PHP] combining 2 arrays
    ... PS: my previous ungly code is half long now:) ... I need to combine the data into one array first.. ... foreach ($keys as $key) ... The problem could be when databases have thousands of rows in each DB. ...
    (php.general)
  • Re: Move mailbox option from Exch5.5 to Exch2k3
    ... A cost issue will be the number of separate ... channels and the RAID adapter. ... either impossible or prohibitively expensive to get a RAID adapter with more ... add a kit to convert the external drive bays into another array. ...
    (microsoft.public.exchange.admin)
Loading