Event id -1 , Wait Time of User and 15100 - User Interaction in table

[Former Member]

Dear Guru's,

I am trying to analyse the performance of queries.

I am trying to add the time taken by the query at different stages of excecution (all events) except the wait time.

By wait time i mean the time the user's spends waiting watching at the report without any action.

Please correct my understanding.

Does the below event id and the description found in table RSDDSATEVENTS

correspond to the time user is idle and is just watching the result displayed in the report.

1 - Wait Time of User

5100 - User Interaction in table

Request you to clarify my understanding and also highlight if there are any other events like this which should not be considered as they do not attribute to the performance.

Regards,

Hemanth

[Former Member]

Any inputs on what time should not be considered to calculate the query performance ??