Solved

SATA disk drive / SQL performance

Posted on 2009-07-09
1
595 Views
Last Modified: 2012-05-07
I have a server with 1 SATA drive in it. I was told to get better performance, I should add a 2nd drive (non-RAID) to divide SQL files.(logs on one and db on the other)
The idea is that SQL can then do simultaneous reads and writes.
Is that true with SATA drives? I know it's recommended with SCSI drives but I'm not 100% sure that SATA will actually do true simultaneous access.
0
Comment
Question by:Mike McDonald
1 Comment
 
LVL 2

Accepted Solution

by:
metableta earned 250 total points
ID: 24812835
Attaching second HDD should give a boost to your DBMS. Simultanous read is controller type independent. In addition SATA is based on SCSI architecture. Good option would be to stripe between both disks (plus mirror) but this would require more HDDs and setting up RAID on them.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Vmware vcenter appliance 6.0.0 sits on login in screen 3 118
Windows storage spaces - raid10 14 445
10Gb/s vs 1Gb/s - Your experiences after an upgrade 11 115
OpenVMS Training 1 45
INTRODUCTION The purpose of this document is to demonstrate the Installation and configuration, of the HP EVA 4400 SAN Storage. The name , IP and the WWN ID’s used here are not the real ones. ABOUT THE STORAGE For most of you reading this, you …
Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question