Azure SQL Database

Pack Assets

Templates

The Centreon Plugin Pack Azure SQL Database brings a host template:

Cloud-Azure-Database-SqlDatabase-custom

It brings the following service templates:

Service Alias	Service Template	Service Description	Default
App-Resources	Cloud-Azure-Database-SqlDatabase-App-Resources	Check App CPU and memory metrics
Connections	Cloud-Azure-Database-SqlDatabase-Connections	Check the number of connections
Deadlocks	Cloud-Azure-Database-SqlDatabase-Deadlocks	Check database for deadlocks
Health	Cloud-Azure-Database-SqlDatabase-Health	Check database state	X
Sessions	Cloud-Azure-Database-SqlDatabase-Sessions	Check sessions usage
Storage	Cloud-Azure-Database-SqlDatabase-Storage	Check database size
Workers	Cloud-Azure-Database-SqlDatabase-Workers	Check the number of workers

Discovery rules

The Centreon Plugin Pack Azure SQL Database includes a Host Discovery provider to automatically discover the Azure instances of a given subscription and add them to the Centreon configuration. This provider is named Microsoft Azure SQL Database:

This discovery feature is only compatible with the api custom mode. azcli is not supported.

More information about discovering hosts automatically is available on the dedicated page.

Collected metrics & status

Metric Name	Unit
sqldatabase.serverless.app.cpu.percentage	%
sqldatabase.serverless.app.memory.percentage	%

Metric Name	Unit
sqldatabase.connection.blocked.count
sqldatabase.connection.failed.count
sqldatabase.connection.successful.count

Metric Name	Unit
sqldatabase.deadlocks.count

Metric Name	Unit
Database health status	string

Metric Name	Unit
sqldatabase.sessions.count

Metric Name	Unit
sqldatabase.storage.space.usage.bytes	B
sqldatabase.storage.space.usage.percentage	%

Metric Name	Unit
sqldatabase.workers.count

Prerequisites

Please find all the prerequisites needed for Centreon to get information from Azure on the dedicated page.

Setup

Online License
Offline License

Install the plugin package on every Centreon poller expected to monitor Azure SQL Database resources:

yum install centreon-plugin-Cloud-Azure-Database-SqlDatabase-Api

On the Centreon web interface, on page Configuration > Plugin Packs, install the Azure SQL Database Centreon Plugin Pack.

Install the plugin package on every Centreon poller expected to monitor Azure SQL Database resources:

yum install centreon-plugin-Cloud-Azure-Database-SqlDatabase-Api

Install the Azure SQL Database Centreon Plugin Pack RPM on the Centreon central server:

yum install centreon-pack-cloud-azure-database-sqldatabase

On the Centreon web interface, on page Configuration > Plugin Packs, install the Azure SQL Database Centreon Plugin Pack.

Configuration

Host

Log into Centreon and add a new host through Configuration > Hosts.
In the IP Address/DNS field, set the following IP address: 127.0.0.1.
Aplly the Cloud-Azure-Database-SqlDatabase-custom template to the host.
Once the template is applied, fill in the corresponding macros. Some macros are mandatory. These mandatory macros differ depending on the custom mode used.

Two methods can be used to set the macros:

Full ID of the Resource (/subscriptions/<subscription_id>/resourceGroups/<resourcegroup_id>/providers/XXXXX/XXXXX/<resource_name>) in AZURERESOURCE
Resource name in the AZURERESOURCE macro, and resource group name in the AZURERESOURCEGROUP macro.

Azure Monitor API
Azure AZ CLI

Mandatory	Macro	Description
	AZUREAPICUSTOMMODE	Custom mode api
	AZURECLIENTID	Client ID
	AZURECLIENTSECRET	Client secret
	AZURERESOURCE	ID or name of the Azure SQL Database resource
	AZURERESOURCEGROUP	Resource group name if resource name is used
	AZURESUBSCRIPTION	Subscription ID
	AZURETENANT	Tenant ID

Mandatory	Macro	Description
	AZURECLICUSTOMMODE	Custom mode azcli
	AZURERESOURCE	ID or name of the Azure SQL Database resource
	AZURERESOURCEGROUP	Resource group name if resource name is used
	AZURESUBSCRIPTION	Subscription ID

How to check in the CLI that the configuration is OK and what are the main options for?

Once the plugin is installed, log into your Centreon poller's CLI using the centreon-engine user account (su - centreon-engine) and test the plugin by running the following command:

/usr/lib/centreon/plugins//centreon_azure_database_sqldatabase_api.pl \
    --plugin=cloud::azure::database::sqldatabase::plugin \
    --mode=deadlocks \
    --custommode='api' \
    --resource='SQLDB001A' \
    --resource-group='RSG1234' \
    --subscription='xxxxxxxxx' \
    --tenant='xxxxxxxxx' \
    --client-id='xxxxxxxxx' \
    --client-secret='xxxxxxxxx' \
    --proxyurl=''  \
    --warning-deadlocks='' \
    --critical-deadlocks='' \

The expected command output is shown below:

OK: Deadlocks: 0  | 'sqldatabase.deadlocks.count'=0;;;0; 

All available options for a given mode can be displayed by adding the --help parameter to the command:

/usr/lib/centreon/plugins//centreon_azure_database_sqldatabase_api.pl \
    --plugin=cloud::azure::database::sqldatabase::plugin \
    --mode=deadlocks \
    --help

All available modes can be displayed by adding the --list-mode parameter to the command:

/usr/lib/centreon/plugins//centreon_azure_database_sqldatabase_api.pl \
    --plugin=cloud::azure::database::sqldatabase::plugin \
    --list-mode

Troubleshooting

Please find the troubleshooting documentation for the API-based plugins in this chapter.

Pack Assets​

Templates​

Discovery rules​

Collected metrics & status​

Prerequisites​

Setup​

Configuration​

Host​

How to check in the CLI that the configuration is OK and what are the main options for?​

Troubleshooting​