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?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:
> > 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?
>|||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...
> 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:
>> > 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?
>>|||This is a multi-part message in MIME format.
--000104030503020007090500
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
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
--000104030503020007090500
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Himanshu wrote:
<blockquote cite="mid1ECD2B49-A3C1-4466-A752-56BF9515502A@.microsoft.com"
type="cite">
<pre wrap="">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?
</pre>
</blockquote>
<font size="-1"><font face="Arial">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.<br>
<br>
<br>
-- <br>
Regards<br>
Steen Schlüter Persson<br>
Databaseadministrator / Systemadministrator<br>
</font></font>
</body>
</html>
--000104030503020007090500--|||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/default.asp?url=/library/en-us/dnsqldev/html/sqldev_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.com/jc_system_storage_configuration.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...
> 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 comments:
Post a Comment