Cache setting

[boda]

What is the best setting of the array controller cache ratio for SQL server 2005 Database.

[Patrick Terlisten]

Hello,

it depends on the ratio of read and write IOs to you server. If you have more read, then write IOs, you should use more read then write cache. If you have more write then read IOs, you should do it the other way.

I don't know any best practise, but I would use 50/50 as read and write cache. Then you should monitor the server. Play around with the settings until the performance is sufficient for you. But this is only useful if you know how much read and write IOs are done. This could be check with "perfmon" and the MS SQL counters.

Best regards,
Patrick

[boda]

Thanks for your suggestion.I will try it