sys.sp_purge_data

general
#stored-procedure

Description

Removes data from the management data warehouse based on a retention policy. This procedure is executed daily by the SQL Server Agent job against the management data warehouse associated with the specified instance. You can use this stored procedure to perform an on-demand removal of data from the management data warehouse. The number of days to retain data in the management data warehouse tables.

Syntax

<computername>\<instancename>