Re: sqlservr.exe taking huge memory usage

Tech-Archive recommends: Fix windows errors by optimizing your registry



Yes this is normal. Actually SQL Server is using even more memory than that
but Task manager is not a good tool to report on this. SQL Server will use
all the available memory it has if it thinks it can use it and it will not
give it back unless the OS specifically asks for it.

--
Andrew J. Kelly SQL MVP


"msnews.microsoft.com" <tal_baror@xxxxxxxxxxx> wrote in message
news:uuDa75s5FHA.2628@xxxxxxxxxxxxxxxxxxxxxxx
> Hello Group,
>
> I have SQL ENT SP4 installed on cluster with two nodes each node have 2GB
> memory serving 17 clients.
> when i am looking on task manager the proccess sqlservr.exe is getting
> bigger and bigger until he attained 1.7+- and stay stable.
> Is it normal that this proccess getting so big?
> thanks
>
>
>
>


.



Relevant Pages

  • Re: FTS Performance in SQL 2005
    ... we had no end of problems with SQL FTS. ... Looking for a SQL Server replication book? ... The Memory Usage and VM Size never increase over about 65 MB and 20MB. ... cost relative to the whole batch, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: FTS Performance in SQL 2005
    ... we had no end of problems with SQL FTS. ... Looking for a SQL Server replication book? ... The Memory Usage and VM Size never increase over about 65 MB and 20MB. ... cost relative to the whole batch, ...
    (microsoft.public.sqlserver.fulltext)
  • RE: Consolidating instances of SQL server
    ... SQL Server is designed to use memory. ... The maximum amount of memory SQL Server can use varies depending on your ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: The DBMS returned an unspecified error.
    ... | We are using Microsoft's JDBC driver for Java database access to SQL ... | Insufficient memory available. ... even though SQL Server 2000 is configured to use up to the ... the problem is most likely in the MemToLeave ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: SQL Server 2000 Cluster--Memory
    ... Task Manager doesn't handle AWE/PAE addressing, ... Tibor Karaszi, SQL Server MVP ... >> You can't use dynamic memory allocation when you set AWE, ... >> Perfmon to monitor memory for SQL Server and not task manager. ...
    (microsoft.public.sqlserver.server)