Sponsored Content
Operating Systems AIX Power6 vs. Power7 hardware performance Post 302643243 by zxmaus on Friday 18th of May 2012 09:35:02 PM
Old 05-18-2012
hmmm

having more than 300 lpars - about 130 migrated from p6 to p7 I cannot see where p7 is even remotely slower than p6? - So I go with Bakunin's opinion. There are plenty of other reasons than cpu clockspeed that could cause your performance degregation.
In my experience, oracle performs much better on p7 (benefiting from the again out-of-order processing) and for sybase it's about the same if you stick with one virtual per engine.
Anyways to be able to help you I would suggest that you simply post some data from your system under load - like
Code:
vmstat -Iwt 2 10, vmstat -s, vmstat -v, iostat -Dl 2 10

and alikes ?
It would help as well if you could tell us anything about the amount of virtualization, if AIXTHREAD_SCOPE is set to S, which OS version and TL / ML you are running and similar things.
If your app really performs a lot better on p6 than on p7 in a different version, than I would probably see if there are issues with the code of your application connecting to the DB. When we were upgrading from sybase 12.5.4 to 15, we had lots of performance degregation because the entire behaviour of the DB was changing and our developers did not bother to amend the stored procedures to the new DB version.
What we are seeing as well when migrating to p7 is a lot more locking in our DBs, which makes the DB appear to be slower though it isn't. It just seems to be because the queries have not yet been cleaned up.
Last but not least - how did the data come onto your new box. If it has been replicated via tools like rman or repserver or goldengate - or even if it simply has been sftp'ed in multiple streams into the new filesystems - than you might just badly suffer under fragmentation within the filesystems - what would be very easy to diagnose via fileplace commands.

Regards
zxmaus
 

9 More Discussions You Might Find Interesting

1. AIX

Oracle 10G best practices on Power6 AIX5.3

Can anyone point me to any best practices for partitioning, resource prerequisites, and implementation of Oracle 10G release 2 with RAC on 2 power6 550's running AIX5.3 as a cluster? (1 Reply)
Discussion started by: JodyTek
1 Replies

2. AIX

POWER6 VIO Failover

Hello, Can someone point to me document or the method to make failover for VIO Servers ? I have one VIO_Server1 which has 4 AIX LPARS - From the VIO_SERVER1 I have assigned virtual SCSI DISK to the four LPARS - For Ethernet I have used LHEA So, if my VIO Server1 crashes all the LPARS... (17 Replies)
Discussion started by: filosophizer
17 Replies

3. UNIX for Dummies Questions & Answers

Processor performance question [hardware]

A few of our machines need upgrading and we are looking into a selection of processors at present. There are suggestions on the vendor's websites that the L3 cache was specifically introduced for gamers. Is this true? Does having L1, L2 and/or L3 cache help at all in performance or are the... (0 Replies)
Discussion started by: figaro
0 Replies

4. Programming

Top v3.7 and v3.8beta1 will not compile on Power7/AIX6.1 server.

