Geek Answers Handbook

Is there any tool to view database queries?

Is there any tool that will check the asp.net or sql server and report all requests that run in the database? The reason why I ask, I use Linq for the project and I want to double check what it really does for each page.

Ideally, I would like to view the page in a browser and get a report of all the requests that were launched to create this page.

I know that I can see the SQL that it runs for individual queries using debugging / breakpoints, and I know about LinqPad, but I'm afraid that Linq makes a few more queries on its own to get related data, which may not be directly aware. Is there anything (tool / program / report / etc) like what I described? Thanks!

EDIT: Is there any free tool that can do this? I am using Sql Server 2008 Express and unfortunately do not have SQL Profiler.

+5
source share
7 answers

, SQL, SQL Profiler. .

, Profiler TechRepublic.

NHibernate Profiler. , "", SQL Profiler, , .

+14

- , .

"exec sp_who", "dbcc inputbuffer (111)" - 111.

+3

SQL Profiler .

+2

SQL Server Express, ?

Microsoft SQL Server 2005/2008 Express Edition

Microsoft SQL Server -, , , . , SQL . - . SQL Server Express Edition Profiler , , .. .

+1

LINQ to SQL ASP.NET - (, Northwind.Dbml):

NorthwindDataContext context = new NorthwindDataContext();
context.Log = Response.Output;

. , ..

+1

LINQ to SQL, DataContext.Log TextWriter, , ( ) log4net.

:

, L2S, ... .

0

This one is free only for the first 45 days, but it gives you profiling / runtime logging with a set of filter options, SQL Server query execution logging, etc. Built specifically for profiling L2S ​​applications:

http://www.huagati.com/L2SProfiler

0
source

More articles:


All Articles