Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Asynchronous I/O on AIX and DB performance
Operating Systems AIX Asynchronous I/O on AIX and DB performance Post 302515088 by arizah on Tuesday 19th of April 2011 02:56:34 AM
Old 04-19-2011
Hi,

Thanks for you valuable comments. Here is more details about my config.

The below are our AIO settings:

Quote:
$ lsattr -El aio0
autoconfig available STATE to be configured at system restart True
fastpath enable State of fast path True
kprocprio 39 Server PRIORITY True
maxreqs 4096 Maximum number of REQUESTS True
maxservers 10 MAXIMUM number of servers per cpu True
minservers 1 MINIMUM number of servers True
And below is a snapshot from nmon/topas

Code:
┌─topas_nmon──S=WLMsubclasses────Host=uapmwh02───────Refresh=2 secs───16:57.47──────────────────────────────────────────────┐
│ Asynchronous-I/O-Processes ───────────────────────────────────────────────────────────────────────────────────────────────│
│ Total AIO processes=  80 Actually in use=   0  CPU used=   1.5%    [Use zero                                              │
│       All time peak=  80     Recent peak=   6      Peak=   1.9%     to reset]                                             │
│ Top-Processes-(240) ─────Mode=3  [1=Basic 2=CPU 3=Perf 4=Size 5=I/O 6=Cmds]───────────────────────────────────────────────│
│  PID       %CPU     Size      Res     Res      Res     Char    RAM      Paging

Also we are on smt so the config is:

System configuration: lcpu=8 ent=1.50

So in our case we get 80 AIO servers processes. This number seems to be a bit low for a DB server performing a large number of DB prefetches.

I can see in topas reaching that peak very often but is not enough to justify a chance according to our Unix Administrators.
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

AIX server performance problem!

Hello, I have a performance problem on an AIX box. I'm not sure what is causing this and hoping someone may have suggestions. Currently I'm noticing that cpu's are waiting while the box is in a idle state. I checked the disks and none of them are at 100%. If they were then I would understand... (3 Replies)
Discussion started by: ctcuser
3 Replies

2. UNIX for Dummies Questions & Answers

AIX performance

Hiya all, I am a newbie sysadmin to AIX, i have worked on HPUX for 3 years. I have started a new role with in an IBM house and because there is me and one other there are a couple of issues I cannot work out: We havehad a production server slowing down processing batch jbs over the past... (6 Replies)
Discussion started by: chlawren
6 Replies

3. AIX

Performance testing on AIX

I'm doing performance testing for one application which works on AIX. But I don't know which performance parameters of memory need to be collected. Now, I just know very few: 1. page in 2. page out 3. fre They are all collected by "vmstat" command. I want to know, except for above... (2 Replies)
Discussion started by: adasong
2 Replies

4. AIX

AIX 5.2 performance question

I am trying to analyze the performance of an AIX system. I think I may have a disk I/O issue, but I am asking for help to validate or invalidate this assumption. I ran the commands below during a period of peak load. Please help me to find any performance bottlenecks. Thanks in advance for your... (15 Replies)
Discussion started by: jhall
15 Replies

5. AIX

Performance issue in AIX 5.3

Is there is any way to increase the CPU utilization of a Embedded SQL program in AIX 5.3 .. for performance purpose. (0 Replies)
Discussion started by: Gyanendra Awast
0 Replies

6. AIX

performance issue in AIX

Gurus, i have process that runs 5 times a day. it runs normally (takes about 1 hour) to complete in 3 runs but it is takes about ( 3 hrs to complete) two times So i need to figure out why it takes significanlty high time during those 2 runs. The process is a shell script that connect to... (2 Replies)
Discussion started by: mad_man12
2 Replies

7. AIX

AIX performance issue

Hi Guys, This is the situation I am in. Provide your views and input where should I start? I have one P7 test server and a p520 production server. the job is taking pretty long on the P7 test server when compared to the P5 production server. below is the full detail. Informix... (5 Replies)
Discussion started by: ithinksgreen
5 Replies

8. AIX

Need some help for AIX performance monitoring

Hello I am new user of AIX; I have only basic knowledge of the UNIX commands, and I want to create script that will monitor the performance and resources usage on AIX 6.1 machine. Basically I wan to start a loop that will grab, every 10 seconds, the CPU usage, the memory usage, the disk usage,... (1 Reply)
Discussion started by: adaher
1 Replies

9. AIX

AIX 5.3 performance problems

Hello, I encounter some performance issues on my AIX 5.3 server running in a LPAR on a P520. How do I investigate performance issues in AIX. Is there any kind of procedure that takes me to the steps to investigate my server and find the sub systems that is causing the issues? The performance... (1 Reply)
Discussion started by: petervg
1 Replies

10. AIX

Performance stats from AIX 6

Hi, I'm supposed to capture many performance stats on AIX 6 and stuck up with below: Priority queue Disk cache hit% Page out rate Swap out rate Memory queue I see vmstatis helpful for "page out" but not sure how to get the "rate". Could anyone please let me know how to get these... (4 Replies)
Discussion started by: reddyr
4 Replies

LEARN ABOUT OPENSOLARIS

u3b2

machid(1)							   User Commands							 machid(1)

NAME

       machid, sun, iAPX286, i286, i386, i486, i860, pdp11, sparc, u3b, u3b2, u3b5, u3b15, vax, u370 - get processor type truth value

SYNOPSIS

       sun

       iAPX286

       i386

       pdp11

       sparc

       u3b

       u3b2

       u3b5

       u3b15

       vax

       u370

DESCRIPTION

       The following commands will return a true value (exit code of 0) if you are using an instruction set that the command name indicates.

       sun	  True if you are on a Sun system.

       iAPX286	  True if you are on a computer using an iAPX286 processor.

       i386	  True if you are on a computer using an iAPX386 processor.

       pdp11	   True if you are on a PDP-11/45tm or PDP-11/70tm.

       sparc	  True if you are on a computer using a SPARC-family processor.

       u3b	  True if you are on a 3B20 computer.

       u3b2	  True if you are on a 3B2 computer.

       u3b5	  True if you are on a 3B5 computer.

       u3b15	  True if you are on a 3B15 computer.

       vax	  True if you are on a VAX-11/750tm or VAX-11/780tm.

       u370	  True if you are on an IBM(R) System/370tm computer.

       The  commands  that  do	not  apply will return a false (non-zero) value. These commands are often used within makefiles (see make(1S)) and
       shell scripts (see sh(1)) to increase portability.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       make(1S), sh(1), test(1), true(1), uname(1), attributes(5)

NOTES

       The machid family of commands is obsolete. Use uname -p and uname -m instead.

SunOS 5.11							    5 Jul 1990								 machid(1)
All times are GMT -4. The time now is 03:48 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy