What is Data Collector in SQL Server ?

SQL Server introduced the concept of data collector - you can obtain and save data that is gathered from several sources about SQL Server health. The data collector provides data collection containers that you can use to determine the scope and frequency of data collection on a SQL Server system. The data collector provides predefined collector types that you can use for data collection.

The out-of-box collector types are...

  • Generic T-SQL Query Collector Type
  • Generic SQL Trace Collector Type
  • Performance Counters Collector Type
  • Query Activity Collector Type


You May Interest

Deleting Table With Query in MS SQL

What are the System Data Collection Sets Predefined Inside SQL Se ...

Changing Column Name of MS SQL Table with Query

Getting Rows in a Table in Random Order in MS SQL

What is SQL Injection in SQL Server ?