Register an Azure SQL Managed Instance
Complete the following tasks to register a single Azure SQL Managed Instance (ASMI) for DPA to monitor.
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
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.
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
On the DPA home page, click Register DB Instance for Monitoring.
Under Microsoft Azure, select Azure SQL Managed Instance. Then click Next.
Select the type of authentication you want to use for the monitoring user account.
Enter the user name and password for the monitoring user account that you created previously. Then click Next.
The instance name and group membership can be changed after registration.
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.
(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.
(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.
- 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.