Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is there any way I can get .net stack traces in Sql Profiler, or a similar tool?

In my previous job I designed and helped build a run-time(production) Profiler tool that among other cool features was able to give me .Net stack traces for every SQL statement that executed. Think of it as SQL-Server Profiler on steroids. So instead of just seeing SQL statements and duration, you also got the context in which the SQL executed. When developing DB centric apps I find this information a god-send.

The problem is that since this was developed my previous company has been acquired by Symantec, though the tool is still downloadable , it is very unclear what the licensing is and it is not SKU Symnatec is selling.

I was wondering if anyone knows of any similar tools that will give me Stack Traces with my SQL statement executions?

alt screenshot http://img151.imageshack.us/img151/4357/profiler1jz3.gif

This remains unanswered, ANTS et el do not do this, considering just answering no and accepting it.

like image 617
Sam Saffron Avatar asked Nov 06 '22 22:11

Sam Saffron


1 Answers

I am not sure if it will do excatly what you need but the best profiling tool i have found for .Net is ANTS Profiler, If i remember it will show you the SQL and also all the .net calls.

like image 160
TheAlbear Avatar answered Nov 12 '22 17:11

TheAlbear