Automatically measure all SQL queries

Question

Q Perhaps the normalization is not normal. Jeff Atwood says: "You automatically measure all the requests that flow through your software, right?" I do not, but I would like to.

Some features of the application in question:

• ASP.NET
• data access level, which depends on the Microsoft Enterprise Library data access application block
• MS SQL Server

Answer 1

SQL Profiler, , . , voila, , .

- ORM - , , , !

Answer 2

SQL Profiler - , , SQL Server. SQL Server. SQL Profiler SQL Server SQL Server 2000 (, , ).

.

Answer 3

, -. , : : 8 ASP.NET

Answer 4

Dropthings CodePlex . TimedLog. IDisposable. , , using.

Answer 5

, SQL- , , .

, , , , , / "" mysql.

.

, , .

Answer 6

factory, SqlCommands , , RealProxy SqlCommand.

This proxy server can then determine how long ExecuteReader / ExecuteScalar, etc. take it using StopWatch and register it somewhere. The advantage of using this method over Sql Server Profiler is that you can get full stack traces for every instance of SQL that is executed.