Skip to content

sp_pressuredetector #630

@MarlonRibunal

Description

@MarlonRibunal

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.

Image

IMPORTANT: If you're going to contribute code, please read the contributing guide first.
https://github.com/erikdarlingdata/DarlingData/blob/main/CONTRIBUTING.md

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions