CODEWITHSUNDEEP
.netsql-serverado.net
Kyle
Kyle

Reputation: 23

Logging Database Access Through ADO.NET

We have a legacy ASP.NET web application that executes many stored procedures via ADO.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.

Upvotes: 2

Views: 1821

Answers (2)

Nicholas Carey
Nicholas Carey

Reputation: 74187

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.

Upvotes: 1

Joe Ratzer
Joe Ratzer

Reputation: 18549

Logging - Log4Net

SQL Profiling - built-in SQL Server Profiler

Upvotes: 2

Related Questions