Mixing 32-bit and 64-bit in MSSQL Cluster

Hi,
We currently have 2 32-bit machines in an MS Cluster with MSSQL as a
Resource.
And these machines can only hold 6 Gb of memory which is not enough
anymore.
I was wondering if I could add 1 new 64-bit machine in this cluster or
that need to create a new cluster with 2 new 64-bit machines.
Regards,
Sven Peeters
Hi,
You can not mix 32-bit and 64-bit nodes on the same Windows Cluster. So, you
will need to create a new 64-bit Windows Cluster.
Hope this helps,
Ben Nevarez
"Icemokka" wrote:

> Hi,
> We currently have 2 32-bit machines in an MS Cluster with MSSQL as a
> Resource.
> And these machines can only hold 6 Gb of memory which is not enough
> anymore.
> I was wondering if I could add 1 new 64-bit machine in this cluster or
> that need to create a new cluster with 2 new 64-bit machines.
> Regards,
> Sven Peeters
>
|||Hi,
You can not mix 32-bit and 64-bit nodes on the same Windows Cluster. So, you
will need to create a new 64-bit Windows Cluster.
Hope this helps,
Ben Nevarez
"Icemokka" wrote:

> Hi,
> We currently have 2 32-bit machines in an MS Cluster with MSSQL as a
> Resource.
> And these machines can only hold 6 Gb of memory which is not enough
> anymore.
> I was wondering if I could add 1 new 64-bit machine in this cluster or
> that need to create a new cluster with 2 new 64-bit machines.
> Regards,
> Sven Peeters
>
|||On 10 feb, 11:26, Ben Nevarez <bneva...@.no.spam.please.sunamerica.com>
wrote:
> Hi,
> You can not mix 32-bit and 64-bit nodes on the same Windows Cluster. So, you
> will need to create a new 64-bit Windows Cluster.
> Hope this helps,
> Ben Nevarez
>
> "Icemokka" wrote:
>
> - Tekst uit oorspronkelijk bericht weergeven -
Thank you ...

Mixing 32-bit and 64-bit in MSSQL Cluster

Hi,
We currently have 2 32-bit machines in an MS Cluster with MSSQL as a
Resource.
And these machines can only hold 6 Gb of memory which is not enough
anymore.
I was wondering if I could add 1 new 64-bit machine in this cluster or
that need to create a new cluster with 2 new 64-bit machines.
Regards,
Sven PeetersHi,
You can not mix 32-bit and 64-bit nodes on the same Windows Cluster. So, you
will need to create a new 64-bit Windows Cluster.
Hope this helps,
Ben Nevarez
"Icemokka" wrote:
> Hi,
> We currently have 2 32-bit machines in an MS Cluster with MSSQL as a
> Resource.
> And these machines can only hold 6 Gb of memory which is not enough
> anymore.
> I was wondering if I could add 1 new 64-bit machine in this cluster or
> that need to create a new cluster with 2 new 64-bit machines.
> Regards,
> Sven Peeters
>|||Hi,
You can not mix 32-bit and 64-bit nodes on the same Windows Cluster. So, you
will need to create a new 64-bit Windows Cluster.
Hope this helps,
Ben Nevarez
"Icemokka" wrote:
> Hi,
> We currently have 2 32-bit machines in an MS Cluster with MSSQL as a
> Resource.
> And these machines can only hold 6 Gb of memory which is not enough
> anymore.
> I was wondering if I could add 1 new 64-bit machine in this cluster or
> that need to create a new cluster with 2 new 64-bit machines.
> Regards,
> Sven Peeters
>|||On 10 feb, 11:26, Ben Nevarez <bneva...@.no.spam.please.sunamerica.com>
wrote:
> Hi,
> You can not mix 32-bit and 64-bit nodes on the same Windows Cluster. So, you
> will need to create a new 64-bit Windows Cluster.
> Hope this helps,
> Ben Nevarez
>
> "Icemokka" wrote:
> > Hi,
> > We currently have 2 32-bit machines in an MS Cluster with MSSQL as a
> > Resource.
> > And these machines can only hold 6 Gb of memory which is not enough
> > anymore.
> > I was wondering if I could add 1 new 64-bit machine in this cluster or
> > that need to create a new cluster with 2 new 64-bit machines.
> > Regards,
> > Sven Peeters- Tekst uit oorspronkelijk bericht niet weergeven -
> - Tekst uit oorspronkelijk bericht weergeven -
Thank you ...sql

Missing Features In Standard Edition X64?

Hi all

In BOL in the features per version section it states that certain features available in the 32-bit version of Std Edition is not available in the 64-bit version. Eg. Database Mail, Query Editor, Query Designer etc.

I have downloaded the latest BOL (May 2007) and installed it and it still says certain features are not available in X64.

However I configured Database Mail on Std Edition X64 and it works 100%. Had some issues with SQLAgent using it but Service Pack 2 solved the problem.

Query Editor and Designer works even though Microsoft says it isn't available.

Is there any difference in the tools or features available in Std Edition 32-bit or 64-bit?

My other concern is what has Microsoft said is available and isn't?

From my tests I can't see anything missing. We are about to go purchase software and licenses and don't want to make the wrong choice.

Thanks
John

Currently, there are not 64 bit client tools pubically available to use with 64 bit SQL Server.

The 32 bit tools work just fine.

You most likely have installed and are using the 32 bit client tools.

|||

The following page in Books on Line is in error.

http://msdn2.microsoft.com/en-us/library/ms143761.aspx

I have submitted two requests for changes:

1. Remove the standard edition 64 bit column from the management tools section, and update the header of the SE 32 column to include SE 64. This says that tools features are the same in 32 and 64 bit.

2. SQL Mail is available only in 32 bit installations. DB Mail is available in 32 and 64 bit installs, whether they are standard or enterprise.

Thanks for pointing this out. I hope we can spare you further confusion.

jkh

|||

Thanks for getting back to me and clearing up the confusion.

Regards

John