| Groups | Blog | Home |
sql server clustering : Best Raid Config for sql
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. [quoted text, click to view] "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... > > 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 > > > >
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. [quoted text, click to view] "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... > > 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 > > > >
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 [quoted text, click to view] "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 >
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 [quoted text, click to view] "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... > >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... > >> > 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 > >> > > >> > >> > >> > >
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 [quoted text, click to view] "bribonfi" <bribonfi@discussions.microsoft.com> wrote in message news:9ABBC1D9-E43C-4E40-95BB-91A413C6853A@microsoft.com... >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... >> > 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 [quoted text, click to view] "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 >
[quoted text, click to view] "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. [quoted text, click to view] > > 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 [quoted text, click to view] "bribonfi" <bribonfi@discussions.microsoft.com> wrote in message news:66BAEF03-C4A0-4909-B932-455F3732B25D@microsoft.com... > 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... >> >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... >> >> > 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 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 [quoted text, click to view] "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... > > 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 > > > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |