HI All, I need to SQL I/O related parameters using SCOM 2007. Kindly find my needs below. 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. I/O - Lazy Writes/sec : The number of pages flushed to disk per second by the Lazy Writer. I/O - Outstanding Reads: The number of physical reads pending. I/O - Outstanding Writes : The number of physical writes pending. I/O - Page Reads/sec : The number of physical page reads per second. I/O - Transactions/sec : The number of Transact-SQL command batches executed per second. Kindly provide valuable input.

Hi There is a list of collection rules here: http://technet.microsoft.com/en-us/library/dd767421.aspx And monitors here: http://technet.microsoft.com/en-us/library/ff919306.aspx Outside of that you'll need to create your own. Kevin Holman as ever gives a great walk through: http://blogs.technet.com/b/kevinholman/archive/2010/12/17/how-to-collect-performance-data-for-sql-databases-multi-instance-objects.aspx Cheers GrahamView OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/