In order to monitor an instance with SQL Workload Analysis, you need to register it with SQL Workload Analysis. This section helps you register one or more instances with SQL Workload Analysis.

Access the Add Instance Wizard

You can access the Add Instance wizard from the Add SQL Server Instance option in the Administration tab.

To add an Instance follow these steps:

1. Specify the Instance(s)

In the SQL Server instance field, type the name of the instance or instances you want to monitor with SQLWA. Use a semicolon to separate instances.

Click NEXT

2. Specify the connection credentials

In this section, you can choose to use SQL Server Authentication or Windows Authentication from the Account Type list. 

If you choose SQL Server Authentication, select Enable OS Statistics Collection to retrieve OS Statistics information, type the user name and password. If you choose to use Windows Authentication , type the respective user name, password, and domain name.

3. Finish

To change registration details you can:

• • Click any of the fields such as Instance, SQL Connection Credentials, WMI Connection Credentials, or Monitor BI services and the appropriate screen displays.
  • Click PREV to go back to previous screens until you find the one you need to modify.

After you review your registration details click FINISH.

SQL Workload Analysis makes SQL Server performance tuning easy.