• 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
    🙂