Re: advice on memory configuration

From: vsevolod afanassiev <vsevolod.afanassiev_at_gmail.com>
Date: Thu, 10 Nov 2011 02:28:55 -0800 (PST)
Message-ID: <ff643957-a021-47ec-9bb3-557231668897_at_h23g2000pra.googlegroups.com>

In Prod Buffer Cache Advisor doesn't work, it reports rubish. It Performance Test it worked and I included results in my post:

>>Buffer Cache Advisory predicts improvement
>>in performance for bigger cache: if cache is increased from 85 GB to
>>170 GB number of physical reads should fall from 188 million to 85
>> million.

What I am looking for is advice on how to aproach this issue, what should we look at.

Thanks Received on Thu Nov 10 2011 - 04:28:55 CST