Managing the Core Database Engine - Microsoft SQL Server 2008 R2 Administration - page 108

How to do it...

Using SQL Server Management Studio, these are the steps to implement the utility and non-
utility data collection sets:

1. To implement the utility data collection sets, connect to the Utility Explorer where the

UCP is registered.

2. Right-click on Managed Instances and choose Enroll instance (refer to the

next screenshot).

3. Specify the instance name of SQL Server to enroll.

4. Specify the service account to run the utility collection set.

To specify the account to collect data, you can choose SQL
Server Agent service account, but for security precautions,
it is recommended to propose a new account or existing
domain user account with the required privileges.

5. Review prerequisite validation results and selections.

6. Enroll the instance.