Hello,
I am able to see Timeouts occur for SQL Stored Procs within our distributed traces waterfall.
These are always due to another Query or SP blocking the Stored proc. But, in Dynatrace, I am having a hard time trying to find what the blocker is. I have a "SQL Server Locks" Dashboard that contains a "Blocking Sessions Only" and a "Blocked Sessions Only" table, but they only show the actual Query and not the Stored Proc name.
New to Dynatrace, does anyone have a better way to see what the head Blocker of a Stored Proc is?
Just let me know if more info is needed.
Thanks,
Tom
Featured Posts
