I was trying to capture blocking query using blocked process report past 1 hour as this link
https://www.mssqltips.com/sqlservertip/4480/find-blocking-processes-using-sql-server-profiler/
I can get the blocked process query using sqlhandle but for blocking process query i cannot get it because no sqlhandle and inputbuf doesnt have any SQL statement.
Any idea? This is first time i m using this blocked process report.

Asked by jack
(79 rep)
Oct 23, 2019, 10:20 AM
Last activity: Jun 27, 2025, 05:06 AM
Last activity: Jun 27, 2025, 05:06 AM