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, i
s
it the time to consider adding RAM? If not, when would be?See if this helps:
Tips for Using Performance Monitor
Memory Counters
[url]http://www.sql-server-performance.com/performance_monitor_counters_memory.asp[/url
]
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 th
e
> 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?