CFSTAT - average DB Time - What means it really?

Question

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 requestsThe 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 · Answer

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...?

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded