程序博客网 > plc常用的编程语言

ASP.NET2.0里轻松获取数据库连接统计数据

来源：互联网发布：plc常用的编程语言编辑：程序博客网时间：2024/04/29 07:21

<script type="text/javascript"></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

ASP.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

<script type="text/javascript"></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

plc常用的编程语言

plc常用的编程语言

原创粉丝点击

热门问题 老师的惩罚人脸识别我在镇武司摸鱼那些年重生之率土为王我在大康的咸鱼生活盘龙之生命进化天生仙种凡人之先天五行春回大明朝姑娘不必设防，我是瞎子清河毛纺厂北小区毛线手工看毛线毛线画毛线粘贴画毛线鞋毛线玩偶毛线贴画毛线图片毛线鞋教程毛线画作品毛线呀毛线啊毛线啥意思毛线的意思恒源祥毛线毛线球图片毛线批发毛线小精灵毛线大全打毛线帽毛线勾花纯毛线毛线种类细毛线毛线玩偶41款婴儿毛线鞋织法大全毛线鞋花样图案大全毛线什么意思毛线球的做法毛线帽子编织毛线是什么意思毛线简单手工毛线袜子五种打法毛线手工粘贴画毛线编织花样毛线贴画手工制作5分钟毛线帽子编织花样5000 毛线是啥意思网络语毛线是什么意思毛线是什么意思网络