Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Blocking Expand / Collapse
Author
Message
Posted Thursday, May 15, 2008 9:24 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 8:26 AM
Points: 2,716, Visits: 2,484
Comments posted to this topic are about the item Blocking
Post #501750
Posted Friday, May 16, 2008 8:28 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 16, 2008 1:20 PM
Points: 102, Visits: 25
Ok it looks like I am back on my soap box. This is another one of those questions that actually does not have a right answer given. This is not a microsoft exam where you choose the best answer. What the H E double hockey sticks is going on with these questions.

While it is expected behavior, that is not completely the right answer as given in the support site. I did know that according to microsoft this was the intended behavior but others that choose parallelism is not totally out of the question. Ascync IO, not totally wrong. This should have been choose which apply.

Coooooommmmmmmeeeeee ooooooooonnnnnnnnnn. I mean WTF. Ya see I am black and white kind of guy. Were any of the answers totally right or totally wrong... nope. Read the article.:D


DEX
:D
The more you help the business, the more they will help you...well sometimes anyway.
Post #502106
Posted Friday, May 16, 2008 8:49 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 8:26 AM
Points: 2,716, Visits: 2,484
That is why I added the caveats that the wait time value is low and the waittype is a latch waittype.

If you had waits due to parallelism the waittypes would be PSS_CHILD, EXCHANGE or CXPACKET waittypes and the blocked column would not be populated - after all a paralleism wait is NOT a block.


Post #502133
Posted Friday, May 16, 2008 9:04 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 16, 2008 1:20 PM
Points: 102, Visits: 25
While that is true, #1 is partially true, though not infinite, #2 is true it is the expected behavior, I guess that parallism is not correct I did not really notice there was anything in there about what type, #4 is definitely not correct. The real reason we see this type of behavior which is what I was getting at is because of the attempt to keep all of the IO asynchronous. This is really an expected result from sp_who but the cause is IO. This can be aleviated in some cases but not all. I was looking more for a root of the why not something else I guess.

Thanks for the reply.



DEX
:D
The more you help the business, the more they will help you...well sometimes anyway.
Post #502156
Posted Thursday, December 23, 2010 4:45 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:11 PM
Points: 7,920, Visits: 9,646
Nice straghtforwards question.

I found this one easy to answer because years ago I wrote some code to detect undesirable blocking behaviours in a particular system that had a couple of extremely buggy apps with rotten embedded SQL and kill off the root blocker; this was actually safe given the overall system design, although it wasn't a desirable things to do things, and worked fine for some time; then along came SP4 and it started killing things too often - which turned out to be this problem. Very easily fixed once I discovered that this was expected behaviour, but a week or so of very real worry before I discovered what was going on. (Of course we planned a rewrite of those apps, including restricting them to use only stored procedures, no other db access, but it took a long time to get a plan approved and a long time to get a decent implementation; but eventually that block detector ceased to be needed.)


Tom
Post #1038976
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse