Re: Hardware configuration SATA vs. SCSI

I don't think raid 5 is generally recommended for SQL Server but better to
ask them here.

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.server&cat=en_US_671e06d0-f20d-4bb3-9c6a-42c825ddb1dc&lang=en&cr=US



--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"TurboTom" wrote:
| We are going to have Windows Server 2003 running desktop SQL with about 10
| users.
| Will there be a noticeable speed difference between 5 SATA 3Gb/s versus 4
| SCSI drives in a raid 5 configuration?
| I'm sure if I look at the numbers, SCSI will look much faster, but in
actual
| use, how would it appear?
|
| Thanks,
| Tom
|


.

Relevant Pages

  • SQL Server 2000 Hardware
    ... Hi can anyone tell me what hardware I would need to run ... SQL server 2000 on Windows Server 2003. ... It has to be totally realiable and so would need a raid ...
    (microsoft.public.sqlserver.setup)
  • RE: IIS & SQL
    ... it is best to place SQL Server on a separated ... database on a RAID 5 disk. ... RAID 5 provides redundancy of all data on the ... 298475 HOW TO: Troubleshoot Application Performance Issues ...
    (microsoft.public.sqlserver.setup)
  • Re: -- SQL 2005 memory (x64) --
    ... Test RAID5 and RAID10 for your environment if you have time. ... However, if write rate is high in your environment, than a RAID10 would be more appropriate for your data files. ... After deciding which RAID configurationis the best for your particular environment, then locate your database log files and data files on different physical disks according to those RAID choices. ... MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT ...
    (microsoft.public.sqlserver.setup)
  • Application State usage/tuning and "Object reference not set" erro
    ... Windows Server 2003 SP2 ... application retrieves a large dataset from SQL Server and creates a large ... been watching CPU utilization with Performance Monitor, and Memory ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Can performance improve using RAID 0 if have only one CPU?
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > "Frank" wrote in message ... >> I just read about the RAID, so I am wondering about this. ... >> performance improvement for the processor to go to different strips. ...
    (microsoft.public.sqlserver.server)
Loading