Tuesday, 14 February 2012

Configuring memory for SQL 2000

I'm planning to install SQL Server 2000 Enterprise Edition on Windows Server
2003 Standard Edition machine with 8Gb of memory.
How do I force SQL server to use at least 6Gb out of 8Gb?
Thank you in advance!
LeonThis is a multi-part message in MIME format.
--010707060304040203090309
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Do you mean "at least 6GB" or "up to 6GB"? Either way you'll need the
/pae switch in boot.ini. This allows the OS to see more than 4GB of
physical memory. Then turn on AWE memory and set the min & max memory
settings in SQL Server as appropriate with the sp_configure proc.
For between 6GB and 7GB:
exec sp_configure 'awe enabled', 1
exec sp_configure 'min server memory', 6144
exec sp_configure 'max server memory', 7168
-- then stop & restart the server (needed for the awe enabled option)
For anything up to 6GB:
exec sp_configure 'awe enabled', 1
exec sp_configure 'max server memory', 6144
-- then stop & restart the server (needed for the awe enabled option)
Hope this helps.
--
*mike hodgson*
http://sqlnerd.blogspot.com
Leon Shargorodsky wrote:
>I'm planning to install SQL Server 2000 Enterprise Edition on Windows Server
>2003 Standard Edition machine with 8Gb of memory.
>How do I force SQL server to use at least 6Gb out of 8Gb?
>Thank you in advance!
>Leon
>
--010707060304040203090309
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">
<tt>Do you mean "at least 6GB" or "up to 6GB"? Either way you'll need
the /pae switch in boot.ini. This allows the OS to see more than 4GB
of physical memory. Then turn on AWE memory and set the min & max
memory settings in SQL Server as appropriate with the sp_configure proc.<br>
<br>
For between 6GB and 7GB:<br>
   exec sp_configure 'awe enabled', 1<br>
   exec sp_configure 'min server memory', 6144<br>
</tt><tt>Â Â Â exec sp_configure 'max server memory', 7168<br>
   -- then stop & restart the server (needed for the awe enabled
option)<br>
<br>
For anything up to 6GB:<br>
   exec sp_configure 'awe enabled', 1<br>
   exec sp_configure 'max server memory', 6144<br>
</tt><tt>Â Â Â -- then stop & restart the server (needed for the awe
enabled option)<br>
<br>
Hope this helps.</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2"><a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
Leon Shargorodsky wrote:
<blockquote cite="midAD5292DB-518D-4927-A01D-ABCF84E22115@.microsoft.com"
type="cite">
<pre wrap="">I'm planning to install SQL Server 2000 Enterprise Edition on Windows Server
2003 Standard Edition machine with 8Gb of memory.
How do I force SQL server to use at least 6Gb out of 8Gb?
Thank you in advance!
Leon
</pre>
</blockquote>
</body>
</html>
--010707060304040203090309--

No comments:

Post a Comment