I'm monitoring the whole SQL Server environment with the blocked process report.
I'm running this process in background as a job to get the informations.
The problem is that it generated a lot of lines of blocked informations and I'm having issues to parse the information.
Is there any script that I could get only the sqlhandle and the line of the object of the blocked and blocking process? That's all I need.
Anyone can help me?
Thanks