Query plans getting dropped, potentially due to OPENQUERY - Githubissues

amachanic / sp_whoisactive

sp_whoisactive

GNU General Public License v3.0

1.14k stars 281 forks source link

Query plans getting dropped, potentially due to OPENQUERY #33

Open amachanic opened 3 years ago

amachanic commented 3 years ago

Observed on SQL Server 2017:

Query coming in from remote server via OPENQUERY
Query plan not showing in sp_whoisactive output, even though it was attainable directly via requests DMV and query_plan function
Commenting out join predicates around line 2898 fixed the issue (user_process and start_time logic)
Further exploration revealed the root cause: sysprocesses "login time" had a timestamp of over 30m after that reported in the sys.dm_exec_sessions "login time" column!

Seems to be a DMV bug, but is there some workaround?