Is there a way to define the warning and critical thresholds in term of interval for app insight for SQL.
One of the counter, the "target - total server memory" should be at 0. Getting a value over or lower than zero means either having SQL server indicate the possibility of SQL being memory presssure or the OS being under memory pressure.
Is there a way to define two threshold, one for positive values and one for negative values? For instance,
over 100 MB = warning
lower then minus 100MB = warning
over 1GB = critical
lower then minus 1GB = critical.
Unfortunalty, the interface only allows for one treshold for the warning. Further more, the critical treshold can only have the value edited and does not allow to change the type of condition. (for instance warning = over 100MB, critical = lower then minus 100MB)
Would be curious to know if there is a way to properly handle this to avoid useless noise?
