Build 520: Erroneous "Blocked SQL Process" incident?

The .Net query cited as the Blocked process (yes, don't use SELECT *... legacy code :oops: ) is

SELECT * FROM Individual  WHERE Email = 'name@domain.org' AND IsActive = 1 AND SiteID = 4

with the Blocker being a Job that evaluates "Top Seller" Products and doesn't use a single mention of the "Individual" table...

Are you sure SQL Response picked up the correct process information? I have my doubts in this case, plus there are other processes ascribed to Process Names that have nothing to do with the SQL query exhibited as belonging to that process...

PDinCA February 27, 2008 14:11

Comments

1 comment

I suspect the "block" is correct as that comes direct from the sysprocesses table, but it does look like the SQL we report as applying to it may be incorrect (as per http://www.red-gate.com/MessageBoard/vi ... php?t=6507 )

We've got this logged as a bug and are looking to fix it.

Nigel Morse February 28, 2008 04:13

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Build 520: Erroneous &quot;Blocked SQL Process&quot; incident?

Comments