Please refer to the Microsoft Azure Sources topic for additional information on how to configure the LPU, and general Azure Data Collection setup details.
Least Privileged User
Steps:
- Using the Azure CLI Client, find the Subscription ID and Tenant ID from your account list
- Create a custom RBAC role using the JSON provided. Include your Subscription ID and rename the file to azure.json
- Create an Active Directory Service Principal and assign the custom RBAC role t it.
Creating custom roles using the Azure CLI:
https://docs.microsoft.com/en-us/azure/role-based-access-control/custom-roles
Assigning roles using the Azure CLI:
https://docs.microsoft.com/en-us/azure/role-based-access-control/role-assignments-portal
{
"Name": "LPU SQL Servers",
"Description": "LPU for SQL Servers",
"Actions": [
"Microsoft.Sql/servers/*/read",
"Microsoft.Sql/servers/databases/providers/Microsoft.Insights/*/read",
"Microsoft.DBforMySQL/*/read",
"Microsoft.DBforPostgreSQL/*/read",
"Microsoft.Storage/*/read",
"Microsoft.Insights/metrics/*/read",
"Microsoft.Authorization/*/read"
],
"AssignableScopes": [
"/subscriptions/[Subscription ID]"
]
}
Connection Parameters
Name | Required? | Description |
|---|---|---|
Subscription ID | Required | GUID Subscription ID |
Tenant ID | Required | GUID Tenant ID (also known as Directory ID) |
Client ID | Required | GUID Client ID (also known as Application ID) |
Client Secret | Required | The Secret (also known as Key) corresponding to the Client ID. |
Maximum HTTP Retry Time (seconds) | The maximum amount of time in seconds to retry each API request when the API is throttling. | |
HTTP Request Timeout (seconds) | The maximum amount of time in seconds before a single HTTP request will fail. | |
Monitor Metric Collection Level | Selects which monitor metrics should be collected. | |
Filter By Resource Group Type | Selects whether to use a whitelist or blacklist when filtering by Resource Groups. | |
Filter By Resource Group Whitelist | A comma separated list of resource groups to explicitly allow. A '*' character is used to represent 'all', and a blank string is used for 'none'. | |
Filter By Resource Group Blacklist | A comma separated list of resource groups to filter out. A '*' character is used to represent 'all', and a blank string is used for 'none'. | |
Filter By Tags Group Type | Selects whether to use a whitelist or blacklist when filtering by Resource Groups. | |
Filter By Tags Group Whitelist | A comma separated list of tags to explicitly allow. Tags must follow the format <key:value>. Instead of a specific tag, or tag value, a '*' character is used to represent 'all'. A blank entry is treated as 'none'. | |
Filter By Tags Group Blacklist | A comma separated list of tags to filter out. Tags must follow the format <key:value>. Instead of a specific tag, or tag value, a '*' character is used to represent 'all'. A blank entry is treated as 'none'. |
Metrics
API Usage
Name | Description |
|---|---|
Average Pages | The average amount of pages needed for a paged resource type. |
Average Request Retries | The average number of retry requests per unique requests made. |
Average Retry Attempts | The average number of retry requests made per unique request that was retried. |
Average Retry Wait (Milliseconds) | The average amount of time retried requests spent waiting. |
Client ID | The client ID used to make API calls. |
Failed Requests | The total number of requests that returned a failure response. |
Maximum Pages | The most amount of pages needed for a paged resource type. |
Maximum Retries | The highest number of retries made for a single request. |
Maximum Retry Wait (Milliseconds) | The most amount of time a retried request spent waiting. |
Minimum Pages | The least amount of pages needed for a paged resource type. |
Minimum Retry Wait (Milliseconds) | The least amount of time a retried request spent waiting. |
Other Status Responses | The total number of successful requests that responded with some other accepted status. |
Request Timeouts | The total number of requests that timed out waiting for a response. |
Requests Retried | The number of unique requests that were retried. |
Retry Status Responses | The total number of successful requests that responded with the status TOO MANY REQUESTS (429). |
Retry Timeouts | The total number of requests that needed to be retried, but the request retry time exceeded the maximum retry time. |
Status OK Responses | The total number of successful requests that responded with the status OK (200). |
Subscription ID | The subscription ID used to make API calls. |
Successful Requests | The total number of requests that returned a successful response. |
Tenant ID | The tenant ID used to make API calls. |
Total Monitor Requests | The total number of requests made to get monitor metrics. |
Total Paged Requests | The total amount of resource types that required paging. |
Total Requests | The total number of requests made during collection. |
Total Retries | The total number of retry requests that were made. |
Unique Monitor Requests | The number of unique requests made to get monitor metrics. |
Unique Requests | The number of requests made with unique endpoints. |
Elastic Pool
Name | Description |
|---|---|
CPU Usage (%) | CPU Usage |
Creation Date | The creation date of the elastic pool |
Database DTU Maximum | The maximum DTU any one database can consume |
Database DTU Minimum | The minimum DTU all databases are guaranteed |
DTU | The total shared DTU for the database elastic pool |
DTU Usage (%) | DTU Usage |
Edition | The edition of the elastic pool |
EDTU Limit | eDTU limit |
EDTU Used | eDTU used |
ID | Resource ID of the elastic pool |
In-Memory OLTP Storage Usage (%) | In-Memory OLTP storage percent |
Location | Resource location of the elastic pool |
Log Write Usage (%) | Log I/O Usage |
Name | Resource name of the elastic pool |
Physical Data Read Usage (%) | Data I/O Usage |
Resource Group | The Resource Group of the Azure resource. |
Sessions Usage (%) | Sessions Usage |
State | The state of the elastic pool |
Storage Limit (Bytes) | Gets storage limit for the database elastic pool |
Storage Usage (%) | Storage Usage |
Storage Used (Bytes) | Storage used |
Tags | Microsoft Azure resource tags |
Type | Microsoft Azure resource type |
Workers Usage (%) | Workers Usage |
Zone Redundant | Whether or not this database elastic pool is zone redundant, which means the replicas of this database will be spread across multiple availability zones |
MySQL Database
Name | Description |
|---|---|
Charset | The charset of the database |
Collation | The collation of the database |
ID | Resource ID of the database |
Name | Resource name of the database |
Type | Microsoft Azure resource type |
MySQL Server
Name | Description |
|---|---|
Active Connections (Connections) | Total active connections |
Administrator Login | The administrator's login name of a server |
Backup Retention (Days) | The amount of time backups are retained for the server |
CPU Usage (%) | CPU usage |
Earliest Restore Date | Earliest restore point creation time |
Failed Connections (Connections) | Total failed connections |
Fully Qualified Domain Name | The fully qualified domain name of the server |
Geo-redundant Backup | Whether to enable Geo-redundant or not for server backup |
ID | The resource ID of the server |
I/O Consumption (%) | I/O consumption |
Location | The resource location the server resides in |
Memory Usage (%) | Memory usage |
Name | The resource name of the server |
Resource Group | The Resource Group of the Azure resource. |
SKU Capacity | The scale up/out capacity, representing server's compute units |
SKU Family | The family of hardware |
SKU Name | The name of the SKU, typically, tier + family + cores |
SKU Tier | The tier of the particular SKU |
SSL Enforcement | Whether to enable ssl enforcement or not when connecting to the server |
Storage Limit (Megabytes) | Max storage allowed for a server |
Storage Usage (%) | Storage usage |
Storage Used (Bytes) | Storage used |
Type | Microsoft Azure resource type |
User Visible State | A state of the server that is visible to user |
Version | The version of the server |
PostgreSQL Database
Name | Description |
|---|---|
Charset | The charset of the database |
Collation | The collation of the database |
ID | Resource ID of the database |
Name | Resource name of the database |
Type | Microsoft Azure resource type |
PostgreSQL Server
Name | Description |
|---|---|
Active Connections (Connections) | Total active connections |
Administrator Login | The administrator's login name of a server |
Backup Retention (Days) | The amount of time backups are retained for the server |
CPU Usage (%) | CPU usage |
Earliest Restore Date | Earliest restore point creation time |
Failed Connections (Connections) | Total failed connections |
Fully Qualified Domain Name | The fully qualified domain name of the server |
Geo-redundant Backup | Whether to enable Geo-redundant or not for server backup |
ID | The resource ID of the server |
I/O Consumption (%) | I/O consumption |
Location | The resource location the server resides in |
Memory Usage (%) | Memory usage |
Name | The resource name of the server |
Resource Group | The Resource Group of the Azure resource. |
SKU Capacity | The scale up/out capacity, representing server's compute units |
SKU Family | The family of hardware |
SKU Name | The name of the SKU, typically, tier + family + cores |
SKU Tier | The tier of the particular SKU |
SSL Enforcement | Whether to enable ssl enforcement or not when connecting to the server |
Storage Limit (Megabytes) | Max storage allowed for a server |
Storage Usage (%) | Storage percentage |
Storage Used (Bytes) | Storage used |
Type | Microsoft Azure resource type |
User Visible State | A state of the server that is visible to user |
Version | The version of the server |
SQL Database
Name | Description |
|---|---|
Blocked By Firewall | Blocked by Firewall |
Collation | The collation of the database |
Containment State | The containment state of the database |
CPU Usage (%) | CPU usage |
Creation Date | The creation date of the database |
Current Service Objective ID | The current service level objective ID of the database. This is the ID of the service level objective that is currently active. |
Data Warehouse Node Data Read Usage (%) | DW node level Data I/O usage |
Data Warehouse Node Level CPU Usage (%) | DW node level CPU usage |
Database ID | The ID of the database |
Database Storage Usage (%) | Database size usage |
Deadlocks | Deadlocks |
Default Secondary Location | The default secondary region for this database |
DTU Limit | DTU Limit |
DTU Usage (%) | DTU usage |
DTU Used | DTU used |
DWU Consumption Usage (%) | DWU usage |
DWU Limit | DWU limit |
DWU Used | DWU used |
Earliest Restore Date | This records the earliest start date and time that restore is available for this database |
Edition | The edition of the database |
Elastic Pool Name | The name of the elastic pool the database is in |
Failed Connections (Connections) | Failed Connections |
Failover Group ID | The resource identifier of the failover group containing this database |
ID | Resource ID of the database |
In-Memory OLTP Storage (%) | In-Memory OLTP storage percent |
Kind | Kind of database |
Location | Resource location of the database |
Log Write Usage (%) | Log I/O usage |
Maximum Database Size (Bytes) | The max size of the database |
Name | Resource name of the database |
Physical Data Read Usage (%) | Data I/O usage |
Read Scale | If the database is a geo-secondary, readScale indicates whether read-only connections are allowed to this database or not. Not supported for DataWarehouse edition |
Requested Service Objective ID | The configured service level objective ID of the database. This is the service level objective that is in the process of being applied to the database |
Requested Service Objective Name | The name of the configured service level objective of the database. This is the service level objective that is in the process of being applied to the database |
Sample Name | Indicates the name of the sample schema to apply when creating this database |
Service Level Objective | The current service level objective of the database |
Sessions Usage (%) | Sessions usage |
Status | The status of the database |
Successful Connections (Connections) | Successful Connections |
Total Database Size (Bytes) | Total database size |
Type | Microsoft Azure resource type |
Workers Usage (%) | Workers usage |
SQL Server
Name | Description |
|---|---|
Administrator Login | Administrator username for the server |
Fully Qualified Domain Name | The fully qualified domain name of the server |
ID | The resource ID of the server |
Kind | Kind of SQL server |
Location | The resource location of the server |
Name | The resource name of the server |
Resource Group | The Resource Group of the Azure resource. |
State | The state of the server |
Type | Microsoft Azure resource type |
Version | The version of the server |
Updated about a year ago