#1 2019-02-02 01:48:26

aditi.raiter
Member
Registered: 2018-05-01
Posts: 25

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.

Offline

#2 2019-02-27 09:02:32

jalbrecht
Administrator
Registered: 2016-10-21
Posts: 140

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

Offline

#3 2019-02-28 12:16:28

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,080
Website

Re: PID of a report sql

Hi Aditi,

we raised feature request RS-3341 for this.

Regards,
Eduardo

Offline

Board footer

Powered by FluxBB