Azure Portal
There are several diagnostic tools available to you for monitoring SQL Database performance. For a quick view of performance metrics, use the Azure portal. For more targeted analysis, you can use DMVs, Query Store, or Extended Events to monitor SQL Database performance just as you do for SQL Server.
In the Azure portal, you can select the metrics that you want to monitor and display a chart that shows average utilization for selected metrics.
To configure the chart, open the blade for your database in the Azure portal, and then click Edit inside the Monitoring chart. In the Edit Chart blade, select one of the following time ranges: Past Hour, Today, Past Week, or Custom. If you select Custom, you can type in a data range or use calendar controls to set a beginning and end date for the range. Next, select one of the following chart types: Bar or Line. Then select one or more of the following metrics:
Blocked by firewall
CPU percentage
DTU limit
DTU percentage
DTU used
Data IO percentage
Database size percentage
Deadlocks
Failed connections
In-memory OLTP storage percent
Log IO percentage
Sessions percentage
Successful connections
Total database size
Workers percentage
After you add the metrics to monitor, you can view the results in the Monitoring chart in addition to details in the Metric window. When you select metrics, you can select compatible metrics only. For example, you can select metrics that count connections, or you can select metrics that measure the percentage of resources consumed, but you cannot mix those two types of metrics in the same chart.
You can also use the Azure portal to configure an email alert when a performance metric exceeds or drops below a specified threshold. Click the Monitoring chart to open the Metric blade. Then click Add Alert and follow the instructions in the Add Alert Rule blade. For example, you can add an alert to send an email when the number of connections blocked by the firewall exceeds 1.
Access management for cloud resources is a critical function for any organization that is using the cloud. Role-based access control (RBAC) helps you manage who has access to Azure resources, what they can do with those resources, and what areas they have access to.
You can configure the name of the resource, the name of the alert rule, and whether to email the alert to owners, contributors, and readers and optionally additional administrators. The following lists four fundamental built-in roles. The first three apply to all resource types.
Owner - Has full access to all resources including the right to delegate access to others.
Contributor - Can create and manage all types of Azure resources but can't grant access to others.
Reader - Can view existing Azure resources.
User Access Administrator - Lets you manage user access to Azure resources.
https://docs.microsoft.com/en-us/azure/role-based-access-control/overview
https://docs.microsoft.com/en-us/azure/role-based-access-control/built-in-roles
Example:
Answer:
