Sql CE 的探查器 [英] Profiler for Sql CE

问题描述

我想知道是否有类似于 Sql Server Compact Edition 的 Sql Profiler 的东西?我使用 SqlCE 作为桌面应用程序的后端，如果有类似 sql profiler 之类的东西用于这个嵌入式数据库，那就太好了.或者至少类似于 NHibernate show_sql 功能的东西......有任何想法吗?谢谢j.

i wonder if there is something similar to Sql Profiler for Sql Server Compact Edition? i use SqlCE as backend for a desktop application and it would be really great to have something like sql profiler for this embedded database. or at least something simliar to the NHibernate show_sql feature... any ideas? thanks j.

推荐答案

我所知道的唯一可以解决这个问题的经过测试的解决方案是 Altiris Profiler 这是我在上一份工作中设计的工具，但是是封闭源代码且不出售.

The only tested solution I know of that could solve this problem is Altiris Profiler which is a tool I designed at my previous job, but is closed source and not-for-sale.

您将其连接起来的方式是为您的命令创建一个工厂，并在使用它们之前(使用 RealProxy)代理它们以进行分析.它的重量非常轻，大约需要 10 行代码来实现.

The way you would hook it in, is by creating a factory for your commands and proxing them for profiling purposes before using them (using RealProxy). Its really light weight and about 10 lines of code to implement.

关于 我的问题 Flory 谈到了一个名为 dynaTrace 的新工具或许也能解决这个问题.

On my question Flory talks about a new tool called dynaTrace that may also be able to solve this problem as well.

这篇关于Sql CE 的探查器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！