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?

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.co...ers_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?

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?

Again Timeout errors

There is this sp which is used in the webpage, it takes 3 seconds to execute from the
query analyser, but when it is called from the asp page it ends up in
"Microsoft OLE DB Provider for SQL Server error '80040e31'
Timeout expired "
I know it is an General error and there can be many reasons to it,
but on setting a profiler I found out that the sp is called only when the page timeouts,
meaning for some time there is no activity say for 5 -8 seconds and after that the sp is called and
the page timeouts...
There is no rendering/formatting on the page. what can be the possible cause of it??Whada heck...
the sp just needed a recompile...
can anyone explain why?
no base tables were modified, tables are referenced acrossed two different
databases, WITH (NOLOCK) query hint is used in the sp.|||I've got the same prob. but the asp pages use dynamic SQL rather than SPs. When a user enters credentials into login page and press GO, it takes 3-5 minutes for welcome page to get displayed!!! :mad: When i run trance on the server there's no execution (only one query executes and the second comes after several seconds) being made nor there's any processor usage; what the page is spinning and doing. Is the problem with IIS. ?
Any body had the same experience? How to square this.

Howdy.