Azure SQL database server is a logical container for managing databases and elastic pools.

Use the Azure public cloud integration to discover and collect metrics against the Azure SQL Database.

External reference

What is a logical SQL server in Azure SQL Database and Azure Synapse?

Setup

To set up the Azure integration and discover the Azure service, go to Azure Integration Discovery Profile and select Azure SQL Server.

Event support

  • Supported
  • Configurable in OpsRamp Azure Integration Discovery Profile.

Supported metrics

MSSQL Advance Monitoring - Azure

OpsRamp now supports the MSSQL Advance database monitoring for AZURE using the Gateway Collector.

Whitelisting Gateway IP in Azure

In order to perform advance monitoring for Azure resources, we need to whitelist the IP of the host of the Gateway machine.

To whitelist the IP:

  1. Log in to the Azure portal.
  2. Under Security, select Networking.
  3. In the Networking page, under Firewall rules section, click Add a firewall rule.
  4. Enter the rule name and IP address of the host you want to whitelist.
  5. Click Save.
    The gateway is now whitelisted.

Advance Monitoring configuration

Once you whitelist the gateway in Azure portal, you can now configure for advance monitoring in OpsRamp portal.

  1. Log in to the OpsRamp portal.
  2. Go to Infrastructure > Resources > Microsoft Azure.
  3. Select SQL servers.
  4. From the SQL server details page, select a resource.
  5. In the resource details page, click settings.
  6. From the settings drop-down, click Assign Gateway Profile.
  7. Select a management profile from the drop-down menu.
  8. Click Assign.
  9. Select Credentials from the left hand navigation pane and click Add.
  10. Enter the below mentioned credential information:
FieldDescription
NameName for new credential.
DescriptionAdd a description of the credential.
TypeSelect as Database.
UsernameEnter the username of the resource created in Azure portal.
PasswordEnter the password of the resource created in Azure portal.
Confirm PasswordEnter the password again.
PortPort should be 1433.
Connection Time out (ms)Specify the timeout duration.
  1. Click Save.
  2. Select Monitors from the left hand navigation pane and click Assign Templates.
  3. In the Apply Templates page, select Collector Type as Gateway.
  4. Under Assign Templates, search for MSSQL templates and assign required templates.
  5. Select Metrics from the left hand navigation pane and you can see the monitoring data.