Link to home
Start Free TrialLog in
Avatar of gvamsimba
gvamsimbaFlag for United Kingdom of Great Britain and Northern Ireland

asked on

SQL Server 2008 profiler

Hi, I have to find out all the stored procedures being called from my application (.net).
But currently my profiler is showing me all the users activity details as the application is being
used by many users. But I just want to filter on my activities.

I am planning to filter based on spid's, but not sure how the application assigns the spid's.

Can any one let me know if this is a good idea or is there any better idea than this to filter
only my activities ?

Many Thanks
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

If you are using a different login, then probably you can filter the activities based upon your user name in Profiler trace.
Or else, if you are hitting the DB Server from your system which has the application client, then you can filter the trace based upon your hostname to filter your events only.
Avatar of gvamsimba

ASKER

hi thanks, but how can I find the hostname in sql server  profiler ? I cannot see any column by that name ?
hi, i got the column hostname, but my .net application is not passing my acutal hostname,
it is just passing a generic name for all users.

is there no way in sql server profiler that I can filter on my own events ?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Kumaraswamy R
Kumaraswamy R
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.dm_exec_procedure_stats'.
dm_exec_procedure_stats was introduced from SQL Server 2008 onwards.
gvamsimba,

If your application is not using Hostname properly and you are using a generic login, then without shutting down all other users you cannot identify the events for your session alone.