1748181 Members
3349 Online
108759 Solutions
New Discussion юеВ

Re: Cache setting

 
boda
Occasional Contributor

Cache setting

What is the best setting of the array controller cache ratio for SQL server 2005 Database.
2 REPLIES 2
Patrick Terlisten
Honored Contributor

Re: Cache setting

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
Best regards,
Patrick
boda
Occasional Contributor

Re: Cache setting

Thanks for your suggestion.I will try it