|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Alert & Cache Hit RatioHello 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 Show quote "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. -- Show quoteAndrew J. Kelly SQL MVP "C TO" <C**@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?  |
|||||||||||||||||||||||
Other interesting topics