.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

.Net Profiler

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :ASP.Net


Everyone may know about sql profiler, I need to know Is any tool available for Asp.net ?

My running website is sometimes getting too slow, So that I want to know where it happen. Also My Higher person asking Profiler report. Can anyone tell me how it looks?

please help me...

View Complete Post

More Related Resource Links

Performance: Find Application Bottlenecks with Visual Studio Profiler


We will introduce you to the Visual Studio Profiler by walking through a sample performance investigation, pinpointing code inefficiencies in some sample applications.

Hari Pulapaka and Boris Vidolov

MSDN Magazine March 2008

Extreme ASP.NET: Tools of the Trade: SQL Server Profiler and Query Analyzer


In my last column, I discussed Microsoft® Application Center Test and how it could be used to measure the performance of your Web application (see Extreme ASP. NET: Tools of the Trade: Application Center Test).

Rob Howard

MSDN Magazine August 2005

CLR Profiler: No Code Can Hide from the Profiling API in the .NET Framework 2.0


The common language runtime (CLR) profiling API makes available information about the application domains, assemblies, and classes that are loaded and used in a process, just-in-time (JIT) compiler notifications, memory usage tracking, tracing of events, exception tracking, managed to unmanaged code transitions, and the state of the runtime. And if that weren't enough, you will find a nicely enhanced profiling API in the .NET Framework 2.0. Find out what's coming up in this next version.

Jay Hilyard

MSDN Magazine January 2005

Design: Inspect and Optimize Your Program's Memory Usage with the .NET Profiler API


Developers using .NET often make memory leak tracking a low priority because the common language runtime takes care of garbage collection. What few developers realize, however, is that their objects' lifespans, along with their size and what other objects have been instantiated, all affect how they are cleaned up. Depending on the particular circumstances, these combinations can negatively affect performance, especially over the lifetime of an application. This article presents a way for developers to see memory usage and understand garbage collection using the .NET Profiler API. Along the way, a sample application to demonstrate these principles is built.

Jay Hilyard

MSDN Magazine January 2003

adding filter to sqldiag profiler trace

Hi everyone I'm wanting to create some standard diagnostics scripts for SQL Server 2005 installations and sqldiag seems the most logical way to do this. However, I want to be able to add filters to ProfilerCollector so that I can capture data for a specific database, application, etc. I've searched but can not find any information on either adding filters - which I suspect that you can not do - or specifying filters by using the template attribute.  However, Profiler itself does not seem to export templates as .xml which is the format of the default file specified for the template attribute! Does anyone know if adding filters is possible, by whatever mechanism, and if so does anyone have any examples?  It would be very much appreciated. thanks, and regards Simon

How to set a default location for saving Profiler templates

How do you change the default location for saving Profiler templates.  I've done this before, but don't recall how.  And now I'm trying to setup 2008 to reference a network location vs. the local hard drive on my PC. Thanks,  Dave

Using CLR Profiler with ASP/ASP.NET Hybrid Website

I've heard how great the CLR Profiler can be when trying to track down memory leaks, and I'd love to use it on my modifications to a website.  I've read through the documentation and I was under the impression that I could use the Profiler without too much trouble.  However, I can't seem to get it working, so some help would be greatly appreciated. Here's the situation: The website I've modified was originally Classic ASP.  Only the new modules are coded in ASP.NET.  I start the CLR Profiler and it asks me to start my ASP.NET project, which I do through localhost.  I bring up the website (Classic ASP login screen) in Internet Explorer, log into the site, and then start hitting the ASP.NET pages.  However I don't see any output for the CLR Profiler, I can't click the Kill Application button, and the "Waiting for ASP.NET to start common language runtime - this is the time to load your test page" message never disappears. I saw a note that I might need to change my machine.config to use System, but making that change doesn't seem to resolve the problem.  What could be my problem?  Will the CLR Profiler simply not function with my website? Also, if it's important, I used Visual Studio 2010 to develop the pages. Thanks in advance!

CLR Profiler for the .NET Framework 2.0 : A bug (with possible fix!) - It throws exception - null ob

