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:

To include only specific alert state in the alerts grid, for example Not fixed, Unread, in the alert state box, choose that options:

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

To resolve alerts one by one, from the alerts grid, next to the Severity 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:

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 check box next to the alert has been removed:

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 check box next to the alert still visible 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, under the Resolve as drop-down box, choose one of resolving option:

As you can see, the Resolve alerts dialog appears:

Enter a comment and press the Apply button.

When the Resolve alerts dialog is shown, it indicates that, according to the current configuration, before we resolve an alert in the Resolve alerts comment box, 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 same can be archived by clicking the Force comments on resolution link on the Resolve alerts dialog:

Now, when we check all low alerts and chose one of the resolved solutions under the Resolve as drop-down box:

All check boxes next to 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 only for the Not resolved card:

As you may notice, when we are logged as users in a Reader role on the Alerts page, select some alert check boxes and from the Resolve as drop-down box, choose any option, the following message will appear:

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