how to monitor queue length and service time for disk
807557Aug 7 2009 — edited Aug 8 2009hi all
I try to find out how busy is the device allocated to database.
My problem is that the device which I use for database and device names reported by iostat or sar are different and I can not relate tools output to devices of my particular interest.
Here is an example:
Sybase uses device with os name: /dev/rdsk/emcpower2a
When I run iostat -xtc, I get next output:
iostat -xtr
extended device statistics,tty
device,r/s,w/s,kr/s,kw/s,wait,actv,svc_t,%w,%b,,tin,tout
md0,0.1,2.0,1.8,4.5,0.0,0.0,18.2,0,1,0,1
md1,0.0,0.0,0.0,0.0,0.0,0.0,10.9,0,0
md3,3.3,1.9,238.8,208.9,0.0,0.1,9.9,0,2
md4,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,0
md5,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,0
...
First column of this output does not show any device with name 'emcpower2a'.
When I run: sar -d , I am having similar problem (output below).
So how can I find out performance metrics on the device I am using for my db?
sar -d 1
SunOS crdprod2 5.10 Generic_137111-08 sun4us 08/07/2009
16:14:58 device %busy avque r+w/s blks/s avwait avserv
16:14:59 md0 0 0.0 0 0 0.0 0.0
md1 0 0.0 0 0 0.0 0.0
md3 0 0.0 0 0 0.0 0.0
md4 0 0.0 0 0 0.0 0.0
md5 0 0.0 0 0 0.0 0.0
md6 0 0.0 0 0 0.0 0.0
md7 0 0.0 0 0 0.0 0.0
Can you help please