I had previously outlined a problem with nHibernate code that, in my opinion, was going to cause a lot of problems on production systems especially with memory and the procedure cache. However, it does appear that there is a possible solution. That doesn’t eliminate my concerns over nHibernate, but it sure does help.
I copied my post here
http://nhforge.org/wikis/howtonh/tuning-queries-with-ms-sqlserver.aspx
Feel free to complete the page.