Documentation forDatabase Performance Analyzer

Register an Azure SQL Managed Instance

Complete the following tasks to register a single Azure SQL Managed Instance (ASMI) for DPA to monitor.

You can also use mass registration to registrations to register multiple database instances, or you can register database instances using scripts that call the DPA API.

For DPA to collect metrics from a monitored SQL Server instance, Azure SQL instance, or ASMI, the SQL option NUMERIC_ROUNDABOUT must be set to OFF.

Registering an ASMI is slightly different than registering other types of monitored database instances:

  • You cannot use the wizard to create the DPA monitoring user. Create the monitoring user manually, as described below.
  • If the DPA repository is an Oracle database, DPA stores performance data for monitored ASMIs in the default tablespace of the repository user. You cannot change the default tablespace in the Register Instance Wizard. If you need to change the default tablespace, register the instance using mass registration.

Create the monitoring user

In the ASMI, create a user account to serve as the DPA monitoring user. DPA uses this account to register and monitor the instance.

This account must have the SYSADMIN role. For instructions, see Create the DPA monitoring user for SQL Server and Azure SQL Managed Instance.

DPA ignores data on the monitored database instance from the monitoring user. Make sure the monitoring user will not cause load on the monitored instance.

Complete the Register Instance Wizard

  1. On the DPA home page, click Register DB Instance for Monitoring.

  2. Under Microsoft Azure, select Azure SQL Managed Instance. Then click Next.

  3. On the Enter Monitored Database Instance Connection Information panel, enter the server name or IP address of the ASMI and the port number.

  4. Select the type of authentication you want to use for the monitoring user account.

  5. Enter the user name and password for the monitoring user account that you created previously. Then click Next.

  6. Specify the following Instance options.

    The instance name and group membership can be changed after registration.

    1. Enter the name that DPA will display to identify this database instance.

      The Display name field defaults to the ASMI name retrieved from the instance.

    2. (Optional) If you have manually created instance groups, you can assign this database instance to one of the groups.

      If no manual groups exist, this option is not shown.

    3. (Optional) If you have existing alert groups, you can assign this database instance to one or more groups.

      If no alert groups exist, or the existing groups do not match this instance's database type, this option is not shown.

    4. Click Next.

  7. Review the information on the Summary page. Click Back if you need to make changes. When the information is correct, click Register.

After you have registered the ASMI, you can (optionally) remove the SYSADMIN role from the DPA monitoring user.