Hello,

https://docs.microsoft.com/zh-CN/sql/t-sql/statements/alter-database-scoped-configuration-transact- sql?view = sql-server-2017

You can use ALTER DATABASE SCOPED CONFIGURATION with arguments XTP_PROCEDURE_EXECUTION_STATISTICS and XTP_QUERY_EXECUTION_STATISTICS to clear DMVs related with store procedures and queries.

https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-scoped-configuration-transact-sql?view=sql-server-2017

Hope this helps.

Regards,

SQLCoffee.com

Alberto Morillo
SQLCoffee.com