Red Gate forums :: View topic - Alert: Blocked Process not showing object
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

Alert: Blocked Process not showing object

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



Joined: 27 Jan 2009
Posts: 7

PostPosted: Fri Jul 13, 2012 1:36 am    Post subject: Alert: Blocked Process not showing object Reply with quote

Monitor Version: 3.1.0.125
SQL Version: Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) Sep 21 2011 22:45:45 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2)

The main alert tab 'Details' doesn't show the details:

Quote:

Block occurred at: 7:21 PM
Blocked process: Process
Blocking process: Unknown
Object blocked: Database (ReportServer$SQL2008)


It also shows the object blocked is the entire database? It does this for every alert we get for blocking. When I look in sysprocesses though, I can see the proper object id though so I don't think it is correct.

Also, if I go to the 'Processes' tab it *does* show the correct processes and their details, however no object info since that's supposed to be on the 'Details' tab.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6670

PostPosted: Mon Jul 16, 2012 3:55 pm    Post subject: Reply with quote

Hi,
From what I can tell, the process "name" is taken from the connection properties of the process that connected to the SQL Server. So I can see that potentially this could be empty.

I will try to get clarification on the "object blocked" - also on my system every attempt to simulate the blocked process says the object is a database. But you can get an idea of the object in the alert details by looking at the query fragment.
Back to top
View user's profile Send private message
Derekg



Joined: 27 Jan 2009
Posts: 7

PostPosted: Mon Jul 16, 2012 4:51 pm    Post subject: Reply with quote

The thing is on the detail tab is has both processes names included...so it just doesn't make a whole lot of sense.

Regarding the object block I am almost positive prior to my upgrading to the latest version of Red Gate Monitor 3 that the "object blocked" field used to actually show the table/index/ect that was block. I could be mistaken about that of course.

If that's not the case, though, it definitely should be on the list for improvements. Blocked processes typically have the object/page/ect id that is being blocked listed. That would be much more helpful that just the DB name.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6670

PostPosted: Wed Jul 18, 2012 4:45 pm    Post subject: Reply with quote

Deadlock alerts will show you page/index/table information. Blocked process alerts never have as far as I can tell, but the object names will be in the trace.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6670

PostPosted: Mon Jul 23, 2012 2:00 pm    Post subject: Reply with quote

Hi Derek,

Just to confirm, the "process name" in the "SQL Processes" tab are taken from the connection string. For instance, if you were to enter "Application Name=test" in SSMS "advanced" connection properties, the SQL Process name would show up as "test". So if this is blank, then the process did not specify an applicaiton name when it connected. If your applciations allow you to specify a connection string, try including "application name=MyApplication" in the connection string.
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