Return
-
Title
Exclude a SQL Server database from being monitored -
Description
Monitoring all of the databases within all of the agents can unnecessarily load the system, as not all databases require such monitoring, due to being either non-mission critical or less significant. The Exclude Databases from Monitoring view allows excluding such databases from monitoring. Use this view to select the agents from which databases are to be excluded from monitoring, and then specify, either manually or by selecting from a list, which databases to exclude.The On-demand Data Settings view in the Databases Administration dashboard allows defining a port for each Foglight Agent Manager (FglAM) to be used for retrieving data and integrating with Foglight SQL PI. -
Resolution
RESOLUTION 1 * This is the preferred method*To exclude databases from monitoring:-
Navigate to the Global View Databases Dashboard
-
Select one or more SQL Server database agents
-
Click Settings | Administration
-
Click the Databases Exclusion item
-
Click the Exclude databases button* NOTE: Selecting a specific agent from which databases are to be excluded is done using the dialog box that opens upon clicking this button.
The dialog box Specify Databases for Exclusion appears. - Use the list Select specific agent or all agents to select an agent from which databases are to be excluded. Alternatively, select the option All selected agents.
- Specify which databases to exclude from monitoring, either by adding their names manually or by selecting them from the list and clicking > to move them to the list of excluded agents.
- Click OK.
- Click the Save changes button
RESOLUTION 2
- Navigate to: Adminstration | Agents | Agent Status
- Find the agent, click and highlight the row
- Click the Edit Properties button
- Click the Modify the Private properties for this agent link.
- Scroll down to Excluded databases and click Edit in the Excluded Databases List
- Add 1 or more databases to the list via add row and click the Save button which closes dialog box
- Scroll to the bottom and click save and return back to agent status
- Deactivate and activate the Agent to update the agent properties.
-