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