| Author |
Message |
patelrk
Joined: 19 Jan 2011
Posts: 11
Location: UK
|
 Posted: Mon Jun 11, 2012 3:17 pm Post subject: Blocked process alert doesn't always show all the info |
 |
|
| 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 |
|
 |
Chris Spencer
Joined: 29 Aug 2006
Posts: 300
Location: Red Gate - Cambridge
|
| Posted: Tue Jun 12, 2012 1:22 pm Post subject: |
|
|
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 |
|
|
patelrk
Joined: 19 Jan 2011
Posts: 11
Location: UK
|
| Posted: Wed Jun 13, 2012 11:17 am Post subject: |
|
|
Hi Chris
I'm using version 3.1.0.125 for SqlMonitor.
The database version is Sql Server 2008.
Thanks |
|
| Back to top |
|
|
|
|
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
