there is a process running select statement on tempdb database?

Question

In the Activity Monitor, There is a process(belongs to a single PC) running select statement on tempdb database,it is always running. and i am unable to kill it. What should i do?

Answer 1

That's you, looking in Activity Monitor.

Activity monitor shows database activity. But producing the list of activities is itself an activity. Therefore it appears in the list.

Naturally it will always be shown as running, because at the time it runs, it must be running. Also, if you kill the SPID, next time you refresh activity monitor, it will make a new connection, so you will see it again.