How to delete the baseline data for a specific database agent topology
説明
Too many alarms are firing for the "DBSS - Executions Baseline Deviation" on a specific SQL Server agent.
How can a user delete the baseline data for the associated topology for this specific database agent?
対策
In this example the topology for the "DBSS - Executions Baseline Deviation" alarm
Identify the topology used by the rule in Administration | Rules & Notifications | Rules. In this example the topology listed in the Rule Scope is DBSS_Top_SQLs_Summary.
Navigate to Administration | Tooling | Script Console, in the top pulldown menu choose the Topology, which would be SQL Server Top SQLs Summary. This should fill in the field below with the same value as was determined in Step 2
Click the List Instances button
Click the radio button that is associated to the database agent.
The bottom panel will open and the with the Object ID field populated. Copy this value.
Log in to the FMS console using the 'foglight' account
Access the JMX-Console using a URL similar to this: http://servername:8443/jmx-console
Click the service=baselineProfileManager link
Scroll down to diagnosticRemoveAllObservationProfiles(), and paste the Object ID into the value field
Click the Invoke button
A new page will appear with the message "Deleted X rows. Committed"