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
Sql-server – How to handle process blocking in SQL Server Profiler
blockingprofilersql server
Related Question
- Sql-server – Find reason long running stored proc SQL Server
- Sql-server – SQL Blocking causing timeouts
- Sql-server – How is an idle SQL Server connection causing blocking
- Sql-server – how to find out what process(es) caused the autogrowth of a database or a database file
- Sql-server – Filter not working on Showplan XML in SQL Server trace
- Sql-server – Discrepancy in CPU time and reads in SQL Server profiler
- Sql-server – a SET TRANSACTION command show a long Duration when the CPU is low
Best Answer
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.