How can i look at executed queries?

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 envir开发者_Go百科onment. Windows Server 2008 Enterprise MOSS 2007 SQL Server 2008 Enterprise Visual Studio 2008 with VSeWSS 1.2

Thank you in advance. Taiga

---

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.

---

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.

---

In the article itself they mention which profiling tool they use

http://www.dynatrace.com/en/application-performance-management-product.aspx