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?
This remains unanswered, ANTS et el do not do this, considering just answering no and accepting it.
解决方案
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.