Post reply

CacheRemove

  • April 15, 2008 at 4:46 am

    #189145

    One of my stored procedure takes long time to execute. When I monitor the events in SQL Profiler, I noticed sp:CacheRemove event takes long time to process. Is it recommended to clear the cache manually? If yes, how can I do it?

    - Zahran -

  • April 15, 2008 at 4:55 am

    #802441

    Look up DBCC FREEPROCCACHE, DBCC DROPCLEANBUFFERS and sp_recompile in Books Online. I recommend that you read all the related ("See Also") topics as well. Please post again if there's anything there you don't understand, and we'll try to help out.

    John

  • April 16, 2008 at 8:36 am

    #803125

    Check your database in which your stored procedure was running, set the auto_close option to false.

    Good Luck!

    Sri.

Viewing 3 posts - 1 through 2 (of 2 total)

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