Working with Data Collection and the Management Data Warehouse
Monitoring is key to producing sophisticated automation. It allows you to respond to performance conditions by running appropriate routines to resolve an issue. SQL Server provides DBAs with extensible data collection, which is capable of collecting any data, not just performance data. The data is then stored in the MDW (Management Data Warehouse), which provides a single repository for data that has been collected throughout the enterprise.
Understanding Data Collection
Data Collection provides an ...