Skip to main content
Start a Conversation

Unsolved

This post is more than 5 years old

ScottE121

1 Message

5192

November 2nd, 2007 18:00

Drives for SQL Server

Anybody have any insight as to what is better for query speed?  Faster access time or transfer rate.  The reason I ask is I am trying to decide what size drives to get the 2.5 or the 3.5.  Any insight into this would be good as well.  I understand the 3.5 has better transfer rate but the 2.5 has better access time.  Please let me know if I am correct in this understanding.

pcmeiners

6 Operator

 • 

1.8K Posts

November 2nd, 2007 20:00

This brought up something I had not looked into...
I compared the Seagate offerings 2.5 vs the 3.5, SAS, very small difference between the drives; we are not talking about even a millisec here, Seagate claims the 2.5 is 10% faster, bet it is <5% on a setup drive,  Far as could see, the max throughput was very close between the drive. 
 
I would be far more worried about other factors in the server. 
 
CPU speed
 
Server ram amount/ram speed would be more critical
 
Raid type,  more critical
 
Number of drives in the raid type, with SAS, speed increases which each added drive , increasing in speed past 10 drives.
 
raid stripe size (chuck size) more critical.
 
Raid cache size, might make a difference 
 
How much data will be on the drives, where the databases will reside on the drive, would be more critical.
 
If you do not do a boot time defrag, every couple of months, would be more critical.to SQL
 
 
Neat site for server benchmarks, Dutch, but benchmarks are in English
 
 
 


Message Edited by pcmeiners on 11-02-2007 04:34 PM

Was this post helpful?

View All

No Events found!

Top