a question about sp_monitor

On the Books Online for sp_monitor:
total_read Number of reads by SQL Server.
total_write Number of writes by SQL Server.
Can anybody explain what is Number of Reads/Writes mean? Is it the number of
bytes read/Write?
Thanks,
LijunThey are same as @.@.total_read (or @.@.total_write), and they are the total
number of disk reads (or writes) by SQL Server since it starts. So they are
definitely not the number of bytes read or written.
I don't use sp_monitor, and I don't know anybody who uses sp_monitor for any
sort of practical performance tuning or troubleshooting purposes.
Linchi
"Lijun Zhang" wrote:

> On the Books Online for sp_monitor:
> total_read Number of reads by SQL Server.
> total_write Number of writes by SQL Server.
>
> Can anybody explain what is Number of Reads/Writes mean? Is it the number
of
> bytes read/Write?
> Thanks,
> Lijun
>
>|||Thanks, Linchi. What I am trying to do is to get number of bytes read/write
for a period of time. We are looking at buy a new server to replace one of
the production servers, and I am trying to get the bandwidth requirements.
Do you know how to get the counters? Is System Monitor the only tool I can
use?
Lijun
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:4E872DCB-ADB7-4CFD-85FB-44F4A73035F7@.microsoft.com...[vbcol=seagreen]
> They are same as @.@.total_read (or @.@.total_write), and they are the total
> number of disk reads (or writes) by SQL Server since it starts. So they
> are
> definitely not the number of bytes read or written.
> I don't use sp_monitor, and I don't know anybody who uses sp_monitor for
> any
> sort of practical performance tuning or troubleshooting purposes.
> Linchi
> "Lijun Zhang" wrote:
>|||That won't tell you any kind of bandwidth. Exactly what are you trying to
determine the server or the storage?
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Lijun Zhang" <sonyzhang00@.yahoo.com> wrote in message
news:e%23ndhA8SIHA.2000@.TK2MSFTNGP05.phx.gbl...
> Thanks, Linchi. What I am trying to do is to get number of bytes
> read/write for a period of time. We are looking at buy a new server to
> replace one of the production servers, and I am trying to get the
> bandwidth requirements.
> Do you know how to get the counters? Is System Monitor the only tool I can
> use?
> Lijun
>
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:4E872DCB-ADB7-4CFD-85FB-44F4A73035F7@.microsoft.com...
>