EAserver - easerver tuning

Author

easerver tuning

Lorna

2006-03-06, 7:19 pm

We have an EAserver 5.0 production environment with 400 users, and we are
experiencing some troubles:
-Response time is more than 30 seconds
-We have "page not found" and "this article cannot be loaded" errors

We think this has to do with tuning.

The platform we are using is:
-OS: Windows 2003 Server Enterprise SP1
-Application developed using PowerBuilder 9. Is a web application, so it
"exports" to jsp (JAVA)
-The application allows users to input, modify and select data from an ASE
12.5 database.
-The application is not compiled, meaning it has to access SQL Anywhere.

The response time we are aiming for is no more than 3 seconds.

We have use the EAServer monitoring tools and for 100 users we determined
that:

HTTP Statistics Runtime Display > Sessions = average of 102
Hits/sec last minute = between 50 and 100 (for around 5 minutes)
Cache Runtime Display > Connections Open = average of 22
IIOP Statistics Runtime Display > Sessions = average of 4

These are the server parameters:

com.sybase.jaguar.server.http.maxthreads = 1000
com.sybase.jaguar.server.maxconnections = 700
com.sybase.jaguar.server.maxthreads = 1800
com.sybase.jaguar.server.flowcontrol.http = true
com.sybase.jaguar.server.flowcontrol.iiop = true
com.sybase.jaguar.server.flowcontrol.maxthreads = en blanco
com.sybase.jaguar.server.jvm.nojit = true

For the database cache:
Max connections pool size = 900
Min connections pool size = 30
Pooled connection idle timeout = 300
Pooled connection refresh rate = 600

We already read the tuning documentation, but I was hoping that somebody
could give us some values to start tuning because this values are not
bringing the application any improvement.

Thank you a lot,

Lorna.

Millard F. Brown III

2006-03-06, 7:19 pm

A couple of questions:

- Is this a clustered environment?
- How many CPUs per server?
- Have you tried the same queries and updates without the JSP and Middle
tier involved (i.e. using ISQL or similar?) - With what results?

I know you've looked at the tuning docs, but if you haven/t seen it, you
might want to look at the doc "CPU Sizing for Concurrent Client Connections
to EAServer." id=1019577

--
Regards,
Millard [TeamSybase]

"Lorna" < lsanchez@centauritec
h.com> wrote in message
news:440c7052@forums
-1-dub...
> We have an EAserver 5.0 production environment with 400 users, and we are
> experiencing some troubles:
> -Response time is more than 30 seconds
> -We have "page not found" and "this article cannot be loaded" errors
>
> We think this has to do with tuning.
>
> The platform we are using is:
> -OS: Windows 2003 Server Enterprise SP1
> -Application developed using PowerBuilder 9. Is a web application, so it
> "exports" to jsp (JAVA)
> -The application allows users to input, modify and select data from an ASE
> 12.5 database.
> -The application is not compiled, meaning it has to access SQL Anywhere.
>
> The response time we are aiming for is no more than 3 seconds.
>
> We have use the EAServer monitoring tools and for 100 users we determined
> that:
>
> HTTP Statistics Runtime Display > Sessions = average of 102
> Hits/sec last minute = between 50 and 100 (for around 5 minutes)
> Cache Runtime Display > Connections Open = average of 22
> IIOP Statistics Runtime Display > Sessions = average of 4
>
> These are the server parameters:
>
> com.sybase.jaguar.server.http.maxthreads = 1000
> com.sybase.jaguar.server.maxconnections = 700
> com.sybase.jaguar.server.maxthreads = 1800
> com.sybase.jaguar.server.flowcontrol.http = true
> com.sybase.jaguar.server.flowcontrol.iiop = true
> com.sybase.jaguar.server.flowcontrol.maxthreads = en blanco
> com.sybase.jaguar.server.jvm.nojit = true
>
> For the database cache:
> Max connections pool size = 900
> Min connections pool size = 30
> Pooled connection idle timeout = 300
> Pooled connection refresh rate = 600
>
> We already read the tuning documentation, but I was hoping that somebody
> could give us some values to start tuning because this values are not
> bringing the application any improvement.
>
> Thank you a lot,
>
> Lorna.
>
>
>

