Prev: buffer latch 2 timeout error when connectiong to db from mgmt stud
Next: SQL Questions
From: Andrew J. Kelly on 24 Jun 2010 16:59
Is this an multi-instance cluster or single instance? If it is
multi-instance you also need to worry about when 2 instances are on the same
node. If you use AWE to get above 2GB the memory will be fixed and both
instances cannot have MAX memory set to 14GB and expect them both to work
properly.

--

Andrew J. Kelly SQL MVP
Solid Quality Mentors

"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
>
First  |  Prev  | 
Pages: 1 2
Prev: buffer latch 2 timeout error when connectiong to db from mgmt stud
Next: SQL Questions