Subject | find problematic query |
---|---|
Author | Pavol Stárek PSŽ |
Post date | 2004-10-04T20:02:43Z |
hallo there,
i want to ask if there is any tool to determine which query is doing load...
I have web server with lot o f havy loaded apps on it. Db server is
separate machine only for firebird on linux.
When i look at dataserver peformance i see standard load under 10%...
but few times in minute i see there
load over 100% and i dont know which query is doing this...
I need something like sql monitor but do not know about one... Problem
is, that there is hundreds queries in minute...
thanx,
pavol
i want to ask if there is any tool to determine which query is doing load...
I have web server with lot o f havy loaded apps on it. Db server is
separate machine only for firebird on linux.
When i look at dataserver peformance i see standard load under 10%...
but few times in minute i see there
load over 100% and i dont know which query is doing this...
I need something like sql monitor but do not know about one... Problem
is, that there is hundreds queries in minute...
thanx,
pavol