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.

Average aggregation

Hi! experts!

I just want to use the average in our measure group.

Unfortunately, there wasn't average aggreation, except averageOfChildren.

How can I implement the average aggreation?

thanks in advance.

Hi from Brazil,

"averageOfChildren" is same "Average" agregation function.

Note: It run just over SQL Server Enterprise or developer version. Not over Standard Version

Regards!

|||

AverageOfChildren will only average over the time dimension - so a typical approach to average over fact rows is:

Create a measure with "sum" aggregation on the fact table field to be averaged

Create a measure with "count" aggregation and row binding (created by default for a new measure group)

Create a calculated measure like: "average" = "sum" / "count"

Availability of SQL Server 2000

It may be not suitable to ask about SQL 2000 here, but I really want an answer from you experts.
I have my SQL 2000 installed in a Win2000 server, however, the SQL 2000 is not available to my application until I log into a shared folder of the Win2000 or I enable the Guest account of the Win2000.
What is the proper way to let the SQL 2000 available to my application? My SQL 2000 uses SQL Security Mode.
Thanks.If you're using SQL Authentication (also known as mixed mode--it still supports Windows Authentication, too), you can supply a SQL user name and password in your database connection string (or whatever provider you use).

Windows Authentication is by far preferred, because you can use all sorts of Windows domain policies to control access with a lot of flexibility.

-Ryan / Kardax