32 vs 64 bit E9

On 25-7-2010 7:09, Paul L Bennett wrote:
> Has anyone gone from 32 to the 64 bit version of E9? What are the advantages of
> such a switch considering that the client is running on 32 bit? Any comments
> would be appreciated?
>

I would assume an E9 Progress installation would benefit more from
64-bit OpenEdge than an installation with a SQL Server backend would.

In a Progress setup, the appservers communicate with the database
through shared
memory. With 32-bit OpenEdge, the amount of shared memory is limited to
about
1 GB. That is because this shared memory, together with "normal" memory
consumption has to fit into 2GB, the max address space for 32-bit programs.

Using 64-bit OpenEdge, there is virtually no limit to how much a single
process
can address, meaning the whole database can be attached as shared memory.

This would allow the appservers, which do the "real" work rather than the
32-bit client, should perform much better.

With a SQL Server backend, the data has to go through a network connection
rather than shared memory, which means there is not as much benefit from
64-bit OpenEdge's addressing capabilities.

Of course a 64-bit SQL Server setup may perform better than a 32-bit one,
but you can use that with 32-bit OpenEdge too, saving you the hassle that
comes with 64-bit OpenEdge (like having to run the admin tools on a
different
server).

Pim
Has anyone gone from 32 to the 64 bit version of E9? What are the advantages of
such a switch considering that the client is running on 32 bit? Any comments
would be appreciated?

Paul....





[Non-text portions of this message have been removed]
We're on 64-bit SQL in 9.04.505c. Presumably, the SQL portion is faster as backups and other SQL-only processes are running at 64-bit even though the .Net Client is connected to a 32-bit OpenEdge AppServer connected via a 32-bit ODBC connection to SQL.

It would be interesting to know the maximum license counts being used under the following permutations.

Database: SQL/Progress
Version: 8.03/9.04/9.05
Servers: 1/2 (splitting AppServers from Database)

We're SQL, 9.04, 1 Server, 32 Office/MES licenses.

We intend to add 80 Office/MES licenses under 9.05 eventually. Anyone using solid-state drives for temporary SQL/OpenEdge files?

----- Original Message -----
From: "Paul L Bennett" <paullbennett@...>
To: "Vantage Group" <vantage@yahoogroups.com>
Sent: Sunday, July 25, 2010 10:09 AM
Subject: [Vantage] 32 vs 64 bit E9


> Has anyone gone from 32 to the 64 bit version of E9? What are the advantages of
> such a switch considering that the client is running on 32 bit? Any comments
> would be appreciated?
>
> Paul

[Non-text portions of this message have been removed]
Hi Paul,

> Has anyone gone from 32 to the 64 bit version of E9? What are the advantages of
> such a switch considering that the client is running on 32 bit? Any comments
> would be appreciated?

The main reason we're switching to 64-bit for our 9.05 upgrade is the
ability to address more memory on the server. Our 9.04 server only has
4GB because of limitation of Win 2K3 Standard Edition. Our new 9.05
server has 22GB of memory and we'll be able to cache the entire 9GB
.d1 file (Progress) into memory with some room to grow. This will
provide better access time to all clients regardless if they're 32 or
64 bit.

Mark W.
When are you doing that? Be interested in hearing about speed and any
problems you ran across.



Randy Duly, BSBIS, MCP, A+

IT Manager

National Tube Form

A Global Tube Form Company

3405 Engle Road

Fort Wayne IN 46809

P: 260-478-2363

F: 260-478-1043

C: 260-402-3216



<blocked::http://www.nationaltubeform.com/>

<http://www.nationaltubeform.com/>




This e-mail transmission and any attachments to it are intended solely for
the use of the individual or entity to whom it is addressed and may contain
confidential and privileged information. If you are not the intended
recipient, your use, forwarding, printing, storing, disseminating,
distribution, or copying of this communication is prohibited. If you
received this communication in error, please notify the sender immediately
by replying to this message and delete it from your computer.





[Non-text portions of this message have been removed]