Number of Bytes Read/Write Per Day

Does anybody know how to get the total number of bytes read/write for a
period
of time on an instance of SQL Server (No include other instances on the same
server)?
Thanks,
LijunHi
@.@.TOTAL_READ and @.@.TOTAL_WRITE give the number of disk reads (not cache
reads) and writes (respectively) by Microsoft SQL Server since the instance
last started. If you run this at the start of the period and then at the end
you can subtract the two values. sp_monitor will return these value and
others.
John
"Lijun Zhang" wrote:
> Does anybody know how to get the total number of bytes read/write for a
> period
> of time on an instance of SQL Server (No include other instances on the same
> server)?
> Thanks,
> Lijun
>
>|||Lijun;
If I understand what you are trying to accomplish from an earlier thread in
this newsgroup, I'd say that these total numbers of bytes per day would not
be very useful. To determine the I/O bandwidth requirements or to determine
how your current I/O bandwith is being used in order to determine what I/O
bandwidth you may need to acquire, I'd track the I/O perfmon counters over
time and identify the specific I/O bottlenecks, if any. and their specific
nature.
Knowing only the total number of bytes read or written doesn't tell you much
about how the I/O subsystem is used. For instance, if you are doing a lot of
large sequential I/Os, you can pump through far more bytes on a given I/O
path than if you are doing small random I/Os.
Linchi
"Lijun Zhang" wrote:
> Does anybody know how to get the total number of bytes read/write for a
> period
> of time on an instance of SQL Server (No include other instances on the same
> server)?
> Thanks,
> Lijun
>
>