Re: Performance Testing: Can I void the cache?

From: Carlos Eduardo Rojas (carloser_at_mindspring.com)
Date: 03/02/04 

Date: Mon, 1 Mar 2004 22:29:34 -0500

You can clear the data cache and the procedure cache using the following
commands:
DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE 

-- 
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"Rob Pecherer" <rmp@sfdbs.com> wrote in message
news:T1T0c.17154$aT1.15121@newsread1.news.pas.earthlink.net...
> I have 3 queries which produce the identical result. I want to see which
one
> runs fastest. Since they all run on the same relations, the 2nd, 3rd,
> (4th,...) benefit from cached disk pages and I don't get a meaningful
> comparison.
>
> Is there a way to void cached pages? What if I toggled (stop/start) the
> service?
>
> Is there a workaround: If I configure Server2K to use a maximum of (say)
> 16M, could I force the cache to void with "SELECT * FROM BigRelation"
where
> BigRelation is more than 16M??
>
> Any suggestions here? I have the Profiler and the System Monitor tools,
but
> the learning curve on these is steep for what I want.
>
> Thank you in advance,
> Rob
>
>

Relevant Pages

  • Re: Fuego, Tomcat, JDBC & SQL Server 2000
    ... > acceptance testing and I ended up with 1.8GB procedure cache (all ... as SQL Server looks to see if it is already in the ... The fact that the data cache is 140 MB and has a high hit ratio, ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Scheduled reboot of SQL Server on Windows 2000
    ... There's no real benefit. ... since it will have to repopulate the data cache. ... SQL Server MVP ... Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.server)
Loading