NHibernate Profiler a real time-saver

It’s great for several reasons. I’ll try and cover some of them briefly

1. It detects possible problems with your configuration / mappings and this is fantastic. You spot those N+1 and Unbounded result sets before someone complains about a crash or performance issues.
2. It outputs the SQL in a very understandable and readable format. I never could stand watching the SQL Profiler.
3. It tells you about internal NHibernate errors. I spent too much time opening management studio trying to see if things ended up in the database or not. If there is an error it’s likely I don’t have to bother.
4. It tells you if a query was read from the cache or database. I had some implementation problems that cause my queries to always be fetched from the database without nh prof it would have taken me some time to figure out why.
5. It is so easy to use. Add a reference to the Appender.dll and make sure you run Initialize() on the chosen profiler and your done.

Try it out http://nhprof.com/download