https://community.hpe.com/t5/proliant-servers-ml-dl-sl/cache-setting/m-p/4453259#M92108 What is the best setting of the array controller cache ratio for SQL server 2005 Database. Mon, 06 Jul 2009 04:12:35 GMT boda 2009-07-06T04:12:35Z https://community.hpe.com/t5/proliant-servers-ml-dl-sl/cache-setting/m-p/4453259#M92108 What is the best setting of the array controller cache ratio for SQL server 2005 Database. Mon, 06 Jul 2009 04:12:35 GMT https://community.hpe.com/t5/proliant-servers-ml-dl-sl/cache-setting/m-p/4453259#M92108 boda 2009-07-06T04:12:35Z https://community.hpe.com/t5/proliant-servers-ml-dl-sl/cache-setting/m-p/4453260#M92109 Hello,<BR /><BR />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.<BR /><BR />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.<BR /><BR />Best regards,<BR />Patrick Mon, 06 Jul 2009 06:58:21 GMT https://community.hpe.com/t5/proliant-servers-ml-dl-sl/cache-setting/m-p/4453260#M92109 Patrick Terlisten 2009-07-06T06:58:21Z https://community.hpe.com/t5/proliant-servers-ml-dl-sl/cache-setting/m-p/4453261#M92110 Thanks for your suggestion.I will try it Mon, 06 Jul 2009 08:24:51 GMT https://community.hpe.com/t5/proliant-servers-ml-dl-sl/cache-setting/m-p/4453261#M92110 boda 2009-07-06T08:24:51Z