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.

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.

Start the Register Instance Wizard

  1. On the DPA homepage, click Register DB Instance for Monitoring.
  2. Under Azure, click Azure SQL Managed Instance.
  3. Click Next.
  4. Complete the wizard panels as described in the following sections.

Connection Information panel

  1. Enter the server name or IP address of the ASMI and the port number.
  2. Select the type of authentication you want to use for the monitoring user account.
  3. Enter the user name and password for the monitoring user account that you created previously.
  4. Click Next.

Instance Options panel

  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 existing database instance groups, you can assign the ASMI to one of the groups.

    If you do not have database instance groups, the Instance group field is not shown.

  3. (Optional) If you have existing alert groups, you can assign the ASMI to one or more groups.

    If you do not have alert groups, the Alert group field is not shown.

  4. Click Next.

Summary panel

  1. Review the information. If necessary, click Back to make any corrections.
  2. When all information is correct, click Register.

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