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.
ReplyDelete8B0EC05D
ReplyDeleteMilas
Yakuplu
Karasu
Ortaca
Kulu
Ölüdeniz
Altınova
Payas
Bala
B1D8BA13
ReplyDeleteDilovası
Hendek
Yıldırım
Kayapınar
Kınık
Fethiye
Selçuk
Kumluca
Serdivan