Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Profiler for .NET like SQL profiler?

Posted on 2013-05-23
7
Medium Priority
?
225 Views
Last Modified: 2013-06-02
In SQL we run profiler to identify what are the SPs are being hit and what parameters are passed to the method.

Likewise is there any easy way to identify .net application what are the methods are being hit and what parameters are passed to the methods?

By debugging the application and using Log file writing in each method we could accomplish this. Other than that any tool or any other method is in place? If you know please do share.
0
Comment
Question by:Easwaran Paramasivam
[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
  • 2
  • 2
  • +1
7 Comments
 
LVL 64

Expert Comment

by:Fernando Soto
ID: 39191449
Hi  EaswaranP;

When debugging your application you can hover over a variable to see its value. If you want to know who called the current function you are in open the Call Stack window and it will have all the methods that were called and if you double click on a method and hover over a variable you will see the value as it was before the next function was called.
0
 
LVL 11

Expert Comment

by:madgino
ID: 39194244
0
 
LVL 40
ID: 39197860
Same as the SQL profiler is provided only in higher end editions of SQL Server, there is a code profiler in the Premium and Ultimate editions of Visual Studio, but not in Express and Professional.

In these, as suggested by madgino, your only solution if to use tracing. You have to build the whole thing yourself however, and doing so for a complete application can be a pain.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 16

Author Comment

by:Easwaran Paramasivam
ID: 39198593
http://msdn.microsoft.com/en-us/library/bb386420(v=vs.100).aspx speaks about asp.net application. But my applications are Windows Application, WPF applications.
0
 
LVL 40
ID: 39199038
When you see System.Diagnostics somewhere, you  are dealing with the framework debugging features. It works in any kind of application. So System.Diagnostics.Trace also works in Windows and WPF applications.

You can also use System.Diagnostics.Debug, an alternative class to do the same thing. Except for a couple of properties and methods, Debug and Trace are interchangeable.
0
 
LVL 11

Accepted Solution

by:
madgino earned 1500 total points
ID: 39199156
As James said, tracing and debug works for WPF too, here are some links that might help:
http://msdn.microsoft.com/en-us/library/dd409960.aspx
http://msdn.microsoft.com/en-us/library/aa969767.aspx
0
 
LVL 16

Author Closing Comment

by:Easwaran Paramasivam
ID: 39214833
Thanks.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

604 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