Question: how to configure mdw in sql server?
Answer: Launch SQL Server Management Studio, and connect to the SQL Server 2012 Database Engine where you want to configure MDW.
Expand the Management section, and right-click Data Collection.
From the context menu, select Configure Management Data Warehouse, as shown in Figure 43.1. ... 
Click the Next button.