From the course: SQL Server 2016: Administer a Database Infrastructure

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Configure the data collector

Configure the data collector - SQL Server Tutorial

From the course: SQL Server 2016: Administer a Database Infrastructure

Start my 1-month free trial

Configure the data collector

- [Instructor] SQL Server's Data Collector feature is a centralized database that collects information about the health and performance across all of your servers. It uses the SQL Server Agent to schedule and run collection jobs and then stores that information in a data warehouse which controls the retention period of the data. This makes management easier since all of the information about each of your instances and databases can be found in a single location. In this movie, I want to talk about setting up the Data Collector. We'll start with a little terminology. The Target is an instance of SQL Server that will serve as the central repository for the collected data. On this instance is where the Management Data Warehouse or the specific database where the information will be stored. A Data Provider is the individual server or database that will send its health and performance information to the target instance. Finally, a Collector Set is a group of items that controls the…

Contents