监测MSSQL执行的效能与时间

SQL端测试

DECLARE @Begin DATETIME
DECLARE @End DATETIME
SET @Begin = GETDATE()

–执行SQL CmdStart
Select name,sum(payment)as pay From member group by name having sum(payment)>40
–SQL CmdEnd

SET @End = GETDATE()
SELECT DATEDIFF(millisecond, @Begin, @End) AS ExecutionTime

C# 程式端测试
//宣告观察物件 提供一组方法和属性 (Property)，您可以使用这些方法和属性，精确地测量已耗用时间。
System.Diagnostics.Stopwatch watch = new System.Diagnostics.Stopwatch();

cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_UpdateMember";
SqlParameter Name = new SqlParameter("@Name",TboxName.Text.Trim().ToString());
SqlParameter Id = new SqlParameter("@ID", Convert.ToInt32(TboxId.Text.Trim()));
cmd.Parameters.Add(Name);
cmd.Parameters.Add(Id);
try
{
watch.Start();
cn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
watch.Stop();
Response.Write(watch.ElapsedMilliseconds); //单位毫秒

详细内容请参考http://blog.faq-book.com/?p=2939