Re: SQL Configuration

What's the rate of writing and reading against your databases? Actually, this was the first question that should have been asked and answered. Because this is what is gonna shape your disk configuration.

If it's read intensive, then RAID5 is OK (perf + redundancy). If it's write intensive then think about RAID10 (perf + redundancy) for your data and log files.

If you have a chance to buy another physical disk, then you could locate your t-log files on a mirrored disk configuration (RAID1) which is gonna give you max write perf with redundancy. And store your data files on a 3disk RAID5 configuration. Of course this is an option if your system is write intensive.

--
Ekrem Önsoy


"Neil" <nospam@xxxxxxxxxx> wrote in message news:biwMi.30623$eY.13539@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
The two drives we have are:

C: RAID 0+1 36 GB (2 - 36 GB 10,000 RPM SAS)
D: RAID 5 204 GB (4 - 72 GB 10,000 RPM SAS)


"Ekrem Önsoy" <ekrem@xxxxxxxxxxxx> wrote in message news:3AC16AFB-D66F-4C52-9F06-7C87FBEA6D42@xxxxxxxxxxxxxxxx
My suggestion:
1- Install OS in drive X (you could make this drive set RAID1 for redundancy)
2- Locate SQL Server data files in drive XX (Make this RAID10 if you are looking perf + redundancy)
3- Locate Log files of data files in drive XXX (if possible make this RAID1 if you are looking for perf + redundancy, if perf is the only important thing then go for RAID0)

This way gives you the best perf. If temp db is being used in your environment, then you may be thinking to locate it on its dedicated drive as well.

P.S.
You may not care about the suggestions in parenthesis.

If you do not have enough disks, then you could locate your OS files on drive X, data and log files on drive XX.

--
Ekrem Önsoy



"Neil" <nospam@xxxxxxxxxx> wrote in message news:oQhMi.654$VX3.602@xxxxxxxxxxxxxxxxxxxxxxx
We are running SQL 7 on a server, and are moving to a new server and will be upgrading to SQL 2005 at the same time. Currently, both the old and the new servers have two drives, one for programs and one for data.

With the current configuration, SQL 7 and the data are both installed on the data drive, in the MSSQL7 directory. Our sys admin wants to install SQL 2005 on the program drive of the new server, while putting our databases on the data drive. I argue that if SQL itself is on the program drive, then the system databases will be in one place, while our databases will be in another. So I'd prefer to have SQL 2005 installed on the data drive, as it is now.

I'm interested in any feedback regarding what you guys think is the better configuration, and also if there's any performance hit from having the program and the database on two drives of the same machine.

Thanks,

Neil





.

Relevant Pages

  • Re: SQL 2000 + W2K Upgrade
    ... I would upgrade the OS first. ... Backup everything, shut down SQL, copy the drive contents off, repartition, ... backup the SQL 2000 databases, detach the databases, shut down both ... sizes of data drives; backup drives; quorum drives, ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL on its own partition
    ... For SQL and ISA, you can choose to store the database files and cache ... <When you install SQL server (This does not automaticly means all other ... <databases in SQL that comes by default and that has to be there. ... drives are raid 5 as you descrided. ...
    (microsoft.public.windows.server.sbs)
  • Re: expanding ram
    ... I am working with some very large databases(in the 500 ... databases put on USB flash drives attached through a USB hub * 2 ... USB flashsticks are substantially slower than hard drives connected over ...
    (comp.sys.ibm.pc.hardware.chips)
  • Re: Move databases to a larger drive
    ... > I have a SQL 6.5 server running on WinNTthat was recently upgraded. ... > the new larger drives, and the SQLServer service was restarted. ... > upgrade) SQL Exec doesn't appear to see the larger drive capacity. ... > databases have the drive letters of the original drives, ...
    (microsoft.public.sqlserver.server)
  • Re: Log file partition
    ... I support the Professional Association for SQL Server ... Most are system databases which are in simple mode anyway. ... Three drives are for fault tolerance and performance. ...
    (microsoft.public.sqlserver.server)