Asynchronous I/O on AIX and DB performance


 
Thread Tools Search this Thread
Operating Systems AIX Asynchronous I/O on AIX and DB performance
# 8  
Old 04-19-2011
Hi,

Thanks for your comments once again. I wonder if in this case everytime when we hit the peak in my case we have only 120 AIO servers procesess on this server then any other requests has to sit in the queue and wait for a AIO server to be released/available. If this how it works?. I must admit I'm a bit confuse with the maxreqs parameter. In our enviroment is set to 4096 but I believe this is just a hard limit assuming that the combination of maxservers and the number of CPU's doesn't go beyond this limit.
Code:
│ Asynchronous-I/O-Processes ───────────────────────────────────────────────────────────────────────────────────────────────│
│ Total AIO processes= 120 Actually in use=   0  CPU used=   0.0%    [Use zero                                              │
│       All time peak= 120     Recent peak= 119      Peak=  28.0%     to reset]                                             │
│ Top-Processes-(308) ─────Mode=3  [1=Basic 2=CPU 3=Perf 4=Size 5=I/O 6=Cmds]─────────────

# 9  
Old 04-20-2011
maxservers is the hard limit for the maximum number of aioservers being started, that handle aio requests. They are calculated by the number of logical CPUs * maxservers. They are the workers that grab their work out of the pot with the label "maxreqs".

maxreqs defines how much work may reside in this pot. The single working tasks can be waiting to be handled or already be taken care of by a aioserver which is the asynchronism.
If there is more tasks in there, that are waiting to be taken care of than aioservers, it will just take some time until they are next. If there is far less aioservers than tasks (requests) that are ready to run, then it will be maybe a noticeable delay in processing.

pSeries and AIX Information Center

Last edited by zaxxon; 04-20-2011 at 08:35 AM.. Reason: syntax, rephrasing
# 10  
Old 04-21-2011
Hi Again,

Thanks all for you valuable comments. Now we are evaluating either increasing these parameters or going even further and upgrade AIX to 6.1 where I believe AIO is allocated all dynamically. We have a Volume test environment but doesn't have the same amount of resources as in prod so ETL team would not agree to execute a performance and volume test. Thanks Again!!!.
# 11  
Old 05-06-2011
with a large system like this I would encourage you to open a PMR with IBM. there might be other performance tweaking options or design issues.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
Login or Register to Ask a Question