Logging Database Access Through ADO.NET

We have a legacy ASP.NET web application that executes many stored procedures via ADO.开发者_JAVA技巧NET. Can anyone recommend a profiling tool or a straightforward method to log these database calls client-side when they occur?

I appreciate any tips.

Logging - Log4Net

SQL Profiling - built-in SQL Server Profiler

Log4Net won't work if the app isn't already instrumented with it.

SQL Profiler is server-side and impacts sql server performance.

You should look at ADO.Net Trace Logging: http://msdn.microsoft.com/en-us/library/aa964124(SQL.90).aspx

I believe it will do what you need to do.