query caching?

[karen4201]

This is a beginner question: It seems like SQL Server caches a query and its results. Is there a way to clear the cache so that I can test the run-time for a query? I'd like to see how long it would run for a new visitor to my database-driven web site. Then I could optimize the query.

Thanks in advance.

 

[jbenson001]

it caches the execution plan not the results

 

[gmmastros]

DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS

From BOL:

Use DBCC FREEPROCCACHE to clear the procedure cache. Freeing the procedure cache would cause, for example, an ad-hoc SQL statement to be recompiled rather than reused from the cache.

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



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[karen4201]

Thanks.

I used:
CHECKPOINT
DBCC DROPCLEANBUFFERS

and got exactly what I was looking for.

Thanks.