Reviewing and resolving alerts in ApexSQL Monitor

Transcript

Hello, and welcome to this video presentation in which we’ll introduce the ways of reviewing and resolving alerts and generate reports using the Reports feature.

Alerts provide notifications about ongoing and potential performance problems that occur on your machines, SQL Server instances, databases, services, and more. Alerts can be configured for each monitored device.

Alerts are grouped in three categories based on severity

Alerts with high severity are red, medium alerts are orange and alerts with low severity are blue

To view the number of collected alerts and their severity for the specific SQL Server instance, on the left pane, find and select a SQL Server instance to review. On the dashboard, the number of alerts will be shown with severities grouped in the monitored areas including System, SQL Server, Database, Query, Waits status and Indexes:

Over time, many alerts will be collected. To make use of alerts, they need to be made actionable by being resolved, and then to be cleared from the alert list.

ApexSQL Monitor provides the possibility to help you in reviewing, resolving and closing the alerts.

In the Dashboard, click on the desired alert counter to see all collected alerts for a specific monitored area by severity. For example, high alerts for the System monitored area:

To review all alerts for specific instance, in the three view, select a desired instance and click the Alerts tab:

By default, alerts that raised in the last 24 hours will be shown in the grid:

In the time interval drop down box, beside the option that shows raised alerts in the last 24 hours, there is an option which shows alerts in the last 7 days and the All option that shows alerts from the initial start of monitoring:

To review alerts that are raised in the specific time range in the From and the To controls, set the values of interest:

To review a specific metric e.g. System matric, in the metrics box, find and select the System option:

On the left side of the metrics box, the number of raised alerts with severities is shown

To include only the severity of your interest in the alerts grid e.g. High, click on the Medium and Low alerts. This will exclude the Medium and Low alerts from the grid list leaving only alerts with high severity:

There are two ways to resolve alerts, individually or in batches.

To resolve alerts one by one, from the alerts grid under the Metric column, click on desired alert. This will open the details page for chosen alert:

Under the details page, one of the offered resolutions can be chosen: Ignored, Fixed, Known issue options.

The Not resolved option indicates that the alert was reviewed but the solution for that alert has not been found yet.

Let’s try with some examples.

On the Alerts page, let’s list all Medium and Low alerts that are raised in the last 24 hours:

Click on the first alert.

Under the Resolve alert, click the Fixed button, in the Add comment box, enter some notes and press the Save button:

Now, when we go back to the Alerts page, we will notice that the alert has been removed from the alerts list:

Let’s try another example. Click on an alert, in the Resolve alert, select the Not resolved option, enter the comment and click the Save button:

Now, when we go back to the alert grid, we will see that the alert still exists in the alert grid:

As we mentioned earlier, if the Not resolved option is chosen in the Alert detail page, that indicates that the alert was reviewed a solution for the underlying problem hasn’t been ascertained yet.

Now, let’s try resolving a group of alerts.

Go back to the Alerts page and check all the Low severity alerts. After checking all Low severity alerts, click on the Resolve button:

As you can see, a message box appears, that tell us that the Force comments on resolution option is turned on:

When this message is shown, it indicates that, according to the current configuration, before we resolve an alert and remove it from the Alerts page in the Add comments box of the Alerts details page, we must provide a comment.

To resolve one or group of alerts without entering a comment, go to the Administration page, click the Alerts link:

And under the Alert options page, uncheck the Force comments on resolution check box and click the Save button:

The Alert options page will be displayed if we click on the link in the message box:

Now, when we check all low alerts and click the Resolve button …

All low severity alerts will be removed from the Alerts page:

Another option under the Alerts options page is the Generate a report on resolution option. Check this option and choose email under the Email profile drop-down box:

Now, when alerts are resolved, a report with resolved alerts in pdf format will be automatically generated and sent to email which is specified in the Email profile box

To review resolved alerts, go to Reports page, under the Alerts tab, select the Alerts status:

On the Alerts status page, set desired values and click the Generate button

The generated values can be sent via email or saved locally in pdf format

One important bit of information is who has the permissions for resolving alerts.

Alerts can be resolved by users who have a Power or Admin user role, users with the Reader role can add comments but cannot resolve them:

Let’s login as a Reader and see what will get on the Alerts page.

On the Alerts page, choose any alert.

As it can be seen, on the Alerts detail page, comments can be added:

But when pressing the Save button, the alert will not be removed from the Alerts list:

As you may notice, when we are logged as users in a Reader role on the Alerts page, the check boxes at the beginning of every column in the Alerts list and the Resolve button are not available:

Thanks for watching. For more information, please visit apexsql.com