I have a Dell PE6650 with only 5 drives(15k). what is the best raid
configuation i can acheive for higest performace with this amount of drives.
I was thinking or either of the following
Option 1 --
RAID 1 - 2 drives - os and backups
RAID 1 - 2 drives - data and log
Option 2 --
RAID 10 - 4 drives - everything
Option 3 --
RAID 5 - 3 drives - os backups
RAID 1 - 2 drives - data and log
which of this would be best, or if you have any other suggestions please
submit them.
Thanks,
Brian
So, you are not running a cluster, this is SQL on a dedicated stand alone
machine? This makes a big difference is what to do.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"bribonfi" <bribonfi@.discussions.microsoft.com> wrote in message
news:47C647B2-E889-4A1F-A438-296D7D6A1BD1@.microsoft.com...
> Hello,
> I have a Dell PE6650 with only 5 drives(15k). what is the best raid
> configuation i can acheive for higest performace with this amount of
> drives.
> I was thinking or either of the following
> Option 1 --
> RAID 1 - 2 drives - os and backups
> RAID 1 - 2 drives - data and log
> Option 2 --
> RAID 10 - 4 drives - everything
> Option 3 --
> RAID 5 - 3 drives - os backups
> RAID 1 - 2 drives - data and log
> which of this would be best, or if you have any other suggestions please
> submit them.
> Thanks,
> Brian
>
|||Use 4 of the internal drives for OS,Binary, and TLOG files configured as
RAID-10
Buy a PowerVault 220S and set it up RAID-10 for SQL Data
Backup across the network to another host computer.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"bribonfi" <bribonfi@.discussions.microsoft.com> wrote in message
news:47C647B2-E889-4A1F-A438-296D7D6A1BD1@.microsoft.com...
> Hello,
> I have a Dell PE6650 with only 5 drives(15k). what is the best raid
> configuation i can acheive for higest performace with this amount of
drives.
> I was thinking or either of the following
> Option 1 --
> RAID 1 - 2 drives - os and backups
> RAID 1 - 2 drives - data and log
> Option 2 --
> RAID 10 - 4 drives - everything
> Option 3 --
> RAID 5 - 3 drives - os backups
> RAID 1 - 2 drives - data and log
> which of this would be best, or if you have any other suggestions please
> submit them.
> Thanks,
> Brian
>
|||i haven't decided on whether or not to use a cluster, please expain the best
option for both senarios.
"Rodney R. Fournier [MVP]" wrote:
> So, you are not running a cluster, this is SQL on a dedicated stand alone
> machine? This makes a big difference is what to do.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://msmvps.com/clustering - Blog
> "bribonfi" <bribonfi@.discussions.microsoft.com> wrote in message
> news:47C647B2-E889-4A1F-A438-296D7D6A1BD1@.microsoft.com...
>
>
|||Thank you for your response. However, purchasing more hardware is just not an
option at this point. What i am looking for is how to accomplish the best
case senarior with what I have.
"Geoff N. Hiten" wrote:
> Use 4 of the internal drives for OS,Binary, and TLOG files configured as
> RAID-10
> Buy a PowerVault 220S and set it up RAID-10 for SQL Data
> Backup across the network to another host computer.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "bribonfi" <bribonfi@.discussions.microsoft.com> wrote in message
> news:47C647B2-E889-4A1F-A438-296D7D6A1BD1@.microsoft.com...
> drives.
>
>
|||If you don't have any money, then you can't buy another server, so you can't
cluster.
Of the options below for a single server, I like Option 4 - OS/Backup RAID
1, RAID 5 for the rest data and logs.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"bribonfi" <bribonfi@.discussions.microsoft.com> wrote in message
news:9ABBC1D9-E43C-4E40-95BB-91A413C6853A@.microsoft.com...[vbcol=seagreen]
>i haven't decided on whether or not to use a cluster, please expain the
>best
> option for both senarios.
> "Rodney R. Fournier [MVP]" wrote:
|||Actually I have two of the same machines so i could cluster. Also, please
explain why you like option 3. I was actaully leaning towards option 2
becuase later down the line i want to buy a 220s powervault and move the data
to that.
Also, instead of clustering i was looking a replicated between my 2 PE6650's
and using a NLB cluster insead of a SQL cluster. what are your thoughts on
that as well.
Thanks for all your help.
-Brian
"Rodney R. Fournier [MVP]" wrote:
> If you don't have any money, then you can't buy another server, so you can't
> cluster.
> Of the options below for a single server, I like Option 4 - OS/Backup RAID
> 1, RAID 5 for the rest data and logs.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://msmvps.com/clustering - Blog
> "bribonfi" <bribonfi@.discussions.microsoft.com> wrote in message
> news:9ABBC1D9-E43C-4E40-95BB-91A413C6853A@.microsoft.com...
>
>
|||"bribonfi" <bribonfi@.discussions.microsoft.com> wrote in message
news:47C647B2-E889-4A1F-A438-296D7D6A1BD1@.microsoft.com...
> Hello,
> I have a Dell PE6650 with only 5 drives(15k). what is the best raid
> configuation i can acheive for higest performace with this amount of
drives.
> I was thinking or either of the following
> Option 1 --
> RAID 1 - 2 drives - os and backups
> RAID 1 - 2 drives - data and log
> Option 2 --
> RAID 10 - 4 drives - everything
> Option 3 --
> RAID 5 - 3 drives - os backups
> RAID 1 - 2 drives - data and log
I'd go with Option 5:
RAID 1 - 2 drives OS/log (but split into two logical drives, C: OS , D:
Logs)
RAID 1 - 2 drives data
5th drive hotspare
Reasoning:
Logs should be backed up regularly, so you may get away with less disk
space, hence share space with OS. Since SQL Server tries to avoid swapping,
etc, once OS boots, this should be OK.
Data gets the most drive space.
You have a hotspare for failover.
If you really need disk space, go with RAID5 and put data there. Avoid logs
on RAID5 as much as possible.
> which of this would be best, or if you have any other suggestions please
> submit them.
> Thanks,
> Brian
>
|||Ok, if whatever you will do, you will buy something else later, then it
really does not matter now
I like Option 4 - modified because it comes closer to best practices. You
need more drives for RAID 10, which you did not have, yet.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"bribonfi" <bribonfi@.discussions.microsoft.com> wrote in message
news:66BAEF03-C4A0-4909-B932-455F3732B25D@.microsoft.com...[vbcol=seagreen]
> Actually I have two of the same machines so i could cluster. Also, please
> explain why you like option 3. I was actaully leaning towards option 2
> becuase later down the line i want to buy a 220s powervault and move the
> data
> to that.
> Also, instead of clustering i was looking a replicated between my 2
> PE6650's
> and using a NLB cluster insead of a SQL cluster. what are your thoughts on
> that as well.
> Thanks for all your help.
> -Brian
> "Rodney R. Fournier [MVP]" wrote:
|||I use the OS + Logs on a single RAID container sometimes on my smaller
systems. You are absolutely correct that once the system is up and running,
there should be no paging and very little code loading. This leaves most of
the bandwidth available for SQL log writes.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:BWKDd.130023$Uf.36761@.twister.nyroc.rr.com...
> "bribonfi" <bribonfi@.discussions.microsoft.com> wrote in message
> news:47C647B2-E889-4A1F-A438-296D7D6A1BD1@.microsoft.com...
> drives.
> I'd go with Option 5:
> RAID 1 - 2 drives OS/log (but split into two logical drives, C: OS , D:
> Logs)
> RAID 1 - 2 drives data
> 5th drive hotspare
> Reasoning:
> Logs should be backed up regularly, so you may get away with less disk
> space, hence share space with OS. Since SQL Server tries to avoid
swapping,
> etc, once OS boots, this should be OK.
> Data gets the most drive space.
> You have a hotspare for failover.
> If you really need disk space, go with RAID5 and put data there. Avoid
logs
> on RAID5 as much as possible.
>
>
>
No comments:
Post a Comment