SQL Server Management Data Warehouse (MDW)

The SQL Server Management Data Warehouse (MDW) is one of the most underappreciated features of SQL Server. But it’s a really handy feature which logs WaitStats and more, with almost no overhead (< 1% CPU). And…it does generate some nice reports which you could use to monitor your server (out of the box):

SQL Server 2012 Master DWH






























How to enable it
For more info (and how to enable it), please visit:
http://www.johnsansom.com/sql-server-management-data-warehouse-and-why-it-rocks/








Advertisements