Prev: buffer latch 2 timeout error when connectiong to db from mgmt stud
Next: SQL Questions
From: cw on 21 Jun 2010 18:25
We have a client with a SQL2000 EE sp3 on Win2003 EE as a 2 node cluster.
The the nodes are 16 CPUs each with 18GBs memory. The boot.ini has the /PAE
switch (no /3GB) and the SQL server does not have the AWE setting turned on.
Will the SQL server use more than 2GB memory with the AWE set to 0 and MAX
memory set to ~14GBs?

Thanks


From: Uri Dimant on 22 Jun 2010 01:01
cw
You set MAX memory to 14GB?

"cw" <cw(a)3mc.com> wrote in message
news:eKVeoCZELHA.728(a)TK2MSFTNGP04.phx.gbl...
> We have a client with a SQL2000 EE sp3 on Win2003 EE as a 2 node cluster.
> The the nodes are 16 CPUs each with 18GBs memory. The boot.ini has the
> /PAE switch (no /3GB) and the SQL server does not have the AWE setting
> turned on. Will the SQL server use more than 2GB memory with the AWE set
> to 0 and MAX memory set to ~14GBs?
>
> Thanks
>


From: cw on 22 Jun 2010 11:33
This is an inherirted system from long ago, but still up & running.
Under the SQL Server Properties memory tab, the Maximum MB is set to 14336
MBs ( ~14 GBs).

The Task Mgr is showing 1,761,624 K Memory usage for the SQL server service.
From a Perfmon, the Target Server Memory (KB) counter is showing an Avg
~1,675,900 KBs and the Total Server Memory (KB) counter is showing an avg
~1,676, 062 KBs.

I'm trying to find out if the AWE is required for a SQL2000 server so it can
use more memory than it is.

-- Thanks

"Uri Dimant" <urid(a)iscar.co.il> wrote in message
news:uDe0ufcELHA.5736(a)TK2MSFTNGP02.phx.gbl...
> cw
> You set MAX memory to 14GB?
>
> "cw" <cw(a)3mc.com> wrote in message
> news:eKVeoCZELHA.728(a)TK2MSFTNGP04.phx.gbl...
>> We have a client with a SQL2000 EE sp3 on Win2003 EE as a 2 node cluster.
>> The the nodes are 16 CPUs each with 18GBs memory. The boot.ini has the
>> /PAE switch (no /3GB) and the SQL server does not have the AWE setting
>> turned on. Will the SQL server use more than 2GB memory with the AWE set
>> to 0 and MAX memory set to ~14GBs?
>>
>> Thanks
>>
>
>


From: Erland Sommarskog on 22 Jun 2010 14:30
cw (cw(a)3mc.com) writes:
> This is an inherirted system from long ago, but still up & running.
> Under the SQL Server Properties memory tab, the Maximum MB is set to 14336
> MBs ( ~14 GBs).
>
> The Task Mgr is showing 1,761,624 K Memory usage for the SQL server
> service.
> From a Perfmon, the Target Server Memory (KB) counter is showing an Avg
> ~1,675,900 KBs and the Total Server Memory (KB) counter is showing an avg
> ~1,676, 062 KBs.
>
> I'm trying to find out if the AWE is required for a SQL2000 server so it
> can use more memory than it is.

Yes, you need to enable AWE to be able to use that memory. (You also need
/PAE, but I see that you already have that.)

I think you need to restart SQL Server after the change, but I'm not sure.

What I do know, though, is that in Task Manager SQL Server will appear to
have less memory than before, because the memory allocated through AWE is
not visible in Task Manager, except in Page File Usage.




--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

From: Wojciech Garwol Wojciech on 22 Jun 2010 15:57
"Erland Sommarskog" wrote:

> I think you need to restart SQL Server after the change, but I'm not sure.

The restart is needed.

Regards, Wojciech Garwol
 |  Next  |  Last
Pages: 1 2
Prev: buffer latch 2 timeout error when connectiong to db from mgmt stud
Next: SQL Questions