You should also consider downloading and using SeeFusion from Webapper -
this will seriously help you in finding bottlenecks.
-Original Message-
From: Smith, Ed [mailto:[EMAIL PROTECTED]
Sent: 09 September 2005 17:34
To: CF-Talk
Subject: Help! Is there any way to log all database query times to a log?
Hi all,
We're trying to debug a performance problem that has cropped up recently.
What happens is that all threads (that use database connections) hang for a
period of time. Then, some query passes through the system with a long
query time, and there rest of the held up processes blow through. A CFSTAT
is at the bottom of the email that shows this behavior.
An analysis of the database (Oracle 9i) shows no tables locked, no load
problems, plenty of free connections.
All threads that use a database seem to be held up.
The database settings are Pooled, but no limit to connections.
The CF Server is MX6.1 with all current updaters - there are 3 servers load
balanced using a BigIP. All servers exhibit the behavior, but not at the
same time (although sometimes they do).
There are no server, application, or named locks that would account for this
behavior.
What I was hoping to find is a way to add some code to an OnRequestEnd
template that would dump the database query times to a file, so I could look
for excessively long queries during that time period.
I've not been able to find any documented features in CF that would allow me
to do that.
Any ideas of how I could get database query times (like they appear in
debugging) to be dumped to a file?
Thanks in advance!
Edward Smith
Chief Architect
Internet Broadcasting.
Pg/Sec DB/Sec CP/Sec Reqs Reqs Reqs AvgQ AvgReq AvgDB Bytes Bytes
Now Hi Now Hi Now Hi Q'ed Run'g TO'ed Time Time Time In/Sec
Out/Sec
0 17 0 222 -1 -1 0 330 0 46502 13976 0 0
3 17 13 222 -1 -1 0 300 0 30645 2114 0 0
17 17 95 222 -1 -1 0 130 0 10850 62 9120
9 17 65 222 -1 -1 0 7 0 0 30166 10 2908 18466
4 17 43 222 -1 -1 0 6 0 0 4038 7 2654 174042
1 17 1 222 -1 -1 0 5 0 0 2215 1140 0
0 17 0 222 -1 -1 0 7 0 0 2215 1141510 0
2 17 5 222 -1 -1 0 7 0 0 62814 1220 0
0 17 0 222 -1 -1 0 7 0 0 62814 0 0
0 17 0 222 -1 -1 0 9 0 0 62814 1653 0
0 17 0 222 -1 -1 0 9 0 0 62814 0 0
2 17 5 222 -1 -1 0 9 0 0 35342 9970
0 17 0 222 -1 -1 0 9 0 0 35342 0 0
0 17 0 222 -1 -1 0 100 0 35342 9390
0 17 3 222 -1 -1 0 120 0 35312 1689 0
0 17 0 222 -1 -1 0 120 0 35312 0 0
0 17 0 222 -1 -1 0 120 0 35312 0 0
0 17 0 222 -1 -1 0 140 0 35312 1821 0
0 17 0 222 -1 -1 0 190 0 35312 5012 0
0 17 9 222 -1 -1 0 200 0 3536075 9340
0 17 0 222 -1 -1 0 210 0 3536075 0 0
0 17 0 222 -1 -1 0 220 0 3536075 1157 0
0 17 0 222 -1 -1 0 230 0 3536075 9860
Pg/Sec DB/Sec CP/Sec Reqs Reqs Reqs AvgQ AvgReq AvgDB Bytes Bytes
Now Hi Now Hi Now Hi Q'ed Run'g TO'ed Time Time Time In/Sec
Out/Sec
0 17 3 222 -1 -1 0 230 0 35318212 0 324126
0 17 0 222 -1 -1 0 230 0 35318212 0 70217
0 17 0 222 -1 -1 0 250 0 35318212 1181 39047
1 17 8 222 -1 -1 0 280 0 6405 7237 21307 0
0 17 0 222 -1 -1 0 290 0 6405 7237 6680
0 17 0 222 -1 -1 0 310 0 6405 7237 2053 0
0 17 0 222 -1 -1 0 310 0 6405 7237 0 0
0 17 0 222 -1 -1 0 330 0 6405 7237 1892 46811
0 17 0 222 -1 -1 0 340 0 6405 7237 1377 0
0 17 0 222 -1 -1 0 340 0 6405 7237 0 0
0 17 0 222 -1 -1 0 340 0 6405 7237 0 0
0 17 0 222 -1 -1 0 350 0 6405 7237 7770
0 17 0 222 -1 -1 0 350 0 6405 7237 0 0
0 17 0 222 -1 -1 0 350 0 6405 7237 0 0
0 17 0 222 -1 -1 0 360 0 6405 7237 8270
0 17 0 222 -1 -1 0 370 0 6405 7237 9700
0 17 0 222 -1 -1 0 380 0 6405 7237 9710
0 17 0 222 -1 -1 0 390 0 6405 7237 8970
0 17 0 222 -1 -1 0 390 0 6