Re: RAID Configuration
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 12/07/04
- Next message: Jacco Schalkwijk: "Re: sql server 2000 install"
- Previous message: Barry G. Sumpter: "Re: (Microsoft SQL Server Desktop Engine)"
- In reply to: epigram: "Re: RAID Configuration"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 7 Dec 2004 17:37:27 -0500
For Inserts, Updates and Deletes yes. If it's mostly Read Only then it
doesn't make as much difference but is a good practice.
-- Andrew J. Kelly SQL MVP "epigram" <nospam@spammy.com> wrote in message news:1102425520.dc4a3bb4f0cdab0cfd75b7b246b6fb2e@bubbanews... > Thanks for the clarification. So, it is more beneficial (in terms of > performance) for the transaction log files to be on the RAID 1 set (which > has faster write speeds than RAID 5) and the data files to be on the RAID > 5 set as opposed to the other way around? > > Thanks. > > > "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message > news:%23zyzK1F3EHA.2600@TK2MSFTNGP09.phx.gbl... >> Just a clarification. What you want on the Raid 1 are the SQL Server >> Transaction Log files. Do not mix any other type of file with these >> other than Tran logs. The idea isn't as much because they are heavily >> written to and the data files aren't but more the fact that the logs are >> written to sequentially and the data is random. These two operations >> conflict with each other and since each log entry must be written before >> the next one can occur you want the tran logs to operate as smoothly as >> possible. And yes you can move the log files later on. >> http://www.support.microsoft.com/?id=224071 Moving SQL Server >> Databases to a New Location with Detach/Attach >> http://support.microsoft.com/?id=221465 Using WITH MOVE in a >> Restore >> >> -- >> Andrew J. Kelly SQL MVP >> >> >> "epigram" <nospam@spammy.com> wrote in message >> news:1102420755.7ec11aeae846a8a66a3c23549db3b9e4@bubbanews... >>>I currently have a server with a RAID 5 drive set. I can't change that, >>>but I can add two additional drives. So, I was planning on adding two >>>drives in a RAID 1/mirrored set configuration based upon some posts in >>>this newsgroup and some articles I have read. I want to make sure I am >>>clear if this is the best approach, given my current setup, and that I am >>>correct in what I plan to do with the two RAID sets. >>> >>> My plan is to put the transaction and log files on the RAID 1 set and >>> everything else on the RAID 5 set (i.e. SQL Server installation, table >>> files). From what I understand the trans and log files are heavily >>> written to, and putting them on the RAID 1 set would give me a boost for >>> writes. >>> >>> Is this the correct approach? If my budget doesn't allow me to install >>> the RAID 1 set immediately, can I install SQL Server now and reconfigure >>> it to place the trans and log files to the RAID 1 set later? >>> >>> Thanks. >>> >> >> > >
- Next message: Jacco Schalkwijk: "Re: sql server 2000 install"
- Previous message: Barry G. Sumpter: "Re: (Microsoft SQL Server Desktop Engine)"
- In reply to: epigram: "Re: RAID Configuration"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
