CFSTAT - average DB Time - What means it really?

[Thomas Schumann]

Hello,

we have running an CF10 Server. We do monitoring with cfstat for one week.

We are not sure, what the avg db time value shows.

The documentation says (for CF10): 

A running average of the time that ColdFusion spends on database-related processing of ColdFusion requests. Averages are displayed for the last two completed requests

The documentation für CF8 :

(A running average of the time that ColdFusion spends on database-related processing of ColdFusion requests.)

The difference is with or without the last two completed requests.

Now, we can track that the value for the avg db time constantly goes higher and higher.

100.000 milli seconds and more.

But we didn't have any problem with long database requests.

Request time for all database requests at our application are near 100 milliseconds.

What means the avg db time really?

What do I understand not correctly?

Thomas

[leptinella1]

I think this is a bug. I am looking at avgdbtime figures > 600000 and that's ridiculous. I think it's a cumulative figure, not an average. Restart your server and it goes to zero.

If you look at the results of  GetMetricData("perf_monitor") then you see two values avgdbtime (same value as in cfstat) and dbhits. My sense is that avgdbtime / dbhits = average time per db hit, but that's a guess.

BTW this code which is supposed to report the server load doesn't work either GetMetricData( "simple_load" ). Did Adobe do any testing...?

[Thomas Schumann]

Thanks for your support.

I think you are right. It will be a cumulative value.

Thomas