Reading, Writing, and Riskmetic

Question

Reading, Writing, and Riskmetic

Viewing 3 posts - 31 through 33 (of 33 total)

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

Carpe Datum SSC Enthusiast Points: 199 More actions · Answer 1

david.gugg (6/19/2014)
GilaMonster (6/19/2014)
OCTom (6/19/2014)
What gives? I thought all of us developers got admin rights!?!? :laugh:
On dev servers, I'm very happy to give developers db_owner of the DB they're working in, alter trace, show plan and view server state. I will teach them the best ways to use Profiler (hint, server side trace), I will teach them DMVs, I will explain execution plans. Then they don't have to come to me for every single thing they want to do on dev. Having to do so irritates developers and wastes my time.
Production, same rights as normal users, unless there's a good reason.
I'm kind of torn on this one.. would you do this if there was a development team of 100+ devs? Trying to keep track of who is trustworthy enough for whatever access can be challenging. Additionally, one hour of downtime for the DEV environment is 100+ hours of downtime for all development put together.

With 100+ devs there must be some kind of dev team hierarchy that you can delegate this problem to - make it the team's problem to determine who has what access. Ensure the backups are there for when they get it wrong (as everyone does sooner or later).

Also, if you have 100+ devs working in the database (and not on other layers), on the same database, on the same branch/version of the same project, then I reckon you (as an organisation) have bigger problems than DB permissions...

Igor Micev SSC-Dedicated Points: 33110 More actions · Answer 2

The question "... so he can see the reads/writes used by his queries ..."

Info for logical, physical, read-ahead, ... is given.

What about the writes?

I set

SET STATISTICS IO

and made thousand of inserts in a table and then update of all. I cannot see information about the writes ?:unsure:

Igor Micev,My blog: www.igormicev.com

Igor Micev SSC-Dedicated Points: 33110 More actions · Answer 3

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.

Thanks for this Gail!

Igor Micev,My blog: www.igormicev.com