Hi,

Can anyone share their experiences with Enterprise Server in OLTP environments?

How does ES behave under high loads, heavy use of transactions?

Does ES forward transactions accurately with hardware NLBs?

Thanks already for any feedback.

Regards,

Emre

Emre,



We've been using ES for about 6 months in an OLTP app. We don't have huge numbers, but it has been performing very well. Our primary issue is that 99%+ of our users are access the db via VPN, often over very bad connections. When connecting directly, this meant that the users had to connect via a VPN. Also, as many of the users are contractors, security was a concern. ES provided solutions for both the connection and security issues. Because ES connections can be both encrypted and compressed, it allows for much more efficient connections and is more secure. It also greatly reduced our maintenance costs, as we no longer have to deal with a ton of issues related to users using a VPN.



So, this doesn't really speak to the issue of scalability/high volume, but I thought I'd share some other areas were ES really shines.



Hope this was helpful!



Greg