What I need is to count total number of database calls and time taken for its execution for a single web request for my ASP.NET application.

I'm trying to investigate performance problem with my ASP.NET web application. Among other approaches the one I use is adding response processing basic statistics directly into IIS log record (using Reponse.AppendToLog method):
- total time taken between BeginRequest and EndRequest
- (? how ?) total count of database calls
- (? how ?) total database calls time taken

The problem is that cannot figure out a way to count actual database calls and time the take.

Any ideas?

No ideas? I can't imagine that nobody worries about actual database calls...

Hey, hibernate gurus...

if use sql server you can use Sql Server Profiler to trace your queries.

Yes NHibernate has performance problems. I just wrote in my own thread why and how to solve it: http://forum.hibernate.org/viewtopic.ph ... e38759064b

The question was not about SQL profiler or any other methodology of optimizing performance. I know what to do here - there is not question here.

All I asked is a way to log each REAL database call from hibernate to my SQL server and the time it's taken. That is the question. This is the part of my performance analysis strategy (along with all other things).

Actually, I found who to do it - you need to:
1) create your own Driver class (I wrapped standard SqlClientDriver class) 2) override CreateCommand() method in it
3) return your own implementation of IDbCommand class in it (again, just a wrapper around standard SqlCommand)
4) make needed logging around inside methods Execute...() - around calls to SqlCommand methods.

Did you find a cause other than the fact that GetOrdinal is called on every cell you ever fetch from the Database? I would be interested into what you found out since I also want to improve performance as much as possible :)