To measure the NUMBER of I/Os per second, watch Perfmon counter "Disk Reads / second" and "Disk Writes / Second"
To measure the SIZE of I/O's being issued, watch Perfmon counter "Avg. Disk Bytes / Read" and "Avg. Disk Bytes / Write"
Remember though, that many times SQL Server can get the data straight
from the Buffer Pool without going to disk. This is a Logical IO and
will not be registered by the counters above.
阅读(1170) | 评论(0) | 转发(0) |
