Need explanation on Performance Monitor PhysicalDisk(*)\Avg. Disk sec/Transfer

• Ryan D.

  SSCommitted

  Points: 1595

  More actions

  February 16, 2007 at 3:11 pm

  #117749

  Hello

  I'm running the following typeperf command. Can someone explain to me how this works. I'm trying to understand where the values are coming from.

  typeperf -sc 1 "\PhysicalDisk(*)\Avg. Disk sec/Transfer"

  Output:

  "(PDH-CSV 4.0)","\\SERVERNAME\PhysicalDisk(0 C\Avg. Disk sec/Transfer","\\SERVERNAME\PhysicalDisk(1)\Avg. Disk sec/Transfer","\\SERVERNAME\PhysicalDisk(2 E\Avg. Disk sec/Transfer","\\SERVERNAME\PhysicalDisk(3)\Avg. Disk sec/Transfer","\\SERVERNAME\PhysicalDisk(4)\Avg. Disk sec/Transfer","\\SERVERNAME\PhysicalDisk(_Total)\Avg. Disk sec/Transfer"

  "02/16/2007 15:33:35.673","0.000300","0.000000","0.003250","0.000000","0.000000","0.002267"

  Exiting please wait...                       

  The command completed successfully.

  I checked the disk management. There is only one drive, partitioned 4 times. No DriveLetter, C, D, E.

  How are the values associate with the drive?

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  February 19, 2007 at 7:22 am

  #690439

  this counter shows the average time it takes an io to complete in ms.

  If you choose physical disk then I guess you'll get one value, if you choose logical then you'll get a value for each partition.

  Either set(s) of value are valid, but you should be consistant in your monitoring.

  disk  io completion time is a very useful counter,  when you say one drive, do you mean one spindle or one array ?

   

   

   

   

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/