Alert & Cache Hit Ratio

Hello World,
How can I set up an alert when the Cache Hit Ratio has averaged lower than
60% for the past n number of hours (with 5 seconds interval) ?
We are using Cache Hit Ratio to determine if we need to add more RAM to the
server. However, if the number above only hit the alert once in two weeks, is
it the time to consider adding RAM? If not, when would be?See if this helps:
Tips for Using Performance Monitor
Memory Counters
http://www.sql-server-performance.com/performance_monitor_counters_memory.asp
AMB
"C TO" wrote:
> Hello World,
> How can I set up an alert when the Cache Hit Ratio has averaged lower than
> 60% for the past n number of hours (with 5 seconds interval) ?
> We are using Cache Hit Ratio to determine if we need to add more RAM to the
> server. However, if the number above only hit the alert once in two weeks, is
> it the time to consider adding RAM? If not, when would be?|||If your Cache Hit Ration is anywhere near 60% you either need to optimize
your queries / indexes or could use more memory. I worry if I see it get
just a few % below 100%. You should also monitor the page life expectancy
counter to see if you need more memory.
--
Andrew J. Kelly SQL MVP
"C TO" <CTO@.discussions.microsoft.com> wrote in message
news:565918DF-F2A5-4A95-A707-80AFF284AEE6@.microsoft.com...
> Hello World,
> How can I set up an alert when the Cache Hit Ratio has averaged lower than
> 60% for the past n number of hours (with 5 seconds interval) ?
> We are using Cache Hit Ratio to determine if we need to add more RAM to
> the
> server. However, if the number above only hit the alert once in two weeks,
> is
> it the time to consider adding RAM? If not, when would be?