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.
ALTER DATABASE SCOPED CONFIGURATION CLEAR PROCEDURE_CACHE;
This is same as running DBCC FREEPROCCACHE in the on-Premise SQL Instance.
No comments:
Post a Comment