For details, see the Alarms chapter of the Foglight for SQL Server Reference Guide.
The Error Log Filtering view allows defining the following settings:
For all SQL Server versions, the Error Log Filtering view allows defining the following settings:
• |
Display under a pre-defined name in the SQL Agent Error Logs and SQL Server Error Logs panels — using the Match List pane. This pane contains a default list of expressions within the alert logs that are to be retrieved and displayed in the Alert Log panel under a pre-defined name, category, and severity. |
• |
Exclusion from the SQL Agent Error Logs and SQL Server Error Logs panels display — using the Ignore List pane, which contains a default list of alerts that are to be excluded when setting the alert logs display. |
IMPORTANT: Only messages that are explicitly defined in the Ignore List will not be displayed. Messages that were not added to either the Match or Ignore lists appear under name Other, type SQL Server errors messages and severity Informational. Therefore, ensure that messages that need not be displayed are added to the Ignore List. |
Both the Match List and the Ignore List panes can be customized by adding, editing, or removing alert logs. Each filter can be enabled or disabled separately by clicking Edit and selecting or clearing the Enabled check box. Alternatively, to enable or disable all of the filters, click the Enable All or Disable All button.
1 |
Click Add. |
2 |
Click Add to save your settings. |
The entire list of filters displayed on the view can be enabled or disabled by selecting the Enable All or Disable All buttons at the bottom of the screen. Enabling a single filter requires editing it.
2 |
Click Edit. |
4 |
Click Set. |
5 |
If another filter should be edited, repeat Step 1 to Step 4. If no more editing is necessary, or if all additional editing operations were carried out, save the changes before switching to another view. For details, see Reviewing the Administration Settings . |
2 |
Click Add Counters at the bottom of the screen. |
4 |
Click Add. |
5 |
After adding all of the requested counters, click Close to exit the Add Counters dialog box. |
6 |
Defines the maximum number of objects to be displayed in the Buffer Cache panel (default: 20). | |
Defines whether the order of the items for retrieval is ascending or descending. | |
Defines the parameter by which the display is to be ordered. |
After carrying out all of the requested changes, save the changes before switching to another view. For details, see Reviewing the Administration Settings .
The Plan Cache view allows configuring the default display settings for the SQL Server's plan cache panel, accessible using the Memory drilldown.
Defines whether to display only objects that reside on certain databases. When setting this parameter, the character % can be used as a wild card. For example, to display objects from all of the databases that begin with Quest (Questdatabase, QuestWorkDatabase, and so on), enter Quest%. | |||||||||||||||||||||||||||||
Defines the maximum number of objects to be displayed in the Plan Cache panel (default: 20). | |||||||||||||||||||||||||||||
Defines whether to retrieve only certain objects. When setting this parameter, the character % can be used as a wild card. | |||||||||||||||||||||||||||||
Defines the criterion for determining the data display order. The available criteria are as follows:
| |||||||||||||||||||||||||||||
Defines whether the display would be carried out in ascending or descending order. |
After carrying out all of the requested changes, save the changes before switching to another view. For details, see Reviewing the Administration Settings .
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center