Blocked process alert doesn't always show all the info

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Blocked process alert doesn't always show all the info

Postby patelrk » Mon Jun 11, 2012 3:17 pm

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.
patelrk
 
Posts: 11
Joined: Wed Jan 19, 2011 3:44 pm
Location: UK

Postby Chris Spencer » Tue Jun 12, 2012 1:22 pm

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
Chris Spencer
 
Posts: 301
Joined: Tue Aug 29, 2006 9:09 am
Location: Red Gate - Cambridge

Postby patelrk » Wed Jun 13, 2012 11:17 am

Hi Chris

I'm using version 3.1.0.125 for SqlMonitor.

The database version is Sql Server 2008.

Thanks
patelrk
 
Posts: 11
Joined: Wed Jan 19, 2011 3:44 pm
Location: UK


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests