Capture counters to analyze disk I/O contention

Hi,
I'm trying to capture some counters in perfmon/sysmon that would help me
analyze if there is any disk I/O contention between SQL and other processes
(OS and/or others). Does anyone know if there is/are any counters that will
allow me to capture this info?
Thanks.Hi
TYou don't give the version of SQL Server you are using! For SQL 2000 you
may want to look at DBCC SQLPERF (WAITSTATS) or the DMVs in SQL 2005 see
http://blogs.msdn.com/sqlcat/archiv.../05/461199.aspx for examples.
For performance counters you can not separate the individual process usage
but you can see the general usage and
http://www.sql-server-performance.c...nce_article.asp
lists some of the counters you can look at. You may have to use emperical
observations to decide what is causing the contention, e.g. Make
observations; separate logs from data files; make observations; move tempdb
to it's own spindles; make observations;
separate databases onto own spindles; make observations; etc...
If you are using a SAN then you can also get stats from that (but it will
not identify the specific processes).
John
"Rob" wrote:

> Hi,
> I'm trying to capture some counters in perfmon/sysmon that would help me
> analyze if there is any disk I/O contention between SQL and other processe
s
> (OS and/or others). Does anyone know if there is/are any counters that wil
l
> allow me to capture this info?
> Thanks.