locked
Cached query result RRS feed

  • Question

  • I want to check the performance of m query and i just want to remove cached query results. Is there any suggestion how can i do this.

    I just want to check after each modificatin how much improvement in performance

     

    Thursday, September 20, 2007 3:29 PM

Answers

  • Check the following dbcc commands in BOL.

     

     

    DBCC FREEPROCCACHE

    DBCC DROPCLEANBUFFERS

     

    DO NOT ATTEMPT THIS ON A PRODUCTION SERVER!!!!!!!!

     

     

    AMB

     

    Thursday, September 20, 2007 3:36 PM