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.
Helpful SQL Azure tip, especially for anyone managing database performance. The comparison with DBCC FREEPROCCACHE makes the difference between Azure and on-premise environments easy to understand. Kamil baber as Mechanical design engineer also shows how technical expertise can span different engineering and technology discussions.
ReplyDelete