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? enter image description here 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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.