Bug in Sessions Filter

by Sep 3, 2015

  • Avatar of Mike Lawell
    Mike Lawell

    Participant

    In the Sessions Filter the options “Blocking and Blocked only” and “Blocking or Blocked only” aren’t working as expected.

    “Blocking and Blocked only” should only return sessions that are both blocking and being blocked…
    “Blocking or Blocked only” should return sessions that are being blocked or are blocking…

    The options are switched… “Blocking and Blocked only” is returning blocked or blocker sessions and the “Blocking or Blocked only” is only returning those sessions that are both blocking and blockers,

    Avatar of Idera SQLSupport
    Idera SQLSupport

    Moderator

    Mike,

    I just tested this on the 9.1.1.1492 version of SQL diagnostic manager and those filters appear to be working properly. Which version of SQLdm were you testing this on?


    ? Regards,

    Idera Technical Support – SQL Products

    Avatar of Mike Lawell
    Mike Lawell

    Participant

    9.1.1.1492 … doesn’t work properly for me…

    “Blocking and Blocked only” should only return sessions that are both blocking and being blocked…
    “Blocking or Blocked only” should return sessions that are being blocked or are blocking…

    AND ONCE AGAIN…. I’m unable to upload a snapshot… so you can’t see… but it is WRONG.

    http://imgur.com/Dt9NHzx

    Blocking OR Blocked (both should show up… and none do:

    http://imgur.com/eHjP7JE

    Avatar of Idera SQLSupport
    Idera SQLSupport

    Moderator

    Mike,

    Unfortunately, I’m unable to reproduce the behavior you’ve reported. In searching previous cases, I’m also unable to locate any instances where a customer reported such behavior.

    Given that you are running into this problem, I’d recommend reporting this issue directly to support@idera.com so that we may open a case and work directly with you.


    ? Regards,

    Idera Technical Support – SQL Products