2012年3月29日星期四

DiskIO value in sp_who2

When I run sp_who2, the result set contains a column 'DiskIO'.
I want to know if this values shows total number of physical Page Read or
Write by a process. Is my understanding correct?
This column is most likely referencing to physical_io column in sysprocesses
table.
"Sumanta Gayen" <SumantaGayen@.discussions.microsoft.com> wrote in message
news:3ED22FD8-E4CC-46F6-A263-E4C092A988C8@.microsoft.com...
> When I run sp_who2, the result set contains a column 'DiskIO'.
> I want to know if this values shows total number of physical Page Read or
> Write by a process. Is my understanding correct?
>
>
|||It is a combination of Physical and Logical I/O that is cumulative from the
start of the connection.
Andrew J. Kelly SQL MVP
"Sumanta Gayen" <SumantaGayen@.discussions.microsoft.com> wrote in message
news:3ED22FD8-E4CC-46F6-A263-E4C092A988C8@.microsoft.com...
> When I run sp_who2, the result set contains a column 'DiskIO'.
> I want to know if this values shows total number of physical Page Read or
> Write by a process. Is my understanding correct?
>
>

没有评论:

发表评论