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.