SQL Profiler Trace中的CPU和Duration分別使用的是什麼單位

從SQL 2005開始, 伺服器彙報某個事件的時間長度使用微秒(microseconds)作為單位.

         1微秒 = 10的-6次方秒

         1秒 = 1000000秒

 

CPU時間使用的是毫秒(Millisecond).

         1毫秒 = 10的-3次方秒

         1秒 = 1000毫秒

 

原文摘抄如下:

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.

 

參考資料:

Viewing and Analyzing Traces with SQL Server Profiler

http://msdn.microsoft.com/en-us/library/ms175848.aspx

SQL Profiler CPU / duration units

http://stackoverflow.com/questions/976628/sql-profiler-cpu-duration-units