Options
SQL monitor blocking
DBdave
Posts: 14 Bronze 1
SQL monitor doesn't show the lead blocker.
It catches blocks but only shows ones with a blocking process ID, it doesn't show the process that caused the start of the blocking.
If i run a big report with multiple table joins and data on our DB it will cause blocking but the query is not captured by SQL monitor only the queries which may have had a blocking knock affect caused by it.
Cheers
Dave
It catches blocks but only shows ones with a blocking process ID, it doesn't show the process that caused the start of the blocking.
If i run a big report with multiple table joins and data on our DB it will cause blocking but the query is not captured by SQL monitor only the queries which may have had a blocking knock affect caused by it.
Cheers
Dave
Comments
When I view a blocked process alert, I get the following in the "Processes" tab - it shows a blocked process and a blocking process.
Hi Brian, I get similar entries in my log for blocks but I've noticed that if a large select statement is run against the DB and has many table joins it can cause multiple blocks but the big query itself is not being shown as the cause of the blocking but rather an update or delete statement a step down in the chain.