High Resource Utilization

[Sai_7]

Hello Guys,
I am testing an application on Loadrunner.The server is based on HP UX 11i platform and has a total of 16 CPUs.
I have allocated 9 processors to Database and 6 CPUs for my applications using Psets.The database on which am running the application is Informix.When I run my application with this setup the CPUs dedicated for INformix goes very High about 97%-100% always.I also found that one of the 4GL application is using most of the resources on Informix.
I want to know what may be the main causes for an application to use so much of the Informix resources.

Please treat this as urgent..and help me out.

[Dwyane Everts_1]

Sai,

Its early in the morning here, and I've just started my coffee, so bear with me as I try to help. :)

First thought...this is 1 of 4 GL app servers. Are all the SQL statements the same on each GL app server? I have found that 70% of the time, the server is configured correctly, but the SQL query is incorrect or someone turned debugging on during the development/troubleshooting and forgot to turn it back off when they were done. Check the packet trace if you have that type of granularity. If this is the case, you will see the bad SQL query, or you will see a number of small packets being bounced back and forth between servers. You should also see network congestion/latency between the servers.

Hope this helps, if not, I'll try again later when I wake up a bit more :)

Dwyane

Dwyane