Home » SQL Server

Category Archives: SQL Server

Translate:

Archives

SQL Database Instance Alert Creation

Creating Alerts in Azure Portal for SQL Database Instances

 

Creating SQL Database in Azure and Accessing from on premises using SSMS tool

 

Login to Azure Portal

 

On the Azure Portal left side you will see Tab “SQL Databases” (Home -> SQL Database).

Click on the Tab SQL Database and select the Name of the Database you want to create alerts as shown below:

 

 

In my scenario I have selected database with test account “ttest

 

Click on the Database “ttest“.

 

We will be routed to another Page –> Home > SQL database > DB Name

 

With detailed description, on the middle of the page you will see the main Tabs

 

Overview

Settings

Monitoring

Support + Troubleshooting

 

Go to Tab “MONITORING” as shown below:

 

 

 

Configuring Alert Rules under Monitoring

 

Click Alert Rules

 

In the middle of the page you will see + Add alert

 

Click on Add Alert

 

Home > SQL databases > Database Name – Alert rules > Add an alert rule

 

 

 

The moment you click on Add an Alert you will the page with the parameters that needs to be assigned as shown below:

 

 

Here we can change the Database name per your requirement

 

 

Now we need to set the Alerts one after the other

 

 

Creating Alerts:

 

Alert 1: Blocked by Firewall

 

Note: While creating alerts make sure we use the right terminology for identification. Here we have 15 metrics but we will see alert creating using the Threshold one with Count and one with Percentage.  Also we need to create alerts one for Warning and one for High

For High Alert conditions mentioned below:

 

Condition >85 as High Alert

Condition>=60 as Warning (And these can be changed per the client requirement)

 

Below alert creating using the Threshold Count

 

 

Click OK

After you click OK you will see the Alert status created as shown below:

 

 

Let see the alert creating for Alerts High and Warning using conditions and setting Threshold values

Alert Name: CPU Percentage (Warning)

 

 

Click OK

After you click OK you will see the Alert status created as shown below:

 

 

Alert Name: CPU Utilization (High)

 

 

 

Click OK

After you click OK you will see the Alert status created as shown below:

 

 

Yes here ends creating Alerts for SQL using Azure Portal….

Now based on the server performance alert will be triggered to your ticketing tool.

 

Thanks,

Praveen Kumar

MCSE – Cloud Platform and Infrastructure

Translate »