flushing SQL Server Cache when collecting timings

• chris 50844

  Newbie

  Points: 4

  More actions

  April 12, 2010 at 10:25 am

  #223150

  I've been trying to optimize some queries. If I run the same query twice, the second time it runs in a fraction of the first -- I'm assuming that this is because everything is still in memory. To counter this, I Stop and Start the service before each test.

  Is there a way to flush this in T-SQL so I don't need to constantly stop the service??

  Thanks --- Chris

• Nils Gustav Stråbø

  SSChampion

  Points: 11259

  More actions

  April 12, 2010 at 10:56 am

  #1150190

  DBCC DROPCLEANBUFFERS

  and

  DBCC FREEPROCCACHE

• Steve Jones - SSC Editor

  SSC Guru

  Points: 739482

  More actions

  April 12, 2010 at 11:35 am

  #1150210

  http://msdn.microsoft.com/en-US/library/ms187762%28v=SQL.90%29.aspx

  http://msdn.microsoft.com/en-US/library/ms174283%28v=SQL.90%29.aspx

• chris 50844

  Newbie

  Points: 4

  More actions

  April 12, 2010 at 2:22 pm

  #1150348

  Nils, Steve,

  Thanks. When my searching fails I can always count on someone here to know the answers.