how to analyze bottleneck in informix db
Hi All,
I'm curious about on how to analyze a database which has bottlenecks... On my
perpective, i'll do the ff:
1. onstat -u -- to check what user.
2. onstat -g ses -- to check the current session.
3. onstat -g mem -- to check the memory.
4. onstat -k; to check the processes (locks).
Q:
How can I see what causes bottleneck and how to find that table/sql?
Have you considered using OAT (OpenAdmin Tool). It has a report
to show what users are waiting on?
http://www.openadmintool.org/
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 01/29/2010 12:28:48 AM:
> Hi All,
>
> I'm curious about on how to analyze a database which has bottlenecks...
On my
> perpective, i'll do the ff:
>
> 1. onstat -u -- to check what user.
> 2. onstat -g ses -- to check the current session.
> 3. onstat -g mem -- to check the memory.
> 4. onstat -k; to check the processes (locks).
>
> Q:
> How can I see what causes bottleneck and how to find that table/sql?
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>