The collector type defines how data is collected from a specific data provider (by using schematized parameters) and specifies the data storage schema.
The data provider schema and storage schema are required in order to store the data that is collected.
collection mode The manner in which the data is collected and stored. Cached mode supports continuous collection, whereas non-cached mode is intended for on-demand collection or a collection snapshot.
management data warehouse A relational database used to store collected data.
You should understand the following concepts: target An instance of the Database Engine in an edition of SQL Server that supports Data Collection.
For more information about supported editions, see the "Manageability" section of Features Supported by the Editions of SQL Server 2016.
For example, a SQL Server instance target has different characteristics than a SQL Server database target.The data collector stores the collected data in a relational database known as the management data warehouse.The data collector is a core component of the data collection platform for SQL Server 2017 and the tools that are provided by SQL Server.The data collector supports dynamic tuning for data collection and is extensible through its API.For more information, see Data Collector Programming.