Login or Register to Ask a Question and Join Our Community


AIX

Performance issue

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems AIX Performance issue
# 1  
Old 04-11-2012
Question Performance issue
Hi,

We have 2 lpars on p6 blade. One of the lpar is having 3 core cpu with 5gb memory running sybase as database. An EOD process takes 25 min. to complete.
Now we have an lpar on P7 server with entitled cpu capacity of 2 with 16 Gb memory and sybase as database. The EOD process which takes 25 min on p6 is taking 50 min on P7 to complete. I have disabled the SMT and checked it reduces to 40 min but still it is higher than p6. Smilie
Can anybody help me?

Regards,

VJM
# 2  
Old 04-11-2012
are the databases running on the same storage? you might want to collect nmon data on both systems during the process, and compare them to determine the bottleneck


also check out recommended tunable settings for AIX from the sybase documentation

for more help you need to provide more information
# 3  
Old 04-11-2012
Quote:
Originally Posted by funksen
for more help you need to provide more information
As he says.

What's different from the old p6 environment to the p7? Which modes are you running ie. dedicated or shared LPARs, if shared then capped or uncapped?
Different OS versions?
As funksen said, different disk/storage layout?
Absolutely the same EOD process? I am unsure - I guess End Of Day process? What type of process is that, what is involved on the old hardware, what on the new? Same environment? If SQL is involved, same query as before? Is the database indexed etc. as the one before to avoid table scans etc.?
Had the old environment be tuned already? vmo? ioo? AIO?...
# 4  
Old 04-11-2012
Show us some "vmstat -Iwt 1 20" output from both servers.
# 5  
Old 04-12-2012
how many engines and how many virtuals do you have on your nodes ?
# 6  
Old 04-12-2012
Hi,

There are 2 engines in sybase and 3 vcpu in lpar. the output of vmstat and iostat is as below.

Code:
vmstat -Iwt 1 20

System configuration: lcpu=3 mem=16384MB ent=3.00

   kthr            memory                         page                       faults                 cpu             time
----------- --------------------- ------------------------------------ ------------------ ----------------------- --------
  r   b   p        avm        fre    fi    fo    pi    po    fr     sr    in     sy    cs us sy id wa    pc    ec hr mi se
  1   1   0     775841     836806     0   218     0     0     0      0   224  18877  1474  1  2 50 47  0.09   3.2 12:21:04
  1   1   0     776003     836644     0   235     0     0     0      0   232  19767  1606  1  2 51 46  0.10   3.3 12:21:05
  1   1   0     776120     836527     0   173     0     0     0      0   177  14744  1187  1  2 51 47  0.07   2.5 12:21:06
  2   0   0     776249     836398     0   166     0     0     0      0   176  14625  1188  1  2 50 47  0.08   2.7 12:21:07
  1   1   0     776400     836247     0   218     0     0     0      0   214  18040  1479  1  2 51 46  0.09   3.1 12:21:08
  3   0   0     776560     836087     0   235     0     0     0      0   233  19726  1516  1  2 51 46  0.10   3.3 12:21:09
  1   1   0     776713     835934     0   222     0     0     0      0   218  18318  1468  1  2 50 47  0.09   3.1 12:21:10
  1   1   0     776834     835813     0    41     0     0     0      0    43   3779   303  1  2 90  7  0.08   2.8 12:21:11
  1   1   0     776995     835652     0   191     0     0     0      0   187  12386  1384  1  1 51 46  0.08   2.7 12:21:12
  1   1   0     777178     835469     0   221     0     0     0      0   218  15519  1579  1  2 52 45  0.09   3.1 12:21:13
  1   1   0     777311     835336     0   179     0     0     0      0   176  13182  1212  1  1 50 47  0.08   2.5 12:21:14
  1   1   0     777450     835197     0   182     0     0     0      0   184  13990  1278  1  2 50 47  0.08   2.7 12:21:15
  1   1   0     777624     835023     0   227     0     0     0      0   225  17389  1565  1  2 50 47  0.10   3.2 12:21:16
  1   1   0     777775     834872     0    67     0     0     0      0    68   5471   467  1  2 85 12  0.10   3.2 12:21:17
  1   1   0     777908     834739     0   180     0     0     0      0   179  12791  1239  1  1 51 47  0.08   2.5 12:21:18
  1   1   0     778081     834566     0   212     0     0     0      0   215  14603  1528  1  2 51 46  0.09   3.0 12:21:19
  2   0   0     778236     834411     0   200     0     0     0      0   198  14232  1373  1  2 52 46  0.08   2.8 12:21:20
  1   1   0     778367     834280     0    85     0     0     0      0    91   6775   616  1  2 84 14  0.09   2.9 12:21:21
  2   0   0     778514     834133     0   190     0     0     0      0   200  13161  1382  1  2 50 47  0.08   2.7 12:21:22
  1   1   0     778685     833962     0   222     0     0     0      0   218  15568  1481  1  2 50 46  0.10   3.2 12:21:23
=================================================================================================================================

Code:
iostat -Dl -T

System configuration: lcpu=3 drives=5 paths=50 vdisks=2

Disks:                     xfers                                read                                write                                  queue                    time
-------------- -------------------------------- ------------------------------------ ------------------------------------ -------------------------------------- ---------
                 %tm    bps   tps  bread  bwrtn   rps    avg    min    max time fail   wps    avg    min    max time fail    avg    min    max   avg   avg  serv
                 act                                    serv   serv   serv outs              serv   serv   serv outs        time   time   time  wqsz  sqsz qfull
