Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning clearing SQL cache RE: clearing SQL cache

  • April 7, 2010 at 6:32 am

    #1147247

    Dave Ballantyne (4/7/2010)

    Do you mean the procedure cache (DBCC FREEPROCCACHE) or the buffer cache(DBCC DROPCLEANBUFFERS) ?

    Im guessing the former, could potentially be parameter sniffing http://www.sqlpointers.com/2006/11/parameter-sniffing-stored-procedures.html

    I like guessing games 🙂

    My guess is procedure cache bloat due to ad-hoc queries.

    http://blogs.msdn.com/sqlprogrammability/archive/2007/01/23/4-0-useful-queries-on-dmv-s-to-understand-plan-cache-behavior.aspx

    DBCC FREESYSTEMCACHE('SQL Plans');

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi