Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Informix Topics / January 2004

Tip: Looking for answers? Try searching our database.

ER performance

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Julio Cesar - 28 Jan 2004 19:08 GMT
Hi guys,
A few weeks ago I got ER working on two servers between my companies. Since
that, I'm experiencing a lot of performance issues that I'd never passed
through before.
The replication is working pretty fine but the server is completely
overloaded.

I think I've checked out everything, although I couldn't find out what might
be happening. I just notice that cpu vps are getting overloaded according a
"onstat -g glo" output. Also, locks on tables are taking longer than ever to
be released.

What should I check to solve that?

----
By the way, I have DELL Servers with 2 Intel XEON processors, with
Hyperthreading enabled. On Linux, the system recognize 4 processors ('cause
of hyperthreading). With that, should I use 2 or 4 CPU Vps? What's better?
---

PS: I did a test, turning off all the 1500 replicates and the systems got
faster as it they were before.

Thanks in advance,
Julio



sending to informix-list
Madison Pruet - 28 Jan 2004 19:49 GMT
Version???

Configuration???

> Hi guys,
> A few weeks ago I got ER working on two servers between my companies. Since
[quoted text clipped - 28 lines]
>
> sending to informix-list
Richard Kofler - 31 Jan 2004 08:25 GMT
> Hi guys,
> A few weeks ago I got ER working on two servers between my companies. Since
[quoted text clipped - 15 lines]
> of hyperthreading). With that, should I use 2 or 4 CPU Vps? What's better?
> ---

[ ... snip ... ]

please give details.
XEON processors there are *many* different ones.
What is your chipset actually?

Post Kernel version, GLICB version and INFORMIX version.

Generally speaking, I would test 1 CPUVP & single CPUVP setup
versus 8 CPUVPs, if your XEONs are >2Ghz and have the larger
L1 caches and if your memory is using >4 chips DDR

If either your Southbridge, or memory, or L2 chache, or
proc speed is not well integrated, then you will see
that the single CPUVP setup is faster

I never had a situation where a 2 CPUVP setup was
anything else that slow.

YMMV

dic_k
Signature

Richard Kofler
SOLID STATE EDV
Dienstleistungen GmbH
Vienna/Austria/Europe

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.