As Ayende already said, the NHibernate Profiler is now in public beta. If you're using NHibernate, do yourself a favor and try this tool because it really is great.
Oh, and Ayende has a 30% discount on licenses at the moment... i'd take advantage of that if i were you 