"Total blocking duration for all descendants" value is not right in Blocking process Alert

rajesh_mehtarajesh_mehta Posts: 8
in Redgate Monitor
During one of our database change, there were some blocking at database side and as we expected, we got alert from SQL Monitor for this. What I noticed is, "Total blocking duration for all descendants:" value was not right, our database change was done in less than 1 minute and everything was running fine at database side. But SQL Monitor alert shows Total blocking duration for all descendants: value very high 4 minute.

Can someone help me understand, how it calculate the this duration and if we can do something at SQL Monitor side to handle this?

Thanks,
Rajesh
· Share on Twitter

Comments

  • Alex BAlex B Posts: 1,157 Diamond 4
    Hi Rajesh,

    How many descendants were being blocked? If there were 4 descendants and they were each blocked for 1 minute, then the total for all descendants would be 4 minutes. Does this seem like what occurred?

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter
  • rajesh_mehtarajesh_mehta Posts: 8
    Hi Alex,

    Number of blocked descendants were 21. So you mean , SQL Monitor adds up time for all? But all these were in parallel , database change which caused blocking didn`t even last for 1 minute. But looking at alert make an impression that it was block for 4 minute, which is kind of confusing and give wrong impression to end user who is looking at alert details .

    Thanks for your reply!
    Regards,
    Rajesh
    · Share on Twitter
Sign In or Register to comment.