Lorna

2006-03-06, 7:19 pm

Thanks for the reply!

1-Is not a clustered environment
2-The server has 4 CPUs (and when the application runs, the 4 processors
load goes to 100%)
3-We haven't tried that.

I will take a look, thanks.

Lorna.

"Millard F. Brown III" <millard.brown@teamsybase.com> wrote in message
news:440c796c$1@foru
ms-1-dub...
> A couple of questions:
>
> - Is this a clustered environment?
> - How many CPUs per server?
> - Have you tried the same queries and updates without the JSP and Middle
> tier involved (i.e. using ISQL or similar?) - With what results?
>
> I know you've looked at the tuning docs, but if you haven/t seen it, you
> might want to look at the doc "CPU Sizing for Concurrent Client
Connections
> to EAServer." id=1019577
>
> --
> Regards,
> Millard [TeamSybase]
>
> "Lorna" < lsanchez@centauritec
h.com> wrote in message
> news:440c7052@forums
-1-dub...
are[color=darkred]
ASE[color=darkred]
determined[color=dar
kred]
>
>

Mark Maslow

2006-03-06, 7:19 pm

If you're getting "page not found" and "page cannot be loaded" type
errors, I would expect something helpful in one or more of the log
files. Check jaguar.log and jaguarhttpservlet.log.

I would try adding debug messages before and after DB calls to see if
the delays are caused by the database, before starting to tune EAServer.

In article <440c7052@forums-1-dub>, lsanchez@centauritec
h.com says...
> We have an EAserver 5.0 production environment with 400 users, and we are
> experiencing some troubles:
> -Response time is more than 30 seconds
> -We have "page not found" and "this article cannot be loaded" errors
>
> We think this has to do with tuning.
>
> The platform we are using is:
> -OS: Windows 2003 Server Enterprise SP1
> -Application developed using PowerBuilder 9. Is a web application, so it
> "exports" to jsp (JAVA)
> -The application allows users to input, modify and select data from an ASE
> 12.5 database.
> -The application is not compiled, meaning it has to access SQL Anywhere.
>
> The response time we are aiming for is no more than 3 seconds.
>
> We have use the EAServer monitoring tools and for 100 users we determined
> that:
>
> HTTP Statistics Runtime Display > Sessions = average of 102
> Hits/sec last minute = between 50 and 100 (for around 5 minutes)
> Cache Runtime Display > Connections Open = average of 22
> IIOP Statistics Runtime Display > Sessions = average of 4
>
> These are the server parameters:
>
> com.sybase.jaguar.server.http.maxthreads = 1000
> com.sybase.jaguar.server.maxconnections = 700
> com.sybase.jaguar.server.maxthreads = 1800
> com.sybase.jaguar.server.flowcontrol.http = true
> com.sybase.jaguar.server.flowcontrol.iiop = true
> com.sybase.jaguar.server.flowcontrol.maxthreads = en blanco
> com.sybase.jaguar.server.jvm.nojit = true
>
> For the database cache:
> Max connections pool size = 900
> Min connections pool size = 30
> Pooled connection idle timeout = 300
> Pooled connection refresh rate = 600
>
> We already read the tuning documentation, but I was hoping that somebody
> could give us some values to start tuning because this values are not
> bringing the application any improvement.
>
> Thank you a lot,
>
> Lorna.
>
>

Chris Pollach

2006-03-06, 7:19 pm

Lorna;

1) Is "Hyper-Threading" enabled on your CPU's?
2) What O)/S are you using?

Thanks ... Chris

"Lorna" < lsanchez@centauritec
h.com> wrote in message
news:440c7cf6$1@foru
ms-2-dub...
> Thanks for the reply!
>
> 1-Is not a clustered environment
> 2-The server has 4 CPUs (and when the application runs, the 4 processors
> load goes to 100%)
> 3-We haven't tried that.
>
> I will take a look, thanks.
>
> Lorna.
>
> "Millard F. Brown III" <millard.brown@teamsybase.com> wrote in message
> news:440c796c$1@foru
ms-1-dub...
Middle[color=darkred
]
> Connections
> are
it[color=darkred]
> ASE
Anywhere.[color=darkred]
> determined
somebody[color=darkr
ed]
>
>

