How to clear cache of the sql server 2000

Question

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Eswin SSCrazy Eights Points: 8320 More actions · Answer 1

Haven't tried but i think this will help

--Clearing Cache for SQL Server Performance Testing

USE ;

GO

CHECKPOINT;

GO

DBCC DROPCLEANBUFFERS;

GO

Tanx 😀

arr.nagaraj SSCertifiable Points: 6538 More actions · Answer 2

DBCC FREEPROCCACHE

DBCC DROPCLEANBUFFERS

/************************/

To Verify whether it has done the job..

DBCC PROCCACHE

The values displayed will be in single digits ( if only the current user is connected ).

Please handle with care while do it production servers..

Gen, I use it only when I am doing performance tuning

Regards,
Raj