SQL Profiler Trace中的CPU和Duration分别使用的是什么单位
答案:1 悬赏:10 手机版
解决时间 2021-01-21 21:17
- 提问者网友：别再叽里呱啦
- 2021-01-21 13:59
SQL Profiler Trace中的CPU和Duration分别使用的是什么单位
最佳答案
- 五星知识达人网友：野味小生
- 2021-01-21 14:56
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.
从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.
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息
大家都在看
推荐资讯