Performance improvment steps
User reports performance degradation after separating application and database servers (Genero 2.21.01 on app server, Informix 11.50.FC3 on DB server with 3000 clients). Responders suggest: rebuilding database statistics, checking server load and network speed, considering upgrade to 11.70, and note that TCP communication is inherently ~20% slower than SHM used on single-server setups. No definitive resolution provided.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi to ALL,
The performance is degraded when I split my application server from my
database server.
On the application server we have Genero Server v2.21.01 with Genero (4js)
programs.
And the database server is: IBM Informix Dynamic Server Version 11.50.FC3
For information in the onconfig we set
NETTYPE ipcshm,1,700,CPU
NETTYPE soctcp,16,500,NET
Since we have around 3000 clients connected on the application server.
Is it possible to have the same performance when the application and the
database were on the same machine?
What steps shall I follow in order to improve the performance?
Best Regards
Description: Description: CoopLogo1Description: Description: CoopLogo1
Cooperative Computer Society (S.E.M) Ltd
1306 Nicosia
P.O.B. 25037 CY
Tel: +357 22 673 901
Fax: +357 22 672 774
Achilleas Achilleos
Official A
OS and Databases Management
<mailto:AchilleasAchilleos@semltd.com.cy> AchilleasAchilleos@semltd.com.cy
--Boundary_(ID_um8UejUkFm8m2wB3jnZNYA)
It seems you might be facing migration issues.
Had you rebuild your database statistics on the new machine?
Also, is your Informix server too overloaded? Is your network at a good speed
between servers? Did you get a network traffic report?
If it´s really an Informix server issue, you might need some performance
tunning.... also consider upgrading it to 11.70 as soon as possible.
Regards.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70
IBM Information Management Informix Technical Professional
IBM Infosphere DataStage Technical Professional
Database Administrator - Cleartech Ltda
BRIUG website administrator
Informix independent consultant
> To: ids@iiug.org
> From: AchilleasAchilleos@semltd.com.cy
> Subject: Performance improvment steps [27458]
> Date: Mon, 25 Jun 2012 03:15:04 -0400
>
> Hi to ALL,
>
> The performance is degraded when I split my application server from my
> database server.
>
> On the application server we have Genero Server v2.21.01 with Genero (4js)
> programs.
>
> And the database server is: IBM Informix Dynamic Server Version 11.50.FC3
>
> For information in the onconfig we set
>
> NETTYPE ipcshm,1,700,CPU
>
> NETTYPE soctcp,16,500,NET>
> Since we have around 3000 clients connected on the application server.
>
> Is it possible to have the same performance when the application and the
> database were on the same machine?
>
> What steps shall I follow in order to improve the performance?
>
> Best Regards
>
> Description: Description: CoopLogo1Description: Description: CoopLogo1
>
> Cooperative Computer Society (S.E.M) Ltd
>
> 1306 Nicosia
>
> P.O.B. 25037 CY
>
> Tel: +357 22 673 901
>
> Fax: +357 22 672 774
>
> Achilleas Achilleos
>
> Official A
>
> OS and Databases Management
>
> <mailto:AchilleasAchilleos@semltd.com.cy> AchilleasAchilleos@semltd.com.cy
>
> --Boundary_(ID_um8UejUkFm8m2wB3jnZNYA)
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
On 25.06.12 09:15, Achilleas Achilleos wrote:
> Hi to ALL,
>
> The performance is degraded when I split my application server from my
> database server.
>
> On the application server we have Genero Server v2.21.01 with Genero (4js)
> programs.
>
> And the database server is: IBM Informix Dynamic Server Version 11.50.FC3
>
> For information in the onconfig we set
>
> NETTYPE ipcshm,1,700,CPU
>
> NETTYPE soctcp,16,500,NET>
> Since we have around 3000 clients connected on the application server.
>
> Is it possible to have the same performance when the application and the
> database were on the same machine?
>
> What steps shall I follow in order to improve the performance?
>
>
I assume the new database server has at least the same power as the
application server (type and frequency of the CPUs etc).
You used SHM when running application and database on the same server?
From my experience the performance of TCP compared to SHM is
significantly slower (~20%), on separate servers even worse.
This mainly depends on the type of communication between application and
database.
Our application uses the database only for data storage, nearly no
logic. Queries are very simple, mostly single row selects by PK or very
small result sets.
With this we never get the throughput on two servers as on a single one,
doesn't matter 100 MBit or 10 GB ether net or tuning the network
parameters of the OS.