sql-server-profiler - SQL Profiler CPU/持续时间单位

Question

分析器中 SQL Server 跟踪的输出包含 CPU 和持续时间列(以及其他列)。这些值的单位是什么？

Answer 1

CPU 以毫秒为单位。在 sql server 2005 及更高版本中，保存到文件或表时的持续时间以微秒为单位，在用户界面中以毫秒为单位。在sqlserver 2000中，它总是以毫秒为单位。来自 MSDN .

用户 jerryhung 在评论中给出了更准确的版本特定信息:

Beginning with SQL Server 2005, the server reports the duration of an event in microseconds (one millionth, or 10^-6 of a second) and the amount of CPU time used by the event in milliseconds (one thousandth, or 10^-3 of a second). In SQL Server 2000, the server reported both duration and CPU time in milliseconds. 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.