Please advise cluster configuration

We have datawarehouse servwer with Active/Active cluster.
One node has 8GB Ram and another node has 12GB.
Right now I have configured for both the nodes the Max.Sql Server Memory to
be 8GB.
Both the nodes are running with windows 2003 SP1and SQL Server 2000 SP4 with
the 8 CPU.
Please advise the best configuration for this.
Thanks.
Best practice is that you keep the Hardware configuration of all your
cluster nodes the same.
Assuming that you already have the /PAE switch in your boot.ini file, I
would recommend that you add 4GB ram to the node with only 8GB ram.
"DKRReddy" <dkrreddy@.hotmail.com> wrote in message
news:%23UPSxwbNHHA.4152@.TK2MSFTNGP06.phx.gbl...
> We have datawarehouse servwer with Active/Active cluster.
> One node has 8GB Ram and another node has 12GB.
> Right now I have configured for both the nodes the Max.Sql Server Memory
to
> be 8GB.
> Both the nodes are running with windows 2003 SP1and SQL Server 2000 SP4
with
> the 8 CPU.
> Please advise the best configuration for this.
> Thanks.
>
|||Here, here to Edwin's recommendations.
Moreover, you did not say if this installation was x86 or IA-64.
If the former, you will need to set AWE enabled for the BPool to be able to
address more than 4 GB and you will want to limit each node to only 1/2 (or
slightly less) than available memory.
If the latter, and you are not running with Lock Pages in Memory, then you
could specify the full memory amount on each node, but you might want to
also specify a minimum memory amount as well. The Itanium build is more
aggressive about acquiring the minimum memory setting and will cause the
other instance to give up excess memory more readily.
The reason is that in a multi-instanced configuration, there will be times
when you will need or have to have multiple instances running on a single
node, and you will need available resources for each.
Sincerely,
Anthony Thomas

"Edwin vMierlo" <EdwinvMierlo@.discussions.microsoft.com> wrote in message
news:eyyfUfiNHHA.4720@.TK2MSFTNGP03.phx.gbl...
> Best practice is that you keep the Hardware configuration of all your
> cluster nodes the same.
> Assuming that you already have the /PAE switch in your boot.ini file, I
> would recommend that you add 4GB ram to the node with only 8GB ram.
>
> "DKRReddy" <dkrreddy@.hotmail.com> wrote in message
> news:%23UPSxwbNHHA.4152@.TK2MSFTNGP06.phx.gbl...
> to
> with
>
sql

Pivot transform not putting all values on same row

I have a pivot transform that it believe is configured correctly but is not distributing the values accross the columns on the same row. for example.

input:

id seqno codevalue

1 A red

1 B red

2 C blue

2 A green

2 B violet

3 A green

desired output:

id Seq_A Seq_B Seq_C

1 red red null

2 green violet blue

3 green null null

what I am getting:

id Seq_A Seq_B Seq_C

1 red null null

1 null red null

2 green null null

2 null violet null

2 null null blue

3 green null null

I do have the pivot usage for the id column set to 1. I have the pivot usage for seqno column set to 2 and codevalue column set to 3. I have the source column for each of the output columns set to the lineageID of the apprpriate input columns. I have the pivotKey values set for each of the destination columns. A for column Seq_A, B for column Seq_B, C for column Seq_C. All four columns have sortkey positions set; 1 for id, 2 for Seq_A, 3 for Seq_B and 4 for column SEQ_C.

It seems like the id column's pivot usage is not set to 1 like it should but when I check it is 1.

I also have several other pivot transforms in the same data flow and they are working as expected.

I have a suspicion that there is some hidden meta data that is messed up that is over-ridding my settings (just my guess) I have deleted this transform and re-done it several times, checking each configuration value, but still getting the same result.

Need some help or thoughts on making this work.

Thanks

Do you need to trim seqno before using it in a pivot? Might there be trailing white spaces or anything?|||

The input source has the column trimmed to char(1); I have done a dataviewer on the input and the output, and the input looks good. I have also recently (yesterday) installed SP2.

In my package, the pivot transform is after a union all transform. However, I have checked the output of the union all with a data viewer and the data input to the pivot transform looks good.

Earlier in my development of this dataflow, I did have some problems with the data source for this pivot transform, but I fixed it. And then checked the output of the pivot and found that it was not right. That is when I deleted the pivot transform and re-created it. But I still had the problem. I have since re-checked every configuration value in the pivot transform and the upstream and downstream transforms. All look to be configured correctly, but still the Pivot is putting each value on it's own row and not across the same row, for a given id.