福州电信网 :
ASP.NET2.0中的SqlConnection多了一个StatisticsEnabled属性和ResetStatistics()、RetrieveStatistics()两个办法,用于获取SQLServer的连接统计数据。 <%@ImportNamespace="System.Data"%> <%@ImportNamespace="System.Data.SqlClient"%> <%@pagelanguage="C#"%> <scriptrunat="server"> voidPage_Load(objectsender,EventArgse) { stringconnString="Northwind的连接串"; SqlConnectionconn=newSqlConnection(connString); conn.StatisticsEnabled=true; conn.ResetStatistics(); conn.Open(); SqlCommandcmd=newSqlCommand("SELECT*FROMOrders",conn); SqlDataReaderreader=cmd.ExecuteReader(); reader.Close(); conn.Close(); Hashtableht=(Hashtable)conn.RetrieveStatistics(); foreach(stringkeyinht.Keys) { Label1.Text+="Key:"+key+"="+ht[key]+"<BR/>"; } } </script> <html> <headid="Head1"runat="server"> <title>UntitledPage</title> </head> <body> <formid="Form1"runat="server"autocomplete="on"> <asp:LabelID="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
(责任编辑:vivi) (福州电信网 ) |