asp.net中获取数据连接的统计信息

protected void Page_Load(object sender, EventArgs e)

    {

        string connString = ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;

        SqlConnection conn = new SqlConnection(connString);

        conn.StatisticsEnabled = true;//如果设置为true,则对当前连接启用统计信息收集

        conn.ResetStatistics();//如果启用统计信息收集,则所有的值都将重置0

        conn.Open();

        SqlCommand cmd = new SqlCommand("SELECT * FROM Orders", conn);

        SqlDataReader reader = cmd.ExecuteReader();

        reader.Close();

        conn.Close();

 

        Hashtable ht = (Hashtable)conn.RetrieveStatistics();

        foreach (string key in ht.Keys)

        {

            Label1.Text += "Key: " + key + " = " + ht[key] + "<BR />";

        }

 

    }

 

运行结果：

Key: NetworkServerTime = 0
Key: BytesReceived = 156913
Key: UnpreparedExecs = 1
Key: SumResultSets = 1
Key: SelectCount = 1
Key: PreparedExecs = 0
Key: ConnectionTime = 0
Key: ExecutionTime = 0
Key: Prepares = 0
Key: BuffersSent = 1
Key: SelectRows = 830
Key: ServerRoundtrips = 1
Key: CursorOpens = 0
Key: Transactions = 0
Key: BytesSent = 48
Key: BuffersReceived = 20
Key: IduRows = 0
Key: IduCount = 0