□ASP.NET2.0中的SqlConne...... ASP.NET 2.0中的SqlConnection多了一个StatisticsEnabled属性和ResetStatistics()、RetrieveStatistics()两个方法,用于获取SQLServer的连接统计数据。 <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SqlClient" %> <%@ page language="C#" %> 运行后的结果就是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 |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-30 21:35 , Processed in 0.139221 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.