有没有什么办法可以让.NET堆栈跟踪在SQL事件探查器或类似工具?堆栈、有没有什么、类似、事件

2023-09-05 23:00:28 作者:再见,别再见

在我的previous的工作,我设计并帮助建立一个运行时间(生产)的探查工具这在其他很酷的功能是能够给我的.NET堆栈跟踪的执行的每一个SQL语句。把它看成是对类固醇的SQL Server事件探查器。因此,而不是只看到SQL语句和持续时间,你也得到了其中的SQL执行的情况下。在开发数据库中心的应用程序,我觉得这个信息是上帝发送。

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.

现在的问题是,由于这是我研制previous公司已收购赛门铁克,虽然该工具仍是可下载的,这是非常清楚的牌是什么,它​​不是SKU Symnatec卖。

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.

我想知道是否有人知道的任何类似的工具,这将使我的堆栈跟踪我的SQL语句执行?

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

这仍然没有答案,蚂蚁等EL不这样做,考虑到只是回答没有,并接受它。

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

推荐答案

我不知道这是否会做excatly你所需要的,但最好的分析工具我已经找到。NET是的蚂蚁探查,如果​​我还记得它会告诉你的SQL和所有的.NET的电话。

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.