Fixed Memory = 3Gb sqlserver.exe uses 1.7Gb

Hello
We are trying to enhance the performance of our server. We recently noticed
that despite having 4Gb of RAM in the server, sqlserver.exe was only using
1.7Gb. There are 4 databases on the server, one of which is at 9Gb and in
constant use (by around 50 people).
We had thought that perhaps there was a problem with the dynamic memory
allocation so switched to fixed at 3Gb. Having restarted, the sqlserver.exe
process is still only using 1.7Gb of RAM (and still running at 100% CPU).
Surely when allocating memory in this way it should show sqlserver.exe with
the total amount of RAM. (Looking in task monitor to get the usage figure.)
Any ideas?
Thanks
DavidDavid Morgan wrote:
> Hello
> We are trying to enhance the performance of our server. We recently notic
ed
> that despite having 4Gb of RAM in the server, sqlserver.exe was only using
> 1.7Gb. There are 4 databases on the server, one of which is at 9Gb and in
> constant use (by around 50 people).
> We had thought that perhaps there was a problem with the dynamic memory
> allocation so switched to fixed at 3Gb. Having restarted, the sqlserver.e
xe
> process is still only using 1.7Gb of RAM (and still running at 100% CPU).
> Surely when allocating memory in this way it should show sqlserver.exe wit
h
> the total amount of RAM. (Looking in task monitor to get the usage figure
.)
> Any ideas?
> Thanks
> David
>
Which version of SQL? 2000 Standard will only use 2GB of RAM...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||1.7 GB indicates SQL Server uses 2GB (considering the memtoleave area - Goog
le for more info). What
version and edition of SQL Server and the OS?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"David Morgan" <microsoft_newsgroups.nospam@.davidmorgan.me.uk> wrote in mess
age
news:eacc4dLvGHA.1224@.TK2MSFTNGP03.phx.gbl...
> Hello
> We are trying to enhance the performance of our server. We recently notic
ed that despite having
> 4Gb of RAM in the server, sqlserver.exe was only using 1.7Gb. There are 4
databases on the
> server, one of which is at 9Gb and in constant use (by around 50 people).
> We had thought that perhaps there was a problem with the dynamic memory al
location so switched to
> fixed at 3Gb. Having restarted, the sqlserver.exe process is still only u
sing 1.7Gb of RAM (and
> still running at 100% CPU). Surely when allocating memory in this way it
should show
> sqlserver.exe with the total amount of RAM. (Looking in task monitor to g
et the usage figure.)
> Any ideas?
> Thanks
> David
>|||Thank you to both above. You are quite correct.
SQL Server 8.00.760 - SP3 (Standard Edition)
Bummer. Guess the 2005 upgrade is coming sooner than I thought.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23XKgriLvGHA.2232@.TK2MSFTNGP05.phx.gbl...
> 1.7 GB indicates SQL Server uses 2GB (considering the memtoleave area -
> Google for more info). What version and edition of SQL Server and the OS?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "David Morgan" <microsoft_newsgroups.nospam@.davidmorgan.me.uk> wrote in
> message news:eacc4dLvGHA.1224@.TK2MSFTNGP03.phx.gbl...
>