How to know the number of queries made to DB?

Mihcom · **Joined:** Thu May 04, 2006 8:21 am **Posts:** 4

Where can I know the number of queries to DB made during the Session? This will be very helpful for optimization purposes.

Thank you.

deepakbadki · **Joined:** Thu Aug 24, 2006 2:05 am **Posts:** 80

If you are using SQL 2000/05 Server then use query profiler to see the queiries fires by nHibernate

Steps to Run Profiler:

1.Run Profiler available in Program Files->Microsoft SQL Server ->Profiler
2. GO to File->New Trace
3. Run the trace and see the queries fired :)

All the best.

Mihcom · **Joined:** Thu May 04, 2006 8:21 am **Posts:** 4

:)

Thank you, but I meant other thing.

I was wondering - if Session or Transaction contains a counter for runned queries - but I couldn't find such counter in code. I want to show the number of queries to DB in the footer of the page.

guymahieu · **Joined:** Sat Sep 09, 2006 5:55 am **Posts:** 23

I thought I saw in the roadmap that Statistics were going to be ported from Hibernate for the 1.2 release (can't check now 'cause jira seems to be down atm).

More info on statistics for (java) hibernate can be found here:
http://www.javalobby.org/java/forums/t19807.html

Update: seems like I was wrong, there is an issue for it in Jira (http://jira.nhibernate.org/browse/NH-786), but it is not planned and seems to be postponed even.

anuarneto · **Joined:** Fri Oct 20, 2006 8:02 am **Posts:** 36

may be lgo4net can solve your problem.

Mihcom · **Joined:** Thu May 04, 2006 8:21 am **Posts:** 4

Maybe - if I intercept log4net output and analizy it with regular expressions to detect queries to DB :)

My target it to show in the page footer something like "Page generated in 0.134 sec (12 queries to DB)". I already show the page generation time and trying to solve the second one task - number of queries to DB :)