• SQLRNNR (9/4/2015)


    Alvin Ramard (9/4/2015)


    SQLRNNR (9/4/2015)


    Alvin Ramard (9/4/2015)


    Sean Lange (9/4/2015)


    Alvin Ramard (9/4/2015)


    Brandie Tarvin (9/4/2015)


    I just came up with the great "customer friendly" metaphor for table contention.

    One business unit wants to know why production report X was timing out, so I went around asking different teams for the names of reports that they might have been running around the same time. One team said "but this is a report we designed ourselves, so I doubt it did anything."

    My response was, "I'm just trying to figure out if the problem was caused by one big thing or a bunch of little things: Like everyone trying to reach into the same narrow-neck candy jar at the same time to get that Reese's Pieces on top, only no one can grab it because no one can get their hand through the neck."

    Now it's got me thinking, how have you described table contention to non-IT people?

    Not sure how I would describe table contention, but I like how you put it.

    Looking at: "One team said "but this is a report we designed ourselves, so I doubt it did anything." "

    hmmm. So they think they're better than others? 😀

    I read a different and probably for more cynical way. I read it as, "we wrote that report so it is useless anyway". 😀

    Well, another thought that crossed my mind was: 'Oh. So YOU'RE the ones that wrote that report." 🙂

    Or, "Oh, so you're the ones with your heads up your butt."

    Yes, and not only that, John has his head so far up Tom's butt that he can see Larry's feet! 😀

    And there my friends is table contention! :w00t:

    Probably got a bandwidth issue too! 😛



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]