闂傚倸鍊峰ù鍥Υ閳ь剟鏌涚€n偅宕岄柡宀€鍠栭、娑樷堪閸愮偓姣夋俊鐐€戦崕濠氬箯閿燂拷 (0) +1 闂傚倷娴囧畷鍨叏瀹ュ拋鍚嬮柛鈩冾殢娴硷拷 (0) +1 闂傚倸鍊搁崐鎼併偑鐎涙ḿ顩查柣鎴f缁狀垶鏌ㄩ悤鍌涘 (0) +1
闂傚倸鍊峰ù鍥Υ閳ь剟鏌涚€n偅宕岄柡宀€鍠栭、娑樷堪閸愮偓姣夋俊鐐€戦崕鏌ュ垂閸ф钃熼柣鏃囥€€閸嬫挸鈽夊▍顓т簼閹便劑宕惰閺€鑺ャ亜閺囩偞顥為悗姘炬嫹闂傚倸鍊风粈渚€骞栭銈嗗仏妞ゆ劧绠戠壕鍧楁煕閹邦垼鍤嬮柤鏉挎健閺屾稑鈽夊▎鎰▏缂傚倷璁查弲鐘诲蓟閻旂⒈鏁嶆繝濠傚枤閺嗩厼顪冮妶鍐ㄥ姷闁瑰嚖鎷�>>

正在阅读:.NET 2.0获取数据库连接统计数据.NET 2.0获取数据库连接统计数据

2004-09-10 15:54 出处:CSDN 作者:liuhm 责任编辑:linjixiong

  .NET 2.0中的SqlConnection多了一个StatisticsEnabled属性和ResetStatistics()、RetrieveStatistics()两个方法,用于获取SQLServer的连接统计数据。



  <%@ Import Namespace="System.Data" %>
  <%@ Import Namespace="System.Data.SqlClient" %>
  <%@ page language="C#" %>
  <script runat="server">
  void Page_Load(object sender, EventArgs e)
  {
  string connString = "Northwind的连接串";
  SqlConnection conn = new SqlConnection(connString);
  conn.StatisticsEnabled = true;
  conn.ResetStatistics();
  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 />";
  }
  }
  </script>
  <html>
  <head id="Head1" runat="server">
  <title>Untitled Page</title>
  </head>
  <body>
  <form id="Form1" runat="server" autocomplete="on">
  <asp:Label ID="Label1" Runat="server" Text=""></asp:Label>
  </form>
  </body>
  </html>

  运行后的结果就是SQLServer连接统计数据结果:

  Key: NetworkServerTime = 0
  Key: BytesReceived = 156913
  Key: UnpreparedExecs = 1
  Key: SumResultSets = 1
  Key: SelectCount = 1
  Key: PreparedExecs = 0
  Key: ConnectionTime = 30
  Key: ExecutionTime = 30
  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


察看评论详细内容 我要发表评论
作者笔名 简短内容 发表时间
:

关注我们

最新资讯离线随时看 聊天吐槽赢奖品
闂傚倸鍊风粈浣虹礊婵犲倴缂氱憸鏃堛€侀弽顓炲耿婵$偟绮弫鐘绘⒑闁偛鑻晶鎾煙椤旀娼愰柟宄版嚇瀹曘劍绻濋崒娆愭▕濠电姷顣藉Σ鍛村磻閹捐绠柨鐕傛嫹闂傚倸鍊烽悞锕傚箖閸洖纾块柟鎯版绾剧粯绻涢幋娆忕仼闁哄嫨鍎甸幃姗€鎮欓弶鍨彑婵炲瓨绮嶇划鎾诲蓟濞戙埄鏁冮柨婵嗘椤︺儵姊洪崨濠冾棖闁瑰嚖鎷