Please help! We are upgrading our server to a new Power7/AIX6.1 from Power5/AIX5.3. I have some programs that rely on output of the TOP command to do various things, however, I keep getting an error when I try to re-compile TOP on my new server (see below). I have tried TOP 3.7 (current... (1 Reply)
Discussion started by: troym72
1 Replies

5. AIX

IBM POWER7 595

Does anybody know when POWER7 595 is going to be announced??? I was looking for in IBM's web page but could not find (1 Reply)
Discussion started by: Vit0_Corleone
1 Replies

6. AIX

Migration DB2 V8 databases to Power7 server

hi Guys, I just wondering if someone has gone through this process before. We are about to migrate all our current LPARS from a Power6 server to a new Power7 server. The only concern we have is that we are runing a few DB2 V8 databases on AIX 5.3 and basically DB2 v8 is been out of support for... (2 Replies)
Discussion started by: arizah
2 Replies

7. AIX

Server Power7 p750 support CentOS or not ?

Hi All, I would like to install CentOS 5.5 linux on Power7 server (P750). it support or not?? I found information from IBM websites as detail below, but not sure for CentOS. IBM Power 750 support linux >>Red Hat Enterprise Linux 5.5, SUSE Linux Enterprise Server 10 SP3,... (2 Replies)
Discussion started by: arm_naja
2 Replies

8. AIX

How to get power6 power FRU?

how to get power6 power FRU? the power5 can get by this command: lscfg -vp | grep -p 'AC PS' | grep FRU however, the power6 machine cannot get any info for that command. thanks (1 Reply)
Discussion started by: rainbow_bean
1 Replies

9. AIX

Hard drive compatibility for POWER6 p520

Hi, I have recently inherited an old p520 from work running AIX 6.1, based on the POWER6 CPU. I'm planning to play around with it and use it to learn the system, so this is a purely personal project. The machine is not under a support contract any more. I am looking to replace one of the disks... (11 Replies)
Discussion started by: topcat
11 Replies
vmstat(1M)						  System Administration Commands						vmstat(1M)

NAME
vmstat - report virtual memory statistics SYNOPSIS
vmstat [-cipqsS] [disks] [interval [count]] DESCRIPTION
vmstat reports virtual memory statistics regarding kernel thread, virtual memory, disk, trap, and CPU activity. On MP (multi-processor) systems, vmstat averages the number of CPUs into the output. For per-processor statistics, see mpstat(1M). vmstat only supports statistics for certain devices. For more general system statistics, use sar(1), iostat(1M), or sar(1M). Without options, vmstat displays a one-line summary of the virtual memory activity since the system was booted. During execution of the kernel status command, the state of the system can change. If relevant, a state change message is included in the vmstat output, in one of the following forms: <<device added: sd0>> <<device removed: sd0>> <<processors added: 1, 3>> <<processors removed: 1, 3>> See for device naming conventions for disks. OPTIONS
The following options are supported: -c Report cache flushing statistics. This option is obsolete, and no longer meaningful. This option might be removed in a future version of Solaris. -i Report the number of interrupts per device. count and interval does not apply to the -i option. -p Report paging activity in details. This option will display the following, respectively: epi Executable page-ins. epo Executable page-outs. epf Executable page-frees. api Anonymous page-ins. apo Anonymous page-outs. apf Anonymous page-frees. fpi File system page-ins. fpo File system page-outs. fpf File system page-frees. When executed in a zone and if the pools facility is active, all of the above only report actitivity on the processors in the proces- sor set of the zone's pool. -q Suppress messages related to state changes. -s Display the total number of various system events since boot. count and interval does not apply to the -s option. -S Report on swapping rather than paging activity. This option will change two fields in vmstat's ``paging'' display: rather than the ``re'' and ``mf'' fields, vmstat will report ``si'' (swap-ins) and ``so'' (swap-outs). OPERANDS
The following operands are supported: count Specifies the number of times that the statistics are repeated. count does not apply to the -i and -s options. disks Specifies which disks are to be given priority in the output (only four disks fit on a line). Common disk names are id, sd, xd, or xy, followed by a number (for example, sd2, xd0, and so forth). interval Specifies the last number of seconds over which vmstat summarizes activity. This number of seconds repeats forever. interval does not apply to the -i and -s options. EXAMPLES
Example 1 Using vmstat The following command displays a summary of what the system is doing every five seconds. example% vmstat 5 kthr memory page disk faults cpu r b w swap free re mf pi p fr de sr s0 s1 s2 s3 in sy cs us sy id 0 0 0 11456 4120 1 41 19 1 3 0 2 0 4 0 0 48 112 130 4 14 82 0 0 1 10132 4280 0 4 44 0 0 0 0 0 23 0 0 211 230 144 3 35 62 0 0 1 10132 4616 0 0 20 0 0 0 0 0 19 0 0 150 172 146 3 33 64 0 0 1 10132 5292 0 0 9 0 0 0 0 0 21 0 0 165 105 130 1 21 78 1 1 1 10132 5496 0 0 5 0 0 0 0 0 23 0 0 183 92 134 1 20 79 1 0 1 10132 5564 0 0 25 0 0 0 0 0 18 0 0 131 231 116 4 34 62 1 0 1 10124 5412 0 0 37 0 0 0 0 0 22 0 0 166 179 118 1 33 67 1 0 1 10124 5236 0 0 24 0 0 0 0 0 14 0 0 109 243 113 4 56 39 ^C example% The fields of vmstat's display are kthr Report the number of kernel threads in each of the three following states: r the number of kernel threads in run queue b the number of blocked kernel threads that are waiting for resources I/O, paging, and so forth w the number of swapped out lightweight processes (LWPs) that are waiting for processing resources to finish. memory Report on usage of virtual and real memory. swap available swap space (Kbytes) free size of the free list (Kbytes) page Report information about page faults and paging activity. The information on each of the following activities is given in units per second. re page reclaims -- but see the -S option for how this field is modified. mf minor faults -- but see the -S option for how this field is modified. pi kilobytes paged in po kilobytes paged out fr kilobytes freed de anticipated short-term memory shortfall (Kbytes) sr pages scanned by clock algorithm When executed in a zone and if the pools facility is active, all of the above (except for "de") only report activity on the pro- cessors in the processor set of the zone's pool. disk Report the number of disk operations per second. There are slots for up to four disks, labeled with a single letter and number. The letter indicates the type of disk (s = SCSI, i = IPI, and so forth); the number is the logical unit number. faults Report the trap/interrupt rates (per second). in interrupts sy system calls cs CPU context switches When executed in a zone and if the pools facility is active, all of the above only report actitivity on the processors in the processor set of the zone's pool. cpu Give a breakdown of percentage usage of CPU time. On MP systems, this is an average across all processors. us user time sy system time id idle time When executed in a zone and if the pools facility is active, all of the above only report actitivity on the processors in the processor set of the zone's pool. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWcsu | +-----------------------------+-----------------------------+ |Interface Stability |See below. | +-----------------------------+-----------------------------+ Invocation is evolving. Human readable output is unstable. SEE ALSO
sar(1), iostat(1M), mpstat(1M), sar(1M), attributes(5) NOTES
The sum of CPU utilization might vary slightly from 100 because of rounding errors in the production of a percentage figure. The -c option (Report cache flushing statistics) is not supported in this release. SunOS 5.11 20 Dec 2004 vmstat(1M)
All times are GMT -4. The time now is 08:24 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy