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
Moderator
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
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks!

]]>