Need to monitor SQL I/O RRS feed

  • Question

  • HI All,

    I need to SQL I/O related parameters using SCOM 2007. Kindly find my needs below.

    1. I/O - Batch Writes/sec : The number of pages written to disk per second, using Batch I/O. The checkpoint thread is the primary user of Batch I/O.
    2. I/O - Lazy Writes/sec  : The number of pages flushed to disk per second by the Lazy Writer.
    3. I/O - Outstanding Reads: The number of physical reads pending.
    4. I/O - Outstanding Writes : The number of physical writes pending.
    5. I/O - Page Reads/sec : The number of physical page reads per second.
    6. I/O - Transactions/sec : The number of Transact-SQL command batches executed per second.

     Kindly provide valuable input.

    Monday, July 18, 2011 7:56 AM