Tuesday, May 25, 2010

Clear SQL Server Cache

When perform benchmark testing, make sure you need to clean the SQL server cache in order to have a more accurate result.

-- Clean all data in the cache
DBCC DROPCLEANBUFFERS

-- clean cache from stored procedure
DBCC FREEPROCCACHE

No comments: