O'Reilly logo

Expert Scripting and Automation for SQL Server DBAs by Peter A. Carter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Peter A. Carter 2016

Peter A. Carter, Expert Scripting and Automation for SQL Server DBAs, 10.1007/978-1-4842-1943-0_8

8. Driving Automation Through Monitoring

Peter A. Carter

(1)Botley, UK

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required