Re: SQL active - active cluster hardware design?

Take a look at
http://sqlblog.com/blogs/linchi_shea/archive/2007/01/02/32-bit-vs-x64.aspx

:-)

Linchi

"gili98" wrote:

more facts:

- 8 databases on the two servers
- every database about 5 GB
- 350 user per database

mfg

"Linchi Shea" wrote:

As far as 32 versus 64 bit computing, and IA64 versus x64, show me any
documented studies that proves your claim.

I don't know whether you can find any public documented studies as such. But
I have done many tests myself and found that to be the case. Basically, I
have seen the results all over the map with different workloads (e.g.
cpu-bound, memory-bound, I/O-bound, etc) when I systematically compared
different platforms. I simply stated the facts as I saw them. Unfornately, I
can't disclose all the test details in a public forum like this.

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.

Note that I didn't say 32-bit is always better than 64-bit or x64 is always
better than Itanium. My replies were 'not necessarily' in both cases. So even
if you can find TPC-C benchmarks to be better on Itanium, that doesn't
contradict what I said.

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

For x64 vs IA-64, as I said it depends a lot on how the system vendors make
their systems with these processors (e.g. how they design the system
architecture including the interconnect among processors and memory modules).
At the highest end, you may find IA-64 machines to be more powerful. But for
the majority of business applications, x64 servers may be sufficient. And if
we are talking about comparing servers at the same pricing level, I have
recently done the same tests on a cheap DL585 and a much more expensive
Itanium server with better memory configuration, and for these particular
test workloads (which inlcude a lot of BLOB manipulations), the 8-way
commodity DL585 beat that 8-way non-commodity Itanium box hands down.

Again, I stated only what I have had experience with. I did not, and would
not want to, say that x64 is always better than IA-64. It would be too
dangerous to make generalized statement like that.

Linchi

"Anthony Thomas" wrote:

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






.

Relevant Pages

  • Re: SQL active - active cluster hardware design?
    ... if you can find TPC-C benchmarks to be better on Itanium, ... For x64 vs IA-64, as I said it depends a lot on how the system vendors make ... x64 servers may be sufficient. ... You will need to know number of users and databases. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SAN (NetApp SnapMirror) replicated Exchange databases usability
    ... to stage Exchange 2007 servers at siteB with SG's and databases that are ... This is achieved by having Exchange ...
    (microsoft.public.exchange.design)
  • Re: Best way to updat TNSNames.ora in all servers
    ... We have many unix servers running Oracle ... that be the case then I would still work to consolidate the databases ...
    (comp.databases.oracle.server)
  • Re: Why does SQLBrowseInfo call take so long?
    ... I did a similar technique to resolve DNS ... So what I did was start one thread per resolution, ... have 20 servers, this means that it will take 100 seconds to resolve, but if you do them ... if there is some other approach to listing all available databases ...
    (microsoft.public.vc.mfc)
  • Re: Developer design Best Practices
    ... multiple smaller databases that were created adhoc on those servers for the ... SQL on these machines and than installed their application and pointed it ... production machines. ... Many of the objects in these databases are owned by not ...
    (microsoft.public.sqlserver.server)
Loading