Re: Performance Testing: Can I void the cache?

From: Ray Higdon (sqlhigdon_at_nospam.yahoo.com)
Date: 03/02/04 

Date: Mon, 1 Mar 2004 23:01:27 -0500

In addition to what Carlos said, you can use the command "set statistics IO
on" to see the logical IO (number of times SQL hits a page) - If you run
what Carlos said I believe you can look at the physical as well but I
typically concentrate on the logical.

HTH 

-- 
Ray Higdon MCSE, MCDBA, CCNA
---
"Carlos Eduardo Rojas" <carloser@mindspring.com> wrote in message
news:u4akXaAAEHA.2180@TK2MSFTNGP09.phx.gbl...
> 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: best way to "parameterize" a tablename?
    ... The OP does not want to run SQL entered by a user, ... :> Carlos. ... Personally I don't use sed much, I prefer perl. ... but it does show how a sqlplus script can be self ...
    (comp.databases.oracle.misc)
  • Re: best way to "parameterize" a tablename?
    ... The OP does not want to run SQL entered by a user, ... :> Carlos. ... Personally I don't use sed much, I prefer perl. ... but it does show how a sqlplus script can be self ...
    (comp.databases.oracle.misc)
  • Re: Exposing a MSSQL server to the internet...
    ... Thank you Carlos. ... > 1433 to the sql server machine. ... >> entire network is connected to the internet via cablemodem with a static ...
    (microsoft.public.sqlserver.setup)
  • Re: Reporting a bug
    ... this occurs when using any SQL ... >migrating the OLAP repository to an SQL Server database ... >>Carlos Eduardo Rojas ...
    (microsoft.public.sqlserver.security)
  • Re: Creating a COM object
    ... I'm getting the impression that you are doing all this from the command line ... And don't forget that hosting OCX requires a valid control host, ... > internal class ovbMicrImage: vbMicrImage.vbMTMicrImageClass, ... > Carlos Lozano ...
    (microsoft.public.dotnet.languages.csharp)