Infrastructure (Server, Network, Database)

cancel
Showing results for 
Search instead for 
Did you mean: 

Explanation of Database Queries Window Weight (%) column

SOLVED
Highlighted
Explorer

Explanation of Database Queries Window Weight (%) column

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!
Explanation of Database Queries Window Weight (%) column
1 REPLY 1

Re: Explanation of Database Queries Window Weight (%) column

Hi,

 

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

 

For exaple efer to attached screenshots. For 15 min weight was 66.7% but for 30 min it is 50% as there are other queries too.

 

Formula is ( (Time elapsed by query of same type )/ (total time elasped by queries of all types))*100

 

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

 

Regards,
Saradhi