<%NUMBERING1%>.<%NUMBERING2%>.<%NUMBERING3%> PRTG Manual: Microsoft Azure SQL Database Sensor
The Microsoft Azure SQL Database sensor monitors the metrics of an Azure SQL Database (single database or elastic pool) in a Microsoft Azure subscription.
Microsoft Azure SQL Database Sensor
For a detailed list and descriptions of the channels that this sensor can show, see section Channel List.
Sensor in Other Languages
Dutch: Microsoft Azure SQL database
French: Base de données SQL Microsoft Azure
German: Microsoft Azure SQL-Datenbank
Japanese: Microsoft Azure SQL Database
Portuguese: Banco de dados SQL do Microsoft Azure
Russian: База данных Microsoft Azure SQL
Simplified Chinese: Microsoft Azure SQL 数据库
Spanish: Base de datos SQL de Microsoft Azure
Remarks
This sensor requires an Azure custom role with permissions for specific actions.
This sensor requires credentials for Microsoft Azure in settings that are higher in the object hierarchy.
This sensor supports IPv6.
This sensor has a very low performance impact.
This sensor remains in the Up status even if the database or elastic pool is not online. In this case, PRTG displays a message regarding the status and the unavailable metrics for the database or elastic pool.
If the name contains angle brackets (<>), PRTG replaces them with braces ({}) for security reasons. For more information, see the Knowledge Base: What security features does PRTG include?
This setting is for your information only. You cannot change it.
Tags
Enter one or more tags. Confirm each tag with the Spacebar key, a comma, or the Enter key. You can use tags to group objects and use tag-filtered views later on. Tags are not case-sensitive. Tags are automatically inherited.
It is not possible to enter tags with a leading plus (+) or minus (-) sign, nor tags with parentheses (()) or angle brackets (<>).
For performance reasons, it can take some minutes until you can filter for new tags that you added.
The sensor has the following default tags that are automatically predefined in the sensor's settings when you add the sensor:
azure
microsoftazure
microsoftazuresqldatabase
Priority
Select a priority for the sensor. This setting determines the position of the sensor in lists. The highest priority is at the top of a list. Choose from the lowest priority () to the highest priority ().
Microsoft Azure Specific
Microsoft Azure Specific
Setting
Description
Azure SQL Database Name
The name of the Azure SQL Database that this sensor monitors.
If you change the database name in your Microsoft Azure subscription, you must add the sensor anew.
Azure SQL Database ID
The ID of the Azure SQL Database that this sensor monitors.
Azure SQL Server Name
The name of the Azure SQL server that hosts the Azure SQL Database.
Resource Type
The resource type of the Azure SQL Database that this sensor monitors. This can be a single database or an elastic pool in a virtual core (vCore) based purchasing model or a DTU-based purchasing model.
If you change the resource type in your Microsoft Azure subscription, you must add the sensor anew.
Region
The Azure region of the Azure SQL Database that this sensor monitors.
Purchasing Model
The purchasing model of the Azure SQL Database. This can be vCore based or DTU based.
Elastic Pool
The name of the elastic pool if the resource type of the Azure SQL Database is an elastic pool. If the resource type is not an elastic pool, the field shows n/a.
Sensor Display
Sensor Display
Setting
Description
Primary Channel
Select a channel from the list to define it as the primary channel. In the device tree, the last value of the primary channel is always displayed below the sensor's name. The available options depend on what channels are available for this sensor.
You can set a different primary channel later by clicking below a channel gauge on the sensor's Overview tab.
Graph Type
Define how different channels are shown for this sensor:
Show channels independently (default): Show a graph for each channel.
Stack channels on top of each other: Stack channels on top of each other to create a multi-channel graph. This generates a graph that visualizes the different components of your total traffic. You cannot use this option in combination with manual Vertical Axis Scaling (available in the channel settings).
Stack Unit
This setting is only visible if you select Stack channels on top of each other above.
Select a unit from the list. All channels with this unit are stacked on top of each other. By default, you cannot exclude single channels from stacking if they use the selected unit. However, there is an advanced procedure to do so.
Debug Options
Debug Options
Setting
Description
Result Handling
Define what PRTG does with the sensor result:
Discard result (default): Do not store the sensor result.
Store result: Store the last sensor result in the \Logs\sensors subfolder of the PRTG data directory on the probe system. The file name is Result of Sensor [ID].log. This setting is for debugging purposes. PRTG overwrites this file with each scanning interval.
This option is not available when the sensor runs on the hosted probe of a PRTG Hosted Monitor instance.
In a cluster, PRTG stores the result in the PRTG data directory of the master node.
Inherited Settings
By default, all of these settings are inherited from objects that are higher in the hierarchy. We recommend that you change them centrally in the root group settings if necessary. To change a setting for this object only, click under the corresponding setting name to disable the inheritance and to display its options.
The minimum scanning interval of this sensor is 1 minute.
The recommended scanning interval of this sensor is 5 minutes.
Scanning Interval
For more information, see section Root Group Settings, section Scanning Interval.
Schedules, Dependencies, and Maintenance Window
You cannot interrupt the inheritance for schedules, dependencies, and maintenance windows. The corresponding settings from the parent objects are always active. However, you can define additional schedules, dependencies, and maintenance windows. They are active at the same time as the parent objects' settings.
Schedules, Dependencies, and Maintenance Window
For more information, see section Root Group Settings, section Schedules, Dependencies, and Maintenance Window (default).
Access Rights
Access Rights
For more information, see section Root Group Settings, section Access Rights.
Channel Unit Configuration
Which channel units are available depends on the sensor type and the available parameters. If no configurable channels are available, this field shows No configurable channels.
Channel Unit Configuration
For more information, see section Root Group Settings, section Channel Unit Configuration.
Channel List
Which channels the sensor actually shows might depend on the target device, the available components, and the sensor setup.
Channel
Description
Connections Failed
The number of failed connections
CPU Used %
The CPU usage (%)
This channel is the primary channel by default.
Data I/O %
The data I/O operations (%)
Data Space Used
The data space usage
Data Space Used %
The data space usage (%)
Deadlocks
The number of deadlocks
Downtime
In the channel table on the Overview tab, this channel never shows any values. PRTG uses this channel in graphs and reports to show the amount of time in which the sensor was in the Down status
DTU %
The DTUs (%)
DTU Limit
The DTU limit
DTU Used
The used DTU
eDTU Limit
The eDTU limit
eDTU Used
The used eDTU
Log I/O
The log I/O operations
Sessions %
The sessions (%)
More
KNOWLEDGE BASE
How do I obtain credentials and create custom roles for the Microsoft Azure sensors?