a question about sp

a question about sp_monitor

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lijun Zhang - 28 Dec 2007 20:58 GMT

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

Reply to this Message

Linchi Shea - 28 Dec 2007 23:11 GMT

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

> On the Books Online for sp_monitor:
>
[quoted text clipped - 7 lines]
>
> Lijun

Reply to this Message

Lijun Zhang - 31 Dec 2007 15:16 GMT

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

> 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
[quoted text clipped - 19 lines]
>>
>> Lijun

Reply to this Message

Andrew J. Kelly - 31 Dec 2007 16:01 GMT

That won't tell you any kind of bandwidth. Exactly what are you trying to
determine the server or the storage?

Signature

Andrew J. Kelly SQL MVP
Solid Quality Mentors

> 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
[quoted text clipped - 29 lines]
>>>
>>> Lijun

Reply to this Message