Peter Abbott

2006-03-06, 7:19 pm

Those settings you have listed in your post are rather extreme,
especially the 900 for the max connection pool size. You will find that
there will only ever be a handful of database connections going at one
time.

For a system with 400 users as you describe you would be able to set it
to something like 50. Also bringing down the min pool size to something
like 5 or 10. If you get the situation where you run out of database
connections there will be messages in the jaguar log file. Setting 1800
max threads also seems a bit excessive, under heavy load it would be
hard for any of the threads to get any work done, maybe try knocking it
down a bit, something like:

> com.sybase.jaguar.server.http.maxthreads = 500
> com.sybase.jaguar.server.maxconnections = 350
> com.sybase.jaguar.server.maxthreads = 900

Pete

Lorna wrote:
> We have an EAserver 5.0 production environment with 400 users, and we are
> experiencing some troubles:
> -Response time is more than 30 seconds
> -We have "page not found" and "this article cannot be loaded" errors
>
> We think this has to do with tuning.
>
> The platform we are using is:
> -OS: Windows 2003 Server Enterprise SP1
> -Application developed using PowerBuilder 9. Is a web application, so it
> "exports" to jsp (JAVA)
> -The application allows users to input, modify and select data from an ASE
> 12.5 database.
> -The application is not compiled, meaning it has to access SQL Anywhere.
>
> The response time we are aiming for is no more than 3 seconds.
>
> We have use the EAServer monitoring tools and for 100 users we determined
> that:
>
> HTTP Statistics Runtime Display > Sessions = average of 102
> Hits/sec last minute = between 50 and 100 (for around 5 minutes)
> Cache Runtime Display > Connections Open = average of 22
> IIOP Statistics Runtime Display > Sessions = average of 4
>
> These are the server parameters:
>
> com.sybase.jaguar.server.http.maxthreads = 1000
> com.sybase.jaguar.server.maxconnections = 700
> com.sybase.jaguar.server.maxthreads = 1800
> com.sybase.jaguar.server.flowcontrol.http = true
> com.sybase.jaguar.server.flowcontrol.iiop = true
> com.sybase.jaguar.server.flowcontrol.maxthreads = en blanco
> com.sybase.jaguar.server.jvm.nojit = true
>
> For the database cache:
> Max connections pool size = 900
> Min connections pool size = 30
> Pooled connection idle timeout = 300
> Pooled connection refresh rate = 600
>
> We already read the tuning documentation, but I was hoping that somebody
> could give us some values to start tuning because this values are not
> bringing the application any improvement.
>
> Thank you a lot,
>
> Lorna.
>
>
>

Jonathan Baker [Sybase]

2006-03-10, 8:24 pm

Lorna:

What you are trying to do isn't possible.

I researched and wrote the EAServer tuning presentation for TechWave a
few years back. (If you like, i can email it to you.) Our research on
Windows using EAServer has about 50 people per CPU. To make matters
worse, the load does NOT scale evenly across a 4 CPU box. I think the
maximum you should expect is about 150-175 users on that box.

You should also be experiencing a lot of CPU thrashing on the box -
which is why the CPU load is pegged at 100%.

I suggest you look at more single or dual CPU units, and clustering them
together.

Jonathan

Lorna wrote:
> Thanks for the reply!
>
> 1-Is not a clustered environment
> 2-The server has 4 CPUs (and when the application runs, the 4 processors
> load goes to 100%)
> 3-We haven't tried that.
>
> I will take a look, thanks.
>
> Lorna.
>
> "Millard F. Brown III" <millard.brown@teamsybase.com> wrote in message
> news:440c796c$1@foru
ms-1-dub...
> Connections
> are
> ASE
> determined
>
>

Sponsored Links