This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Alert on CPU and Memory Utilization with time component

Hello,

I am trying to identify CPU and Memory utilization(s) for a MS SQL server when the CPU and Memory is pegged at 95% for at least 3 hours.

Using DPA, the parameters do not give me an option to add a time component to it. Can anyone who has done something similar or has any ideas help me out?

pastedImage_0.png

  • If you set the interval for the alert to check every 3 hours, I believe it averages the individual collections for that metric and should achieve what you want.

    You should test this out though to make sure it's the desired behavior.