Red Gate forums :: View topic - Blocked process alert doesn't always show all the info
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

Blocked process alert doesn't always show all the info

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
patelrk



Joined: 19 Jan 2011
Posts: 11
Location: UK

PostPosted: Mon Jun 11, 2012 3:17 pm    Post subject: Blocked process alert doesn't always show all the info Reply with quote

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.
Back to top
View user's profile Send private message
Chris Spencer



Joined: 29 Aug 2006
Posts: 301
Location: Red Gate - Cambridge

PostPosted: Tue Jun 12, 2012 1:22 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
patelrk



Joined: 19 Jan 2011
Posts: 11
Location: UK

PostPosted: Wed Jun 13, 2012 11:17 am    Post subject: Reply with quote

Hi Chris

I'm using version 3.1.0.125 for SqlMonitor.

The database version is Sql Server 2008.

Thanks
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group