?
Solved

sql server profiler

Posted on 2010-01-09
3
Medium Priority
?
301 Views
Last Modified: 2012-05-08
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
Comment
Question by:ube100
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 1000 total points
ID: 26272885
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
 

Author Comment

by:ube100
ID: 26273058
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
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 1000 total points
ID: 26273073
>> 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question