Management Data Warehouse Stored Procedures (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2012)yesAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

The data collector stores data and data collector type information in the management data warehouse. The following stored procedures are used to update data and change the tables in the management data warehouse.

core.sp_create_snapshot (Transact-SQL) core.sp_update_data_source (Transact-SQL)
core.sp_add_collector_type (Transact-SQL) core.sp_remove_collector_type (Transact-SQL)
core.sp_purge_data (Transact-SQL)

See Also

Data Collector Stored Procedures (Transact-SQL)