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

15. Before we proceed to enable the data collection, it is essential to restart and upload
the non-utility collection sets to the Data Collection .
16. To upload and pass a validation of non-utility collection sets, execute the following
TSQL from Query Editor:
execmsdb.dbo.sp_syscollector_set_warehouse_database_name NULL
execmsdb.dbo.sp_syscollector_set_warehouse_instance_name NULL
17. Under the Management folder, right-click on Data Collection and choose Enable the
data collector from SSMS, which is shown in the following screenshot:
18. Once we have completed the MDW wizard, the data collection information will be
stored in the data warehouse databases.
To ensure that both the utility collection sets exist, review the Data Collection option from
SSMS, as shown in the preceding screenshot, which completes the process as a successful
implementation of utility and non-utility collection sets on the same instance.
How it works...
The utility data collection sets are installed and automatically started on each instance of SQL
Server 2008 R2 when they are configured using Utility Control Point. The UMDW database is
created on the instance where UCP is configured and the following collection set and items
are stored:
F Utility Information—DAC Information
F Utility Information—SMO Information
F Utility Information—Utility Allocated CPU Info
F Utility Information—Utility CPU-Memory Related Info