有什么方法可以在 Sql Profiler 或类似工具中获取 .net 堆栈跟踪吗？
在我之前的工作中，我设计并帮助构建了一个运行时（生产）探查器工具，除了其他很酷的功能之外，它还能够为我提供每个执行的 SQL 语句的 .Net 堆栈跟踪。 可以将其视为增强版的 SQL-Server Profiler。 因此，您不仅可以看到 SQL 语句和持续时间，还可以获得 SQL 执行的上下文。 在开发以数据库为中心的应用程序时，我发现这些信息是天赐之物。
问题是，自从开发了这个工具以来，我以前的公司已经被赛门铁克收购了，尽管该工具仍然可以下载，但目前还不清楚许可是什么，而且也不是 Symnatec 销售的 SKU。
我想知道是否有人知道任何类似的工具可以为我提供 SQL 语句执行的堆栈跟踪？
替代屏幕截图 http://img151.imageshack.us/img151/4357/profiler1jz3.gif< /a>
这仍然没有得到答复，ANTS 等人不会这样做，考虑只是回答“否”并接受它。
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.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
我不确定它是否能完全满足您的需要，但我为 .Net 找到的最好的分析工具是 ANTS Profiler，如果我记得的话，它会向您显示 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.
我们最近推出了一个名为 dynaTrace 的工具。 有一个工作站版本，您可以在一台机器上使用，还有一个服务器/代理版本，可以在多个机器上运行。
基本上，您可以针对特定应用程序（或 IIS）设置该工具。 之后，它将收集对其进行检测的方法调用。 在您的场景中，您可能会针对整个名称空间进行检测并获取所有内容。
基本上，它会使用 IL 注入来跟踪每个方法调用。 它通过针对 ADO.Net 进行检测来获取数据库调用，包括 SP 中的绑定变量。 显然它也可以跟踪 Web 服务调用。
它非常酷，因为您可以查看特定方法，查看调用该方法的所有路径，或者查看对某个方法的所有调用。 您可以查看特定的数据库调用，并查看该调用的所有代码路径。
它太酷了。
We have recently starting a tool called dynaTrace. There is a workstation verison that you can use on one box and a server/agent version for operating against many boxes.
Basically, you set up the tool against a particular application (or IIS). After that it will collect method calls that it is instrumented against. In your scenario you might instrument against entire namespaces and get everything.
Basically it then tracks every method call by using IL injection. It picks up the database calls by instrumenting against ADO.Net including the bind variables in SP's. It can apparently track across Web Service calls as well.
It is pretty cool in that you can look at specific methods, see all the paths that were made to call that method, or look at all calls to a method. You can look at a specific database call, and look at all the code paths with that call.
It's pretty cool.
我在这里发布了一个答案，其中汇集了几篇文章的信息，以及一个可以用作 MySQL 的穷人查询监视器的应用程序：
如何查看实时 MySQL 查询？
I've posted an answer here that brings together info from a couple of posts, plus an app that can be used as a poor mans query monitor for MySQL:
How can I view live MySQL queries?