Different ways to clear SQL Server Memory

Use DBCC DROPCLEANBUFFERS to test queries with a cold buffer cache without shutting down and restarting the server.

USE METRIC_DATABASE;
GO
CHECKPOINT;
GO
DBCC DROPCLEANBUFFERS;
GO

Ref:

Last updated 4 years ago

Was this helpful?

Use DBCC DROPCLEANBUFFERS to test queries with a cold buffer cache without shutting down and restarting the server.

USE METRIC_DATABASE;
GO
CHECKPOINT;
GO
DBCC DROPCLEANBUFFERS;
GO

Ref: