我如何查看执行的查询？
谁能告诉我如何查看 SharePoint 中执行的查询？ 我找不到使用 SQL Server 显示查询日志的方法。 如您所知，SharePoint 框架向程序员隐藏了所有查询。 我想研究这些查询并了解其机制。
http://www.infoq.com/articles/SharePoint-Andreas-Grabner 在上面的文章中，我可以看到一些显示方法和参数（查询）的窗口。 但我无法弄清楚这个窗口来自哪里......（看起来像来自 Visual Studio 的窗口） 有谁知道如何显示这个窗口？或者任何显示执行查询的替代方法？
我的工作环境。 Windows Server 2008 企业版 苔藓2007 SQL Server 2008 企业版 带有 VSeWSS 1.2 的 Visual Studio 2008
提前致谢。 大河
can anyone tell me how to view executed queries in SharePoint?
I couldn't find a way to show query logs with SQL Server.
As you know, SharePoint framework hides all queries from programmers.
I would like to look into the queries and understand the mechanisms.
http://www.infoq.com/articles/SharePoint-Andreas-Grabner
In above article, i can see some windows showing methods and arguments(Queries).
But i could not figure out where this window come from...(looks like a window from visual studio)
Does anyone know how to show this window? or any alternative way to display executed queries?
My working environment.
Windows Server 2008 Enterprise
MOSS 2007
SQL Server 2008 Enterprise
Visual Studio 2008 with VSeWSS 1.2
Thank you in advance.
Taiga
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
SQL Server 分析将允许您在数据库级别记录查询。您需要优化针对 SharePoint 数据库执行的查询的跟踪。
SQL Server Profiling will let you log queries at a database level. You'd want to refine your trace to queries executed against the SharePoint database.
您可以在运行和访问共享点服务器时使用 SQL Server Profiler 并分析服务器。这将创建一个跟踪文件/表，使您可以查看执行了哪些查询。
You could use SQL Server Profiler and profile the server while running and accessing the sharepoint server. This will create a trace file/table that will allow you to see what queries were executed.
在文章本身中，他们提到了他们使用的分析工具
http://www .dynatrace.com/en/application-performance-management-product.aspx
In the article itself they mention which profiling tool they use
http://www.dynatrace.com/en/application-performance-management-product.aspx