EMC CX 300 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

EMC CX 300

We’re reconfiguring our EMC CX 300 array for SQL Server. The array has 30 drives with RAID 1, 0, and 10 configurations. The apps hitting the db server perform approx. 90% reads and 10% writes. Can anyone recommend what cache settings to use on SPA and SPB? I’ve seen comments stating disabling write cache hepls prevent torn pages and improves overall performance. Any help is appreciated.
I’ve moved to relevant forum.
Luis Martin
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
May refer tohttp://www.microsoft.com/technet/itsolutions/wssra/raguide/StorageDevices/strgDvcBG_9.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx links Fyi. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.