Re: Clear SQL Server Cache?
From: Peter Yeoh (nospam_at_nospam.com)
Date: 09/09/04
- Next message: mk: "Extract by date"
- Previous message: Tibor Karaszi: "Re: indexdefrag all indexes on all tables in a table"
- In reply to: Anith Sen: "Re: Clear SQL Server Cache?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 9 Sep 2004 16:06:25 +0800
That is not what the user wants. Those commands will clear clear the
respective caches, but SQL Server still holds on to the memory. The only
way SQL Server is going to release memory is if another process requests
more memory from the OS.
-- Peter Yeoh http://www.yohz.com Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free! "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 > >
- Next message: mk: "Extract by date"
- Previous message: Tibor Karaszi: "Re: indexdefrag all indexes on all tables in a table"
- In reply to: Anith Sen: "Re: Clear SQL Server Cache?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
