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