Monday 30 July 2018

Free Procedure Cache in SQL Azure Database

To free up the procedure cache on the SQL Azure database use the following ALTER DB Statement,

ALTER DATABASE SCOPED CONFIGURATION CLEAR PROCEDURE_CACHE;

This is same as running DBCC FREEPROCCACHE in the on-Premise SQL Instance.