sql server profiler

Hi,
I'm just investigating a very complex issue in my VB application and this application is calling many stored procedures at various stages. What I wanted to do is as I debug through each calling stroed procedure I wanted to see what is being passed to that procedure and what is being produced by the SP as a result of those passed in values. I thought I might use SQL Server Profiler to help me do that but I never use this tool before so can someone, tell me how do I set this up with my application so I will be able to see what happening in the database as I step through the application source code.
ube100Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Since you mentioned that you are a beginner, this would help you out in basic configurations of SQL Server Profiler..

http://rameshch.wordpress.com/2008/12/11/how-to-set-up-a-sql-server-2005-profiler-session/

Just select these events in Profiler:

* SP: Starting
* SP: Ending

to find out the values passed to your procedure..
Kindly let me know if I need to explain any in more detail..
0
ube100Author Commented:
My question is, say, in my organisation we may have hundred of users using the same database any given time so I just wanted to see only response from my action on the application rather than seeing every response which come directly from other users in the organisation. As I set this up I could see there are lots of things going on on the profiler so can I restrict these to just specific to my action? If I can How?
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> I just wanted to see only response from my action on the application

Yes.. You can filter it only for your login.
If you are using individual logins ( eg., Windows Logins or individual SQL Logins) then its very easy..

I will add things in addition to the link provided earlier..
1. Go to step No. 5.
2. In Edit Filter, they are currently editing DatabaseName. Instead of DatabaseName choose LoginName and in the Filter clause, specify it to filter out only for your Login.

This would display events only for your Loginname and rest would be filtered out in the profiler trace..

If you are using a shared login, then check whether any combination of the filters available over there would make it unique so that you can filter only for your login..

Hope this clarifies.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.