Reading, Writing, and Riskmetic

  • Comments posted to this topic are about the item Reading, Writing, and Riskmetic

  • Nice question, thanks Andy!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Another confusing question πŸ™

    A newly hired developer who works remotely has asked for permission to run Profiler so he can see the reads/writes used by his queries

    Permission to run profiler :unsure:

    (Here answer should be Alter Trace)

    OR

    Require the smallest amount of additional permissions to be granted

    :unsure:

    However even I am not sure if SET STATISTICS IO is enough to check a best performing query.

    --rhythmk
    ------------------------------------------------------------------
    To post your question use below link

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    πŸ™‚

  • rhythmk (6/19/2014)


    Another confusing question πŸ™

    A newly hired developer who works remotely has asked for permission to run Profiler so he can see the reads/writes used by his queries

    Permission to run profiler :unsure:

    (Here answer should be Alter Trace)

    OR

    Require the smallest amount of additional permissions to be granted

    :unsure:

    However even I am not sure if SET STATISTICS IO is enough to check a best performing query.

    I think the motive behind the question is something like this:

    the developer has no clue what actual permissions he needs, so he aims for the big guns and asks for profiler.

    However, the question clearly states that he only wants to see reads/writes (in other words, IO). The question then says he has only read permissions on the database.

    So the experienced DBA teaches the developer SET STATISTICS IO. It meets the requirements and doesn't require extra permissions.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • I got one of Andy's right!!!!!!!


    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    β€”Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

  • Thanks for the QoTD, :exclamation: must learn to read the question before rushing off to answer it.

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • Yeah, I didn't put enough thought into this one...just thought "What's the minimum permission required to run Profiler?" rather than "What's the minimum required to do what the developer actually needs?". Heck, you'd think including SET STATISTICS IO as an answer would have been a big enough clue, but apparently not... πŸ™‚

  • Thanks for interesting question Andy.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • I might start refusing to answer Andy's questions because I just get annoyed when I get them wrong! πŸ™‚

  • The problem, however, is that statistics IO lies any time there are scalar UDFs in use. The profiler trace doesn't.

    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
  • Require the smallest amount of additional permissions to be granted

    :unsure:

    However even I am not sure if SET STATISTICS IO is enough to check a best performing query.

    Developer need to check Read/write to improve the performance and hence SET STATISTICS IO is ideal in this case.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • This was removed by the editor as SPAM

  • GilaMonster (6/19/2014)


    The problem, however, is that statistics IO lies any time there are scalar UDFs in use. The profiler trace doesn't.

    there's lies, damn lies, then statistics IO πŸ™‚

    ---------------------------------------------------------------------

  • Nice point mentioned by GilaMonster

    but nice question Andy. Thanks for sharing !!!

  • GilaMonster (6/19/2014)


    The problem, however, is that statistics IO lies any time there are scalar UDFs in use. The profiler trace doesn't.

    This.

Viewing 15 posts - 1 through 15 (of 33 total)

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