ReportServer Forum

aditi.raiter

Member

Registered: 2018-05-01

PID of a report sql

Does report server store/know PID of a sql in a report issued on database. If yes, how can that be accessed? If there is a situation that 2 users run the same report sql and one of them needs to be killed, how can we know the process id of the report on the server and the corresponding pid on database.

jalbrecht

Administrator

Registered: 2016-10-21

Re: PID of a report sql

Dear Aditi,
this is not straightforward right now. By the nature of the question there is no difference on the ConnectionPool / DB side of it but just two equivalent queries running at the same time in two different sessions. However on the UserInterface / ConnectionPool side there is a difference, two different UI's executing a report. We will look into a way to access the missing information. To do so we created a feature request. Warning: This will probably not be in the near future.
Wbr jan

eduardo

Administrator

Registered: 2016-11-01

Website

Re: PID of a report sql

Hi Aditi,

we raised feature request RS-3341 for this.

Regards,
Eduardo

aditi.raiter

Member

Registered: 2018-05-01

Re: PID of a report sql

Thanks for the update!