Management Data Warehouse stored procedures (Transact-SQL)
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
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_add_collector_type (Transact-SQL)
- core.sp_purge_data (Transact-SQL)
- core.sp_update_data_source (Transact-SQL)
- core.sp_remove_collector_type (Transact-SQL)
Related content
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for