locked
what will happend if we run DBCC FREEPROCACHE in production environment..? RRS feed

  • Question

  •  what will happen if  DBCC FREEPROCACHE  run in production environment..?

    Thanks

    vijay

    Thursday, August 8, 2013 6:09 PM

Answers

  • As the documentation clearly states: 

    "Freeing the plan cache causes, for example, a stored procedure to be recompiled instead of reused from the cache. This can cause a sudden, temporary decrease in query performance."

    • Marked as answer by vijay_1234 Thursday, August 8, 2013 6:21 PM
    Thursday, August 8, 2013 6:18 PM