Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 309
  • Last Modified:

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.
0
ube100
Asked:
ube100
  • 2
2 Solutions
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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 & ArchitectCommented:
>> 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

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now