Ayende @ Rahien

Hi!
My name is Oren Eini
Founder of Hibernating Rhinos LTD and RavenDB.
You can reach me by phone or email:

ayende@ayende.com

+972 52-548-6969

, @ Q c

Posts: 5,953 | Comments: 44,409

filter by tags archive

NH ProfWhy you should use it


This is a screen shot one of NH Prof’s users has sent me:

image

A picture is worth a thousand words, I believe is the saying. But in this case, I think it is worth about 1755 queries.

More posts in "NH Prof" series:

  1. (09 Dec 2010) Alert on bad ‘like’ query
  2. (10 Dec 2009) Filter static files
  3. (16 Nov 2009) Exporting Reports
  4. (08 Oct 2009) NHibernate Search Integration
  5. (19 Aug 2009) Multiple Session Factory Support
  6. (07 Aug 2009) Diffing Sessions
  7. (06 Aug 2009) Capturing DDL
  8. (05 Aug 2009) Detect Cross Thread Session Usage
  9. (22 May 2009) Detecting 2nd cache collection loads
  10. (15 May 2009) Error Detection
  11. (12 May 2009) Queries by Url
  12. (04 Feb 2009) View Query Results
  13. (18 Jan 2009) Superfluous <many-to-one> update
  14. (18 Jan 2009) URL tracking
  15. (10 Jan 2009) Detecting distributed transactions (System.Transactions)
  16. (06 Jan 2009) The Query Cache
  17. (05 Jan 2009) Query Duration
  18. (24 Dec 2008) Unbounded result sets
  19. (24 Dec 2008) Row Counts

Comments

Fabio Maulo

4 minutes was not enough to understand that something should be studied more deeper ?

Frank Quednau

More than 6 alerts per entity? Amazing...

Ike
Ike

I believe this qualifies as "studying deeper"

George

A picture is worth a thousand words...

..and you seem too selfish, which is more that a thousand words indeed.

configurator

isn't Select N+1 when you select entity after entity, each in its own query?

Then how can you have 890 select N+1s with only 501 entities loaded?

Also, why would there be a large number of individual writes for a select?

Maybe it's because I don't know NH or NHProf, but I don't think I understand this picture fully.

zoltan

@configurator:

Select n+1 means you're executing the same select statement several times in a session, selects that probably return the same entities. So nothing wrong with the screenshot. Also in the same session he is doing some updates.

Erik van Brakel

This is exactly what my experience was with using NHProf, although less severe. Usually it's not hard to figure out what's happening (or at least get a gut feeling), but with NHProf it's so easy to spot the errors! I was hesitant at first, but when the possibility to use it for Java Hibernate seemed to be possible I was sold ;-)

Brian Henderson

One step forward, two back.. (i.e. One db call, for every 2 alerts) something wrong with this picture. (1735/3534)

Comment preview

Comments have been closed on this topic.

FUTURE POSTS

No future posts left, oh my!

RECENT SERIES

  1. The RavenDB Comic Strip (3):
    28 May 2015 - Part III – High availability & sleeping soundly
  2. Special Offer (2):
    27 May 2015 - 29% discount for all our products
  3. RavenDB Sharding (3):
    22 May 2015 - Adding a new shard to an existing cluster, splitting the shard
  4. Challenge (45):
    28 Apr 2015 - What is the meaning of this change?
  5. Interview question (2):
    30 Mar 2015 - fix the index
View all series

Syndication

Main feed Feed Stats
Comments feed   Comments Feed Stats