Options

Blocked process alert doesn't always show all the info

patelrkpatelrk Posts: 13 Bronze 1
edited June 13, 2012 6:17AM in SQL Monitor Previous Versions
When we get blocked process alerts, we noticed that the Processes tab shows incomplete info in the Blocking Process (for instance). The info that's missing is the Blocking process, host and the user. However, this info can be found when you click on the SQL processes / Profiler trace tab and look for the process id.
· Share on Twitter

Comments

  • Options
    Chris SpencerChris Spencer Posts: 301
    I've quickly tested this but have so far been able to reproduce.

    Which version of SQL Monitor are you using out of interest? Also which version of SQL Server (e.g. 2005, 2008 or 2012) are these blocked process alerts for?

    Regards
    Chris
    Chris Spencer
    Test Engineer
    Red Gate
    · Share on Twitter
  • Options
    patelrkpatelrk Posts: 13 Bronze 1
    Hi Chris

    I'm using version 3.1.0.125 for SqlMonitor.

    The database version is Sql Server 2008.

    Thanks
    · Share on Twitter
Sign In or Register to comment.