High CPU Resource Utlization

[Sai_7]

Hello Folks,
I am running an application with 1000 users(Through Loadrunner).The application is running on HP UX 11i based server with 16 CPU out of which 9CPUs are dedicated for the Database (Informix) and 6 CPUs for the application and it is configured using psets.
I found one of the 4GL module of the application is using lot of resource on CPU for the database about 97% - 100%.
I would like to know what may be the general causes for an application to use lot of CPU utlization on the database.

Please reply to me and help me in this regard.
Regards Sai.

[Sanjay Kumar Suri]

Refer the attached HP-UX Performance Cookbook.

sks

[Hein van den Heuvel]

>> I would like to know what may be the general causes for an application to use lot of CPU utlization on the database.


Generally that is because some program(mer) asked it to work hard.

The question often becomes whether the work is done efficiently.

You say you are emulating 1000 users. If those are 'working hard' (little wait time), then using 16 CPUs all out may well be reasonable. How much work is the system being asked to to, how heavy is each morcel of work. 100% busy may well be goodness! (If I run a benchmark, it is always my target)

Since you mention the database, maybe it can help you determine whether the load is reasonable or excessive. Had this been Oracle, then we would have recommended to run 'statspack' which can give you to SQL queries by cpu/buffers-accessed/io. It can also tell you how many transactions and requests are being serviced. Surely Informix has something similar?

Good luck,
Hein.

[Mark Greene_1]

What does iostat and vmstat tell you about disk activity and memory utilization? If you are not excessively paging or appear to be IO bound then that usually just means that your application is doing a lot of data manipulation once it's in memory.