topic Re: essential parameters values stats to check in Operating System - HP-UX

essential parameters values stats to check

Ferdi Castro — Tue, 02 May 2006 08:45:56 GMT

Hi Guys,

I was checking this iostat and it is high for a certain vg. (below its in vg05)
device bps sps msps

c2t0d0 91 12.6 1.0 vg00
c2t1d0 58 7.8 1.0 vg00
c4t0d0 691 48.8 1.0 vg01
c6t0d0 519 25.4 1.0 vg01
c4t1d0 2 0.3 1.0 vg02
c6t1d0 3 0.3 1.0 vg02
c4t2d0 212 33.7 1.0 vg03
c6t2d0 176 22.0 1.0 vg03
c4t3d0 125 12.1 1.0 vg04
c6t3d0 111 8.6 1.0 vg04
c4t4d0 1570 204.1 1.0 vg05
c6t4d0 1046 92.2 1.0 vg05
c4t5d0 708 120.8 1.0 vg06
c6t5d0 424 53.0 1.0 vg06
c4t8d0 342 48.6 1.0 vg07
c6t8d0 127 16.2 1.0 vg07
c4t9d0 1 0.6 1.0 vg08
c6t9d0 1 0.4 1.0 vg08
c4t10d0 0 0.0 1.0 vg09
c6t10d0 0 0.0 1.0 vg09
c4t11d0 54 8.1 1.0 vg10
c6t11d0 16 2.0 1.0 vg10

My question is are there any essential stats I need to check that is saying I am above the threshold. My plan is to transfer one datafile residing in this vg into another vg. But what will be my factors to consider before I do that. Is the value enough. I know I am missing somthings to check especially checking disk activities and resources consumption. Hope you can also help me checking other queries in the disks.

BR Ferdi

Re: essential parameters values stats to check

Steven E. Protter — Tue, 02 May 2006 08:55:01 GMT

Shalom BR,

Looks like a possible i/o problem.

As usual, I recommend more data.

http://www.hpux.ws/system.perf.sh

sar -d section is what matters here.

SEP

Re: essential parameters values stats to check

Ninad_1 — Tue, 02 May 2006 08:55:56 GMT

Hi,

In the output you have posted - even though the bps and sps is higher since the mps - time in milliseconds to serve the request is showing 1.0 - default if within limit , so you are not experiencing any disk bottleneck at the moment.
But since the transactions are higher compared to other disks, you may still think of distributing data on other disks.
Now all the values depend on whether the disks are internal disks or LUNs from storage array , what is speed of the disks and capacity etc.
You can also use sar -d option to see which disks are busier and which disks are having more avqueue, avserv and avwait values.
Also you should run these stats for a considerable amount of time to get a better picture.

regards,
Ninad

Re: essential parameters values stats to check

Ferdi Castro — Tue, 02 May 2006 09:20:52 GMT

ok i'll send you once i execute it thanks

Re: essential parameters values stats to check

Chan 007 — Tue, 02 May 2006 09:33:04 GMT

Hi Fred,

My question is

1. Are you moving a Live Database file, if yes. then i request you to consider how big is that file and what is the db usage.
2. Is that being shared (NFS),
3. Is backup being carried out

the above 3 will impact you work.

I recon, you should shutdown the DB and do such activity.

Chan

Re: essential parameters values stats to check

Ferdi Castro — Tue, 02 May 2006 10:43:09 GMT

here are some info... output from the perf.sh c

Thanks a lot,
Ferdi

Re: essential parameters values stats to check

Ferdi Castro — Tue, 02 May 2006 10:52:24 GMT

Dear Chan,

No I'm not transferring a dbfile but Im asking for thing/factors that I need to check to optimize my disk usage. The transfer of Datafile into a different vg was just my idea as an alternative solution to lessen disk process in vg05.

BR Ferdi