Re: SQL Server 2000 SP4: Memory leak or normal performance?
- From: "Russell Fields" <russellfields@xxxxxxxxxx>
- Date: Mon, 28 Apr 2008 13:23:36 -0400
The Chicago Wolf,
SQL Server will use any available memory that it can to optimize its own
performance, so 65 MB is just what it needs when it first gets started. SQL
Server makes heavy use of memory caches, so that is why additional memory is
being used taking you up to 1.7GB. Any data or procedures cached in memory
already reduce I/Os , which usually improves performance.
However, if there is pressure for memory from other applications, SQL Server
can automatically start giving up some of that memory to the other
applications. You can also set the SQL Server to use a MAX amount of memory
if that is necessary. This is most commonly done if a machine is running
more than one instance of SQL Server or there are other major processes
which need to have memory saved for them.
So, in general, everything is just fine. You have to decide if it is
causing you any real problems and what to do about that. For most users,
letting SQL Server dynamically manage memory is the best choice.
RLF
"Thee Chicago Wolf" <.@.> wrote in message
news:lisb14hpojp2ron0ihr8deenbl0m6jpj1n@xxxxxxxxxx
Hey all, first posting here. Did some checking around on Google for
this issue before asking here but so far am coming up with no clear
idea.
Have W2K3 Server SP2 (4GB RAM) with SQL Server 2000 SP4 and am
noticing sqlserver.exe gobbling up 1.7GB+ RAM. Two days ago I rebooted
the server for general updates and sqlserver.exe was only using 65MB.
Two days later, 1.7GB+!? Does that seem even remotely right? In doing
more research I came upon KB916287 but have yet to apply it. No
mention of it fixing any memory leaks either. I can't find anything
that elaborates on the included fixes other than what's individually
mentioned in KB894905. Anyone experience the same stuff I am? Any tips
would be great.
- Thee Chicago Wolf
- Thee Chicago Wolf
.
- Prev by Date: Re: What is the server name for a standalone XP SP2?
- Next by Date: Re: What is the server name for a standalone XP SP2?
- Previous by thread: Want to know more about MSSQL security issues?
- Next by thread: Re: SQL Server 2000 SP4: Memory leak or normal performance?
- Index(es):
Relevant Pages
|
