Unsolved
This post is more than 5 years old
20 Posts
0
5052
June 1st, 2009 14:00
CX300 and SATA drives
Hello! We have a CX300 with two additional enclosures, one add-on enclosure for FC drives and one for SATA drives. Currently we are considering VMWare to consolidate servers. Infact, we already have VM's in the CX300 (print server, blackberry server, and ftp server). We want to convert some more servers to VM, so we need more storage. Are SATA drives good enough for SQL databases? We currently have two SQL database servers that we are planning to convert to VM's.
Thanks in advance for your input on SATA drives with SQL database.
No Events found!
JOHNADCO
2 Intern
•
847 Posts
0
June 1st, 2009 14:00
Of course it depends on the database / activity / ect...ect...
We find them at the lower end of acceptable. We find the same san / number of spindles / ect..ect.. to be quite impressive on SAS drives. Of of our SQL servers runs a bare of a DB / application.
firefox111
20 Posts
0
June 1st, 2009 15:00
Thanks.
So what you are suggesting is to use faster Fiber Channel drives and one SAN system for SQL database alone? In other words a SAN dedicated only for SQL database, and another SAN for applications?
JOHNADCO
2 Intern
•
847 Posts
0
June 1st, 2009 16:00
I only have iSCSI so my options are SATA -VS- SAS....
Generally you can mix them on the same san just not always the same disk group.
Dev Mgr
4 Operator
•
9.3K Posts
0
June 2nd, 2009 07:00
If you're going to attempt to use SATA (7200rpm) drives, at least go raid 10 to help offset the low performance from them. I'd recommend at least 6 drives in a raid 10 and only that 1 LUN (and vmdk) on that raid group.