In SQL Server 2008, Microsoft has included an entire infrastructure devoted to collecting and reporting on data to improve decision making capabilities. The Data Collector is a system that can collect data from any TSQL query like DMVs, Windows Performance Counters, and the SQL Trace. It bundles any selection of these items into a Collection [...]