hdisk0           0.0 100.2K  11.9 435.4   99.7K   0.0   4.2    0.4  126.6     0    0  11.9   1.1    0.6   99.8     0    0   1.0    0.0  965.6    0.0   0.0   0.3  12:28:31
hdisk1           0.0  80.6K  10.9 490.8   80.1K   0.1   1.5    0.4   82.8     0    0  10.9   1.1    0.5   99.9     0    0   0.2    0.0  107.5    0.0   0.0   0.1  12:28:31
hdisk5           0.0   4.1K   0.8 437.5    3.6K   0.0   2.4    0.4   59.1     0    0   0.8   1.1    0.6   84.4     0    0   0.0    0.0    2.8    0.0   0.0   0.0  12:28:31
hdisk2           0.0 141.7K   1.4   1.1K 140.6K   0.0   3.0    0.1   19.7     0    0   1.4   5.7    0.3  276.1     0    0 189.4    0.0    2.1S   0.0   0.0   0.6  12:28:31
hdisk3           0.0 106.8K   1.1 829.2  106.0K   0.0   3.0    0.1   22.4     0    0   1.1   6.0    0.2   74.7     0    0 154.7    0.0    1.8S   0.0   0.0   0.4  12:28:31

Regards
vjm

---------- Post updated at 12:35 PM ---------- Previous update was at 12:31 PM ----------

Hi,

And the p7 is using xiv and old p6 is using ds8k with svc. The other difference is p7 is having aix 6100-06-06-1140 and p6 is having aix 5300-07-01-0748

Regards,

VJM
# 7  
Old 04-12-2012
What is the CPU speed of your Power6 and your Power7 frame?

I got problems when migrating form P595 power6 5GHz to P770 power7 3GHz.

Power7 id offering more cores but performance per core is lower then Power6
Multithread software got relay speedup, but working Single thread applications were suffering because of per core performance.

What is your microcode level on power7 ? recently there was an update that was solving memory performance issues.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Red Hat

Performance issue in Linux

IN solaris, for network high-availability we are using IPMP concept, can u tell me in REDHAT LINUX what we are using... also pls share good step to read & understand the that concept... Also performance issue in linux what are step & cmd can u tell me??? (2 Replies)
Discussion started by: tiger09
2 Replies

2. AIX

Performance issue

Hi We have an AIX5.3 server with application which is written in C. We are facing server (lpar) hangs intermediately. If we open new telnet window prompts for user and takes hell of a time to authenticate, not only that if we run ps -aef then also it takes lot of time. surprisingly there is no... (2 Replies)
Discussion started by: powerAIX
2 Replies

3. UNIX for Dummies Questions & Answers

Performance issue

hi I am having a performance issue with the following requirement i have to create a permutation and combination on a set of three files such that each record in each file is picked and the output is redirected in a specific format but it is taking around 70 odd hours to prepare a combination... (7 Replies)
Discussion started by: mad_man12
7 Replies

4. Shell Programming and Scripting

Performance issue or something else?

Hi All, I have the following script which I use in Nagios to check the health of the applications, the problem with it is that the curl part ($TOTAL) does not return anything after running for 2-3 hrs, even though from command line the script runs fine but not from Nagios. There are 17... (1 Reply)
Discussion started by: jacki
1 Replies

5. Solaris

Performance issue

Hi Gurus, I am beginner in solaris and want to know what are the things we need to check for performance monitoring on our solairs OS. for DISK,CPU and MEMORY. Also how we do ipforwarding in slaris Many thanks for your help Pradeep P (4 Replies)
Discussion started by: ppandey21
4 Replies

6. UNIX for Advanced & Expert Users

Performance issue!

In my C program i am using very large file(approx 400MB) to read parts of it frequently. But due to large file the performance of the program goes down very badly. It shows very high I/O usage and I/O wait time. My question is, What are the ways to optimize or tune I/O on linux or how i can get... (10 Replies)
Discussion started by: mavens
10 Replies

7. Shell Programming and Scripting

performance issue

I want to read a file. is it good to use File I/O or shell script?? which one is the best option? (1 Reply)
Discussion started by: vishwaraj
1 Replies

8. UNIX for Advanced & Expert Users

performance issue

Hi, on a linux server I have the following : vmstat 2 10 procs memory swap io system cpu r b w swpd free buff cache si so bi bo in cs us sy id 0 4 0 675236 39836 206060 1617660 3 3 3 6 8 7 1 1 ... (1 Reply)
Discussion started by: big123456
1 Replies

9. AIX

performance issue

We have a AIX v5.3 on a p5 system with a poor performing Ingres database. We added one CPU to the system to see if this would help. Now there are two CPU's. with sar and topas -P I see good results: CPU usage around 30% with topas I only see good results in the process output screen, the... (1 Reply)
Discussion started by: rein
1 Replies

10. UNIX for Advanced & Expert Users

Performance issue

Hello all, I just stuck up in an uncertain situation related to network performance... I am trying to access one of my remote client unix machine from a distant location.. The client machine is Ultra-5_10 , with SunOS 5.5.1 The ndd result ( hme1 )shows that the machine is hooked to a... (5 Replies)
Discussion started by: shibz
5 Replies
Login or Register to Ask a Question