Posted By: Anonymous
I’ve got a simple query running against SQL Server 2005
SELECT * FROM Table WHERE Col = 'someval'
The first time I execute the query can take
> 15 secs. Subsequent executes are back in
< 1 sec.
How can I get SQL Server 2005 not to use any cached results? I’ve tried running
DBCC DROPCLEANBUFFERS DBCC FREEPROCCACHE
But this seems to have no effect on the query speed (still
< 1 sec).
Here is some good explaination. check out it.
CHECKPOINT; GO DBCC DROPCLEANBUFFERS; GO
From the linked article:
If all of the performance testing is conducted in SQL Server the best approach may be to issue a CHECKPOINT and then issue the DBCC DROPCLEANBUFFERS command. Although the CHECKPOINT process is an automatic internal system process in SQL Server and occurs on a regular basis, it is important to issue this command to write all of the dirty pages for the current database to disk and clean the buffers. Then the DBCC DROPCLEANBUFFERS command can be executed to remove all buffers from the buffer pool.