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

  • April 7, 2010 at 1:31 am

    #1147091

    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


    Clear Sky SQL
    My Blog[/url]