How to catch database calls without Profiler ?

Question

Post reply

How to catch database calls without Profiler ?

SQL Guy 1

SSCoach

Points: 15817
More actions
July 30, 2010 at 7:33 am

#221975

We are not given sysadmin permissions on some server, but we need to get all database calls from a certain application, like stored procedure names along with their parameters as well as timing.
Is it possible through some DMVs or maybe DBCCs ?
Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

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

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

Hi,

I think that you should be able to run Profiler if you are just given the "Alter Trace" permission.

You do not need to be a SysAdmin.

Hope that helps.

SQL Guy 1 SSCoach Points: 15817 More actions · Answer 2

But unfortunately, we are not given APTER TRACE permissions.

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

Ask for it? Or ask the DBA to set up the traces for you. That's about the only way you're going to get what you need.

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

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

I agree with Gail.

I believe that in SQL Server 2000 it was necessary to be a member of the sysadmin role in order to use Profiler.

In SQL Server 2005 onwards, to their credit Microsoft, have listened to customers' feedback and granularised the permissions required to run Profiler.

Now it is very easy for your DBA to grant the ability for you to utilise this tool without compromising security.

Srinivas Sista SSC Enthusiast Points: 193 More actions · Answer 5

HI,

weher do we find this roles Alter trace is it either Database roles or server role.

Thanks,

Srinivas

Steve Jones - SSC Editor SSC Guru Points: 734459 More actions · Answer 6

Neither, it's a permission

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/ccd281ca-b975-4107-8224-b1f57fa5163e