Re: SQL active - active cluster hardware design?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I think you have just proved my point: no one could answer this particular
installation question without a better understanding of the usage
requirements.

As far as 32 versus 64 bit computing, and IA64 versus x64, show me any
documented studies that proves your claim. Here's mine: take a look at any
of the TPM-C benchmarks and rank the systems by both metrics and tell me
which ones outperform.

What specifically did you have in mind? What kind of workload did you think
would perform better on 32-bit or x64 over IA64?


Anthony Thomas


--

"Linchi Shea" <LinchiShea@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:081C88DD-8A9E-485D-9746-5F93BB565597@xxxxxxxxxxxxxxxx
Is 64-bit better than 32-bit? Yes.
Not necessarily. It depends on the workload.

Is Itanium better than x64? Yes.
Not necessarily. It highly depends on the system design. We have found
cases
where an x64 box easily beats an Itanium box on the same workload.

Linchi

"Anthony Thomas" wrote:

You will need to know how you plan on using it: OLTP, DSS, Data
Warehouse,
Data Marts, OLAP?

You will need to know number of Transactions/Batch Requests per second.

You will need to know number of users and databases. What are the
database
sizes?

Is more memory better? Yes.

Is more, larger processors? Yes.

Is 64-bit better than 32-bit? Yes. Is Itanium better than x64? Yes.

However, what you need to build is what you need to process plus some
room
for future growth over the next 2 to 5 years; otherwise, you may end up
under-powering, or over-paying for the system.

Sincerely,


Anthony Thomas


--

"gili98" <gili98@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5ACB71E4-EFDF-4C03-BE17-E2D96964A467@xxxxxxxxxxxxxxxx
I want to make a two node active-active ms cluster. how to design die
two
server hardware (RAM, processor). we use IBM xseries server.
is it good to use 64bit?

mfg





.