Memory usage

We have about 40 SQL Servers in our environment, and none of them use 2 GB o
f
RAM - in fact they all use between 1.6 and 1.7 GB.
Our configuration option is set to dynamically use memory - and our
databases are as large as 100GB.
Any ideas?How much physical RAM is in the machines?
Himanshu wrote:
> We have about 40 SQL Servers in our environment, and none of them use 2 GB
of
> RAM - in fact they all use between 1.6 and 1.7 GB.
> Our configuration option is set to dynamically use memory - and our
> databases are as large as 100GB.
> Any ideas?|||All our machines have either 3GB or 4GB of physical RAM
"davconts@.gmail.com" wrote:

> How much physical RAM is in the machines?
>
> Himanshu wrote:
>|||How are you measuring the memory allocation?
And have you used the /3gb start up parameter on the boxes with 4GB?
What you are reading is about right for the 3GB boxes -2Gb for SQL, 1GB for
the OS. The /3GB option will give SQL Server 3GB on the boxes with 4GB
memory.
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."
"Himanshu" <Himanshu@.discussions.microsoft.com> wrote in message
news:BC386A30-D58F-4D9B-923F-29EBD5884477@.microsoft.com...[vbcol=seagreen]
> All our machines have either 3GB or 4GB of physical RAM
> "davconts@.gmail.com" wrote:
>|||Himanshu wrote:
> We have about 40 SQL Servers in our environment, and none of them use 2 GB
of
> RAM - in fact they all use between 1.6 and 1.7 GB.
> Our configuration option is set to dynamically use memory - and our
> databases are as large as 100GB.
> Any ideas?
>
What version of SQL server and Windows are you running? Standard SQL
server 2000 is limited to 2GB and in real life it's normally using max
~1,8 GB.
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator|||SQL Server will always reserve up to 384MB of memory at start up for the
MemToLeave portion of memory. So if you are using Task Manager to view
memory usage it looks like SQL Server only uses about 1.7GB and this is
normal.
http://msdn.microsoft.com/library/d...ev_01262004.asp
--
Andrew J. Kelly SQL MVP
"Himanshu" <Himanshu@.discussions.microsoft.com> wrote in message
news:1ECD2B49-A3C1-4466-A752-56BF9515502A@.microsoft.com...
> We have about 40 SQL Servers in our environment, and none of them use 2 GB
> of
> RAM - in fact they all use between 1.6 and 1.7 GB.
> Our configuration option is set to dynamically use memory - and our
> databases are as large as 100GB.
> Any ideas?|||Thank you all for your responses. We have SQL 2000 Standard running on
Windows 2000 Server.
It is possible configure SQL 2000 Standard to use 3 GB?
"Himanshu" wrote:

> We have about 40 SQL Servers in our environment, and none of them use 2 GB
of
> RAM - in fact they all use between 1.6 and 1.7 GB.
> Our configuration option is set to dynamically use memory - and our
> databases are as large as 100GB.
> Any ideas?|||No, that configuration is limited to 2 GB.
See:
http://www.sql-server-performance.c...nfiguration.asp
--
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."
"Himanshu" <Himanshu@.discussions.microsoft.com> wrote in message
news:A7CCDE8F-1B2E-4C7A-867A-86891BF39F6C@.microsoft.com...[vbcol=seagreen]
> Thank you all for your responses. We have SQL 2000 Standard running on
> Windows 2000 Server.
> It is possible configure SQL 2000 Standard to use 3 GB?
>
> "Himanshu" wrote:
>