-
Notifications
You must be signed in to change notification settings - Fork 182
Description
Version of the script
N/A
What is the current behavior?
Query runtime wrongly showing a spid running for more than 1 DAY, sp_whoisactive is correctly showing runtime.
If the current behavior is a bug, please provide the steps to reproduce.
EXEC sp_pressuredetector. Compare it with sp_whoisactive. Check for queries that run for at least 56mins because that's where I saw this issue.
What is the expected behavior?
Show correct runtime.
Which versions of SQL Server and which OS are affected by this issue? Did this work in previous versions of our procedures?
Not that I know of. This is on SQL 2022 CU19.
IMPORTANT: If you're going to contribute code, please read the contributing guide first.
https://github.com/erikdarlingdata/DarlingData/blob/main/CONTRIBUTING.md