cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

MSSQL: Alert Page life expectancy

STiAT
Advisor

Hello,

background-information:

https://www.spotlightcloud.io/blog/monitoring-page-life-expectancy-in-sql-server

We'd like to monitor the page life expectancy of mssql servers, or so-to-say the process groups.


The issue there is that we need to alert it according to a formular:
Alert if Page life expectancy (in minutes) < (SQL Server "Total" Memory in GB / 4 * 300)

Now, I can do metrics and set static values on that. I do not know how Dynatrace calculates the automatic treshhold there, but in my experience this did not alert at any time for servers which certainly have this issue.

Is there a way to set a formula to calculate dynamic treshholds, or to generate a metric / treshhold reflecting this?


4 REPLIES 4

ChadTurner
DynaMight Legend
DynaMight Legend

how did you set your static thresholds/alerts? did you create a custom event for alerting?

-Chad

STiAT
Advisor

Yes, I tried to create a custom event for the static threshold. The issue there is that this does not seem to accept a formula, so I'd have to configure it for every sql database (which are quite a lot here), and keep track of changes adopting it. That's what I don't want to have, I want the threshold to adopt according to the total memory.

ChadTurner
DynaMight Legend
DynaMight Legend

Ahh I see. Well then i would recommend tossing in a RFE to alert the product developers of this limitation and hopefully be worked into the upcoming updates.

https://community.dynatrace.com/t5/forums/postpage/board-id/DynatraceProductIdeas 

-Chad

Featured Posts