I have run a SQL Profiler Trace which detected a process blocking. Now what should i do, if it always brings the same blocking event, each time duration is getting bigger. I have only one transaction which created a block, and I want it to be fixed in a trace only once, why it keeps repeating? Thanks
The Blocked Process Report event class indicates that a task has been blocked for more than a specified amount of time.
To configure the Blocked Process Threshold and frequency at which reports are generated, use the sp_configure command to configure the blocked process threshold option, which can be set in seconds. The threshold can be set from 0 to 86,400.