1.使用之前需要确认Framework的Version，如果是4.0那么使用如下程序集需要在

    创建ISessionFactory的项目中引用NHProfiler安装目录下的

 HibernatingRhinos.Profiler.Appender.v4.dll

2.在创建ISessionFactory语句前（new Configuration()).Configure().BuildSessionFactory();）插入如下代码

 HibernatingRhinos.Profiler.Appender.NHibernate.NHibernateProfiler.Initialize()

3.然后打开NHProfiler工具，运行项目，左边将显示运行过程中所有NHibernate的Session，右边将显示相应Session的详细SQL语句

备注：NHProfiler是一个针对Nhibernate运行分析的工具

Introduction

NHibernate Profiler is a real-time visual debugger allowing a development team to gain valuable insight and perspective into their usage of NHibernate. The product is architected with input coming from many top industry leaders within the NHibernate community. Alerts are presented in a concise code-review manner indicating patterns of misuse by your application. To streamline your efforts to correct the misuse, we provide links to the problematic code section that triggered the alert

• Cognitive application awareness.
• Visual insight into the interaction between your database and application code.
• Analysis and detection of common pitfalls when using NHibernate.
• Analysis is delivered via perfectly styled SQL and linkable code execution.
• Supports NHibernate 1.2.x, 2.x and 3.x

下载地址：http://www.hibernatingrhinos.com/products/nhprof

Nhibernate工具Profiler配置