eMDW is a centralized SQL Server database repository, which stores various server/database/objects properties and performance related statistics. eMDW provides a unique visibility across entire SQL Server environment from one place and data analysis reports using SQL Reporting Service.