Lazy Writer

  • jcrawf02 (6/10/2011)


    Question is missing a response: "ten forum posts" 😛

    LOL... Yes it is 😎

  • Nice clear Friday question. Thanks Steve! 😎

  • This is great information, thanks.

  • GilaMonster (6/10/2011)


    You get a lazy writer (and couple other things) per hard NUMA node, not soft. That reference is wrong.

    Let me see if I can find a better one....

    Thanks Gail for pointing this out.

    Do you know if the MS Cert Exam is in-correct like the BOL?

    i.e. If I see this question on a Certification test should I select the Right wrong answer or the right right answser? :crazy:

  • SanDroid (6/10/2011)


    GilaMonster (6/10/2011)


    You get a lazy writer (and couple other things) per hard NUMA node, not soft. That reference is wrong.

    Let me see if I can find a better one....

    Thanks Gail for pointing this out.

    Do you know if the MS Cert Exam is in-correct like the BOL?

    i.e. If I see this question on a Certification test should I select the Right wrong answer or the right right answser? :crazy:

    That totally depends if you want to be right, or get the cert, your choice.

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • calvo (6/10/2011)


    mtassin, I believe Bob is quoting BOL in that paragraph.

    Yah, it just didn't seem as obvious a quote as it should have I guess... and I didn't read that far into it.



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • jcrawf02 (6/10/2011)


    SanDroid (6/10/2011)


    GilaMonster (6/10/2011)


    You get a lazy writer (and couple other things) per hard NUMA node, not soft. That reference is wrong.

    Let me see if I can find a better one....

    Thanks Gail for pointing this out.

    Do you know if the MS Cert Exam is in-correct like the BOL?

    i.e. If I see this question on a Certification test should I select the Right wrong answer or the right right answser? :crazy:

    That totally depends if you want to be right, or get the cert, your choice.

    Exactly my point. All MS Certification exams used to be notorious for having enough incorrect "Right" answers to cause you to fail. They usually follow along with the BOL or MS documentation. Your response was a little bit funny, but not really.

  • SanDroid (6/10/2011)


    i.e. If I see this question on a Certification test should I select the Right wrong answer or the right right answser? :crazy:

    This is MCM level material. Planning on writing that soon?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • GilaMonster (6/10/2011)


    SanDroid (6/10/2011)


    i.e. If I see this question on a Certification test should I select the Right wrong answer or the right right answser? :crazy:

    This is MCM level material. Planning on writing that soon?

    That's a relief... I was planning to go hammer through the MCTS and MCITP stuff... and then once I had those, consider what it would take to do MCM... I keep thinking NUMA is some sort of Oceanographic Research Department of the US government.



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • GilaMonster (6/10/2011)


    SanDroid (6/10/2011)


    i.e. If I see this question on a Certification test should I select the Right wrong answer or the right right answser? :crazy:

    This is MCM level material. Planning on writing that soon?

    No I do not plan on writing any MCM material. Thank you for the response. 😎

  • mtassin (6/10/2011)


    GilaMonster (6/10/2011)


    SanDroid (6/10/2011)


    i.e. If I see this question on a Certification test should I select the Right wrong answer or the right right answser? :crazy:

    This is MCM level material. Planning on writing that soon?

    That's a relief... I was planning to go hammer through the MCTS and MCITP stuff... and then once I had those, consider what it would take to do MCM... I keep thinking NUMA is some sort of Oceanographic Research Department of the US government.

    NUMA is the National Underwater and Marine Agency. It has nothing to do with SQL Server unless the server room is flooded. :w00t:

    http://www.numa.net/

    Numa was also a king of Rome.

  • OCTom (6/10/2011)


    mtassin (6/10/2011)


    GilaMonster (6/10/2011)


    SanDroid (6/10/2011)


    i.e. If I see this question on a Certification test should I select the Right wrong answer or the right right answser? :crazy:

    This is MCM level material. Planning on writing that soon?

    That's a relief... I was planning to go hammer through the MCTS and MCITP stuff... and then once I had those, consider what it would take to do MCM... I keep thinking NUMA is some sort of Oceanographic Research Department of the US government.

    NUMA is the National Underwater and Marine Agency. It has nothing to do with SQL Server unless the server room is flooded. :w00t:

    http://www.numa.net/

    Numa was also a king of Rome.

    Why do I feel an April Fool's QOTD coming on?

    What is NUMA?

    1. Former Roman Emporer

    2. National Underwater and Marine Agency

    3. Something Dirk Pitt works for

    4. A multi-processor technology



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • Nice question Steve. I had to look up NUMA as I was not familar with it. Sadly, the only numa I knew before was the numa numa song/video that was an "internet sensation".

    http://en.wikipedia.org/wiki/Numa_Numa

  • GilaMonster (6/10/2011)


    SanDroid (6/10/2011)


    i.e. If I see this question on a Certification test should I select the Right wrong answer or the right right answser? :crazy:

    This is MCM level material. Planning on writing that soon?

    Maybe so, but I have seen it in study materials for MCITP.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Nice question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 15 posts - 16 through 30 (of 37 total)

You must be logged in to reply to this topic. Login to reply