Applications Systems

Using the Application Intent flag when registering a database instance in DPA

DPA supports the Application Intent flag when you are registering a database instance. This flag is ignored if you are registering a SQL Server AG listener.

First published date

10/9/2018 5:04 PM

Last published date

10/9/2018 5:04 PM

Overview

DPA supports the Application Intent flag when you are registering a database instance. This flag is ignored if you are registering a SQL Server AG listener.

Product section

Database Performance Analyzer

Resolution

To specify the Application Intent flag:

On Step 2 of the Register Instance Wizard, click Advanced Connection Properties.
Enter the following in either the JDBC URL Properties or the Connection Properties field:
```
applicationIntent=readOnly
```

Also, DPA users can navigate the following to change the AG readOnly flag:

Options, Monitor Setup, Update Connection Info, select instance, select JDBC URL Properties and enter the string applicationIntent=readOnly

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.