SQL Profiler

Question

SQL Profiler

TRACEY-320982

SSChampion

Points: 13653
More actions
March 26, 2009 at 5:10 pm

#202290

Is there a way to give this to developers so they can preform sql profiler traces....without actually having puttint them as sysadm SA rights.
Thanks

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

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

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

You need to give them the developer edition it is under $50 online because Profiler uses a lot of memory so it is best run on the developer and test boxes and not production.

Kind regards,
Gift Peddie

Andy Hogg SSCarpal Tunnel Points: 4585 More actions · Answer 2

I'm pretty sure that you cannot give your developers the ability to use profiler without also giving them SysAdmin rights.

TRACEY-320982 SSChampion Points: 13653 More actions · Answer 3

Enterprise version is what we have and this is for development.

Too bad on the profiler....

Gift Peddie SSC Guru Points: 73570 More actions · Answer 4

Code must be profiled so if this is development server you either do the job or ask for developer edition from IT for the developers because even in software engineering companies developers are DBO in development server with developer edition on their desk top.

Kind regards,
Gift Peddie

SA-1 SSCrazy Eights Points: 8113 More actions · Answer 5

You need to give them Alter Trace permissions

GRANT ALTER TRACE TO

Andy Hogg SSCarpal Tunnel Points: 4585 More actions · Answer 6

I stand corrected - thank you SA.

On SQL Server 2000 you needed to be a SysAdmin to run profiler, but this is no longer the case on 2005 & 2008.

I learn something new every day!

TRACEY-320982 SSChampion Points: 13653 More actions · Answer 7

Grant trace to user

How to do this in GUI i just need to see the little tick too

Oh it in the securables....for the login.

Cheers that great.

They did ask to be an owner for master too - not sure why i just gave data reader. Any got any clue why they want to be an owner?

Gift Peddie SSC Guru Points: 73570 More actions · Answer 8

GRANT ALTER TRACE TO [MyDomain\User1];

You could just run the above in management studio.

Kind regards,
Gift Peddie

TRACEY-320982 SSChampion Points: 13653 More actions · Answer 9

Is there a command i can run to see the permissions he has.

When you go back into studio and look at secruables it blank so you can't see if unless you do add...then back to all objects server they then appear in the box and it is ticket...long winded.

Cheers

SA-1 SSCrazy Eights Points: 8113 More actions · Answer 10

You will need some sort of entitlement scripts for pulling out all those permissions.

TRACEY-320982 SSChampion Points: 13653 More actions · Answer 11

I will work on that script. Thanks for the advice on profiler that made my day.

Activity Monitor - Don't suppose you know if there a way just for this either 🙂 Developers want this too but i can't because don't know how without giving sa rights.

Cheers.............

Gift Peddie SSC Guru Points: 73570 More actions · Answer 12

If I understand you what you are looking is covered by Microsoft below.

http://msdn.microsoft.com/en-us/library/ms186717.aspx

http://msdn.microsoft.com/en-us/library/ms187611.aspx

Kind regards,
Gift Peddie

SA-1 SSCrazy Eights Points: 8113 More actions · Answer 13

You need to grant View Server State for Activity Monitor.

TRACEY-320982 SSChampion Points: 13653 More actions · Answer 14

TRACEY-320982

SSChampion

Points: 13653

March 27, 2009 at 8:21 am

#967473

Thanks everyone.