SQL Server Performance Forum – Threads Archive
EMC CX 300We’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.
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
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.