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?
>
>
没有评论:
发表评论