topic MSSQL: Alert Page life expectancy in Alerting

MSSQL: Alert Page life expectancy

STiAT — Thu, 22 Oct 2020 13:09:15 GMT

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?

Re: MSSQL: Alert Page life expectancy

ChadTurner — Thu, 22 Oct 2020 14:38:23 GMT

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

Re: MSSQL: Alert Page life expectancy

STiAT — Thu, 22 Oct 2020 14:50:46 GMT

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.

Re: MSSQL: Alert Page life expectancy

ChadTurner — Mon, 12 Feb 2024 10:44:50 GMT

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

Re: MSSQL: Alert Page life expectancy

STiAT — Mon, 16 Oct 2023 14:16:46 GMT

In case somebody searches for this, I created an RFE:

https://community.dynatrace.com/spaces/483/dynatrace-product-ideas/idea/245941/formulas-on-metrics.html