cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Explanation of Database Queries Window Weight (%) column

jodom
Explorer

i'm having trouble understanding the definition of the Weight % column in Database Queries Window. The documentation states, "

  • Weight (%): The percentage of the total time consumed by the query." Where is the total time coming from? Thanks!
1 REPLY 1

Saradhi.Potharaju
AppDynamics Team (Retired)

Hi,

 

It is calculated based on the selected time frame in the UI. (for example "last 15 minutes", "last 30 minutes")

 

For example, refer to the attached screenshots. For 15 min weight was 66.7% but for 30 min it is 50% as there are other queries too.

 

The formula is ( (Time elapsed by query of the same type )/ (total time elapsed by queries of all types))*100

 

PS: If this answer helped you or solved your issue, please click Accept Solution below.

 

Regards,
Saradhi