AWE on Clustering

Thank you for Geoff N. Hiten provides me very useful info.
Please experts confirm with the following.
Please take alook at the follwing list and tell me whether it looks good to
you.
SQL Server 2000 (SP4)+ Windows 2003 Clustering. Two nodes , on each node
there is ONE SQL instance.
a) SQL node1 --(Active) has 8GB
b) SQL node1 --(Passive) has 8GB
c) Boot.Ini has \3GB\PAE on both servers of cluster
1) Install hotfix from(http://support.microsoft.com/kb/899761) on SQL1 node
(Active)
2) Install hotfix from(http://support.microsoft.com/kb/899761) on SQL2 node
(Passive)
3) Grant 'lock pages in memory' on on SQL1 node (Active)
4) Grant 'lock pages in memory' on on SQL1 node (Passive)
5) Enabling AWE on SQL1 node (Active)--set to 6GB
6) Enabling AWE on SQL1 node (Passive)--set to 6GB
Thanks you again
Hotfixes are installed to an instance, not a node. You start the install
fromthe console that owns the instance, but the binaries are loaded on all
nodes. Otherwise, the pln looks good.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Alex" <test@.hotmail.com> wrote in message
news:OqToVtTlHHA.4628@.TK2MSFTNGP06.phx.gbl...
> Thank you for Geoff N. Hiten provides me very useful info.
> Please experts confirm with the following.
> Please take alook at the follwing list and tell me whether it looks good
> to you.
> SQL Server 2000 (SP4)+ Windows 2003 Clustering. Two nodes , on each node
> there is ONE SQL instance.
> a) SQL node1 --(Active) has 8GB
> b) SQL node1 --(Passive) has 8GB
> c) Boot.Ini has \3GB\PAE on both servers of cluster
>
> 1) Install hotfix from(http://support.microsoft.com/kb/899761) on SQL1
> node
> (Active)
> 2) Install hotfix from(http://support.microsoft.com/kb/899761) on SQL2
> node
> (Passive)
> 3) Grant 'lock pages in memory' on on SQL1 node (Active)
> 4) Grant 'lock pages in memory' on on SQL1 node (Passive)
> 5) Enabling AWE on SQL1 node (Active)--set to 6GB
> 6) Enabling AWE on SQL1 node (Passive)--set to 6GB
> Thanks you again
>
|||Thank you sir.
> Hotfixes are installed to an instance, not a node.
Yes , I meant on node that hostes an instance. Sure on instance.
1) Install hotfix from(http://support.microsoft.com/kb/899761) on Instance
of SQL1 node
(Active)
2) Install hotfix from(http://support.microsoft.com/kb/899761) on Instance
SQL2 node
Being a little bit confused, should i install a hotfix on Passive also?
Thank you again
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23vz$JEclHHA.3496@.TK2MSFTNGP03.phx.gbl...
> Hotfixes are installed to an instance, not a node. You start the install
> fromthe console that owns the instance, but the binaries are loaded on all
> nodes. Otherwise, the pln looks good.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Alex" <test@.hotmail.com> wrote in message
> news:OqToVtTlHHA.4628@.TK2MSFTNGP06.phx.gbl...
>
|||And ofcause I meant
3) Grant 'lock pages in memory' on on SQL1 node (Active)
4) Grant 'lock pages in memory' on on SQL2 node (Passive)
5) Enabling AWE on SQL1 node (Active)--set to 6GB
6) Enabling AWE on SQL2 node (Passive)--set to 6GB
Changed from SQL1 node to SQL2 node
"Alex" <test@.hotmail.com> wrote in message
news:%23vDPQSelHHA.1340@.TK2MSFTNGP04.phx.gbl...
> Thank you sir.
> Yes , I meant on node that hostes an instance. Sure on instance.
> 1) Install hotfix from(http://support.microsoft.com/kb/899761) on Instance
> of SQL1 node
> (Active)
> 2) Install hotfix from(http://support.microsoft.com/kb/899761) on Instance
> SQL2 node
> Being a little bit confused, should i install a hotfix on Passive also?
> Thank you again
>
>
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:%23vz$JEclHHA.3496@.TK2MSFTNGP03.phx.gbl...
>
|||A clarification Awe is "managed" by SQL Server so if you set up the fixed
memory from EM to 6 gb it will be the same on both nodes, there's no need or
way to put on each node.
Regards.