- /*
- https://yabele.blogspot.com/2017/07/mssql-how-to-clear-all-caches.html
- */
- SET NOCOUNT ON;
- DECLARE @StartedAt DATETIME2 = GETDATE();
- CHECKPOINT;
- DBCC DROPCLEANBUFFERS;
- DBCC FREESYSTEMCACHE ('ALL');
- -- Query
- PRINT ' Elapsed time: ' + CAST(DATEDIFF(ms, @StartedAt, GETDATE()) AS VarChar(20)) + ' ms';
No comments:
Post a Comment
Note: only a member of this blog may post a comment.