MS SQL Server - Re: DROPCLEANBUFFERS doesn't seem to clear cache

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: DROPCLEANBUFFERS doesn't seem to clear cache

JXStern

2006-10-24, 6:28 pm

On 12 Sep 2006 11:48:15 -0700, element533@gmail.com wrote:
>I have a query that I'm trying to benchmark. The first time I run it,
>it takes 40 seconds to run. The next time I run it, it returns in 0
>seconds.
>
>I execute the following:
>
>CHECKPOINT
>DBCC DROPCLEANBUFFERS
>DBCC FREEPROCCACHE
>
>Then I run the query again and it takes 40 seconds, as expected.
>Re-running the query causes it to go back down to 0 seconds, as
>expected. However, from this point forward, even if I run the commands
>above, the query stays at 0 seconds! I can't seem to clear the cache
>anymore.

Pretty weird.

You haven't left any transactions open, have you?

You might turn on a few perfmon stats to see if you can get more info.

J.

Sponsored Links