Search code examples
asp.net-mvc-3entity-framework-4benchmarkingsql-server-2008-express

View all queries


I got a MVC3 application using Entity Framework 4 and SQL Server.

How can I view all queries that has been invoked (and the amount of time that they took)?


Solution

  • Use the sql profiler, it will give you all this information and more. Won't require any code changes either.

    Heres a link to a free one if you don't have the full toolset.

    http://sites.google.com/site/sqlprofiler