T-SQL Script to Clear SQL Server Cache
'Below script that can be used to clear SQL Server Cache. Helpful while working on performance tuning of SQL Scripts.
1
2
3
4
5
6
7
|
CHECKPOINT;
GO
DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE
DBCC FREESYSTEMCACHE ('ALL')
DBCC FREESESSIONCACHE
GO
|
Note that this script is solely for running on Development environments, do not run in Production as it would cause issues to queries that depend on cached data.'...
http://sqlserverlearner.com/2015/tsql-script-to-clear-sql-server-cache
Trackbacks
Die Kommentarfunktion wurde vom Besitzer dieses Blogs in diesem Eintrag deaktiviert.
Kommentare
Ansicht der Kommentare: Linear | Verschachtelt