How are the following SQL Server agent alarms configured and what are they used for?
DBSS - Physical Memory Available (alarm group: Memory)
DBSS - Buffer Pages Free (alarm group: Memory)
You can configure the DBSS - Physical Memory Available (alarm group: Memory) and DBSS - Buffer Pages Free (alarm group: Memory) in the following location:
The Buffer Pages Free alarm is invoked when the number of free buffer pages (namely, pages that are available for immediate reuse) exceeds a predefined registry variable value.
The Physical Memory Available alarm is invoked when the free physical memory falls below a predefined percent.
About the Threshold Settings:
The Threshold section of the Alarms administration screen > Alarm Settings pane allows configuring thresholds for some of the Alarms displayed in the Alarms list.
Note None of the alarms that belong to the Baseline Deviation group can have thresholds configured.
When these thresholds are exceeded, Foglight for SQL Server triggers color-coded alerts, thereby notifying issues of varying severity degree in the monitored environment.
To edit the requested alarm’s severity level bounds:
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center