SQL Profiler 中 Duration 列的度量单位 [英] Unit of measurement for Duration column in SQL Profiler

问题描述

SQL Profiler 中 Duration 列的单位是什么?我以为是毫秒，但在下面的 Profiler 行中，我发现它与开始和结束时间相矛盾:

What is the unit of the Duration column in SQL Profiler? I thought it was milliseconds but in the following Profiler row I found it contradicting with start and end time:

spid=163    
duration=11310646
starttime=2010-04-06 17:45:24.480
endtime=2010-04-06 17:45:35.790
reads=152
writes=2
cpu=16
eventclass=12
textdata= DELETE FROM dbo.[Icon] WHERE Id = 20087 

仅供参考，我使用的是 SQL Server 2008.

FYI, I am using SQL Server 2008.

推荐答案

我找到了答案 这里.它说

在 SQL Server 中2005 年及以后，SQL ServerProfiler 图形用户界面显示持续时间列默认为毫秒，但当 a跟踪保存到文件或数据库表，Duration 列值以微秒为单位写入

In SQL Server 2005 and later, the SQL Server Profiler graphical user interface displays the Duration column in milliseconds by default, but when a trace is saved to either a file or a database table, the Duration column value is written in microseconds

在数据库中保存跟踪文件后我正在观察它们.

I was watching them after saving the trace file in database.

这篇关于SQL Profiler 中 Duration 列的度量单位的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！