CLR Profiler for the .NET Framework 2.0   I tied to profile a service on my machine. But when I try to see the heap data (during reading of the log file) it throws exception that the object reference is not set (null object).   I debugged the CLR profiler and found that in class ReadNewLog, there is method "ReadFile" internal void ReadFile(long startFileOffset, long endFileOffset, ReadLogResult readLogResult, int requestedIndex) ...     if (matched > 0 && c != -1)     {         /* use some other stack trace as a reference */         int otherStackTraceId = ReadInt();         otherStackTraceId = stacktraceTable.MapTypeSizeStacktraceId(otherStackTraceId);         int[] stacktrace = stacktraceTable.IndexToStacktrace(otherStackTraceId);         if (matched > stacktrace.Length - hadTypeId)             matched = stacktrace.Length - hadTypeId;         for(int i = 0; i < matched; i++)         {             int funcId = stacktrace[i + hadTypeId];             Debug.Assert

SQL Server 2008 Profiler--Templates Missing

For some reason (even after an uninstall, reinstall and updating the the Community Update) there are no templates visible in the Profiler for SQL Server 2008. On another system it works fine but the Trace Provider Type shows "Microsoft SQL Server 2008". On the problem system it shows "Microsoft SQL Server 10.0".   What's up?

performance test: Sql profiler recorded 8 seconds but only far less than 1 seconds executed in Manag

hi, all. I used sql profiler to record the long running sql while doing performance test. The performance test simulated 100 curcurrent users. When the test finished, I catched  some long running sql(some are select sql and some are update sql) in the sql profiler and executed them in the Management Studio, all of them finished execution in less than 1 second. I am curious about this. I  know under 100 curcurrent users operation, both Operating System and Sql Server have less resource to execute a given sql, so I thought they would finish execution in about 2 or 3 seconds rather than 8 seconds. I did the same performance test again and during the test, i executed those sql in the management studio. I become even more curious. Thoes sql still executed in less than 1 second. Why? I am new to performance test. Please help me. Thank you.

Stumped - how do you install SQL Profiler?

Hi everyone

I've just installed SQL 2008 Express (I installed the express edition because I need support for user instances).

Now I want to install SQL Profiler. I understand it doesn't come with SQL Express, so I've got the DVD for SQL Server 2008 Enterprise Edition. The problem is that whether I choose "New SQL Installation" or "Add Features to Existing Installation", there's no option to install SQL Profiler. The only client tools that appear in the installation screen are:
- Business Intelligence Development Studio
- Management Tools - Basic
- SQL Client Connectivity SDK.

SQL Profiler's got to be in there somewhere... tearing my hair out!



Which profiler events I need to capture to find out timing out queries?



I understand how can I capture long running quieries based on duration. But I'm trying to figure out how I can do it with quiry which are timing out? For example if ASP.NET executes a query against SQL server and it did not completely within say 60s, will that even be written in profiler as RCP:Completed or it would not be written at all since ASP.NET will kill connection at that point and return error to user?





SQL server 2008 profiler


I am trying to run a trace in the SQL management studio to find out queries taking long time to run. But the when I do the new trace it only lets me select an instance but not a particular DB. How can find out about the quires in  a particular DB.


wpfperf tool Visual Profiler not populating element tree

I'm trying to use the latest version of the Performance Profiling Tools for WPF that are listed here: http://windowsclient.net/wpf/perf/wpf-perf-tool.aspx#profiler

For some reason the element tree is not being populated when I start my app using the Launch Process.  I do see the chart for Application CPU Usage update and scroll by, however I would like to see which elements in particular are eating up CPU time.

Does anyone have a solution?

Perfmon & Profiler with SSAS connection


I want to integrate my perf log results with a SQL Profiler trace.

I have done this countless times with a SQL Server connection (tested again today and it worked). When I try it with an SSAS connection, I receive the Correlation is not possible because there is not intersection ... error.

I am running SQL 2008.
I have tried starting perf log first or starting profiler trace first and get same result.
Perf log is using 1 second intervals since I am on a non-busy test server.
I am using the standard template and there are times in there.
I am only using one computer (shouldn't have time issues not being synchronized with itself)
It works just fine if I try the same thing wiht a SQL Server connection rather than an SSAS connection.

Any ideas?

Ann Weber

sql profiler doesn't show mdx report parameter values


Hi All,

Is there any way that I can afterwards see the members selected as parametervalues in an SSRS report. 

Maybe I'm missing something, but to me its looks as if SQL Profiler is capturing the mdx dataset queries exactly as specified in the report definition, but SQL Profiler does not show the parameter values selected by the end-user.

For analysis puposes I need to figure out what parameter values have been selected by my end-users on report-execution.

Any suggestions/workaround for this ?

Kind regards,



Please remember to mark replies as answers or at least vote helpfull if they help and unmark them if they provide no help.

Profiler trace 'automatically' reset


I'm running a trace based on the SP_Counts template which will help me track all active sprocs in a given database.  My intent was to run the trace 24/7 over the course of several weeks to capture as many sprocs as possible.

Here's my setup:

  -- Server 2:  Profiler is running the trace and collecting sproc usage data from Server 1.

  -- Server 2:  A maintenance database houses the table into which the trace results are saved.

  -- Server 2:  Hourly, a job is run to aggregate the sproc data from the trace table into a different table; the profiler table is then truncated.

What I didn't plan or ask for - and the point of this question - is the trace being reset at around 2:30a every morning.  When I look at the default trace from Server 1, I see the sproc sp_trace_setstatus was called with the TraceID 2 (there are only 2 traces running on my production server; 1 is the default; 2 is my sproc collection trace) and a status of '2' (close the trace and delete trace info) at the time of the reset. 

I've looked over all the jobs I've created between the two servers and there's nothing on either of them running at the time of the reset.  Since I'm dumping the results to a table (and did not limit the number of rows) I don't think the 'max size' property of the trace would matte

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend