Reading, Writing, and Riskmetic

Question

Reading, Writing, and Riskmetic

Andy Warren

SSC Guru

Points: 119902
More actions
June 18, 2014 at 10:41 pm

#150163

Comments posted to this topic are about the item Reading, Writing, and Riskmetic
Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
June 19, 2014 at 3:00 am

This was removed by the editor as SPAM

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

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

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

rhythmk SSCertifiable Points: 7271 More actions · Answer 2

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
🙂

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

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

Neil Burton SSC-Insane Points: 22995 More actions · Answer 4

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

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 5

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

paul.knibbs SSCoach Points: 15320 More actions · Answer 6

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

free_mascot One Orange Chip Points: 27169 More actions · Answer 7

Thanks for interesting question Andy.

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

Gazareth One Orange Chip Points: 27737 More actions · Answer 8

I might start refusing to answer Andy's questions because I just get annoyed when I get them wrong! 🙂

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 9

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

free_mascot One Orange Chip Points: 27169 More actions · Answer 10

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."

george sibbald SSC Guru Points: 104210 More actions · Answer 11

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 🙂

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

Umer Akram SSC-Insane Points: 22209 More actions · Answer 12

Nice point mentioned by GilaMonster

but nice question Andy. Thanks for sharing !!!

Toreador SSChampion Points: 11365 More actions · Answer 13

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.