Re: Clear SQL Server Cache?

From: JT Lovell (jt_lovell_at_yahoo.com)
Date: 09/08/04 

Date: Wed, 8 Sep 2004 10:26:35 -0400

Thanks Anith, I checked these out. Are there other caches as well, or is
proc/query caching the only thing? SQL server was using another 1GB of
memory so I'm thinking it had to be storing other things as well. 

-- 
JT Lovell
"Anith Sen" <anith@bizdatasolutions.com> wrote in message
news:%23RqVRjalEHA.536@TK2MSFTNGP11.phx.gbl...
> Look up DBCC FREEPROCCACHE & DBCC DROPCLEANBUFFERS in SQL Server Books
> Online.
>
> -- 
> Anith
>
>

Relevant Pages

  • Re: Index Creation Date
    ... Anith, ... >Join sysindexes and sysobjects and use the crdate in the ... Read details on SQL Server Books Online. ...
    (microsoft.public.sqlserver.security)
  • Re: create list of string matches for "LIKE" criteria
    ... Thanks Anith. ... I guess I felt that as SQL Server allow an alias or an expression, ... > aliases, ...
    (microsoft.public.sqlserver.programming)
  • Re: query for identity columns
    ... Need SQL Server Examples check out my website at ... "Hassan" wrote in message ... > Neat Anith.. ... > How can i take it to the next step and run the same for every database. ...
    (microsoft.public.sqlserver.programming)
  • Re: Column...
    ... SQL Server could "scan" the column to look for the max value... ... > existing values in the column matches the proposed identity seed and/or ... > increment. ...
    (microsoft.public.sqlserver.programming)
  • Re: Clear SQL Server Cache?
    ... respective caches, but SQL Server still holds on to the memory. ... > Look up DBCC FREEPROCCACHE & DBCC DROPCLEANBUFFERS in SQL Server Books ...
    (microsoft.public.sqlserver.programming)