Post reply

Can you flush the cache?

  • August 27, 2003 at 3:56 pm

    #160565

    Is there a way to flush the (data) cache?

    I'm testing performance, by running the same set of commandes multiple times, and want to ensure caching of results is taken out of the equation

    Rgds,

    Brendon.

  • August 27, 2003 at 4:20 pm

    #471703

    Try this: DBCC DROPCLEANBUFFERS

  • August 27, 2003 at 4:23 pm

    #471704

    DBCC DROPCLEANBUFFERS is supposed to do it, but I haven't tested it.

  • August 27, 2003 at 5:06 pm

    #471709

    I've tested DBCC DROPCLEANBUFFERS

    and it seems to do exactly what I want.

    Cheers.

  • August 28, 2003 at 6:59 am

    #471796

    Either DBCC DROPCLEANBUFFERS or DBCC FREEPROCCACHE.

    DROPCLEANBUFFERS serves to empty the data cache. Any data loaded into the buffer cache due to the prior execution is removed.

    FREEPROCCACHE serves to empty the procedure cache. Use this command to return to an un-cached state. There can be a tremendous performance difference between the first and any future times stored procedures are run because of the compilation that must take place before execution.

    Dr. Peter Venkman: Generally you don't see that kind of behavior in a major appliance.

    Patrick

    Quand on parle du loup, on en voit la queue

Viewing 5 posts - 1 through 4 (of 4 total)

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