- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Differences in cpu utilization between rx4660 and ...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-28-2005 12:53 PM
тАО03-28-2005 12:53 PM
I have 2 databases, one in an N-Class and another in an itanium rx4640. The N-Class has 8 cpu's 32gb memory. The itanium has 4 cpus 16gb memory. The databases are oracle9.2.0.4 and when a dba runs an identical query, the N-Class finishes 1hr 40 mins faster than the itanium. The N-Class also uses all 8 cpu's to 100% while the itanium only uses about 50% of all its cpus. The query he runs is:
exec sys.dbms_stats.gather_table_stats(ownname=>'UserName', tabname=>'TableName', degree => dbms_stats.default_degree)
Where should I look for in the system to find out why the run time has a pretty large range (1hr 40 mins) between the 2 servers? Basically, we want to understand that if we move our production database from the N-class to the itanium, will we benefit from this configuration or should we add more cpu/memory to the itaniums. Thanks J.D.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-28-2005 02:21 PM
тАО03-28-2005 02:21 PM
Solution* fragmentation of the data.
* How oracle's "plans" resolve the query.
* kernel parameters on the two boxes.
* SGA differences.
I recall hearing a story of how Oracle on a couple of fast Intel boxes was getting its hindquarters kicked in queries by an old K Class box.
Turns out the K class box was executing its queries in a totally different fashion. Just because they are the same query does not mean they are running the same.
If you run a trace or take alook at how the query is being resolved, you will see why the N class box is beating the Itaniums. If you optimize the rx4640 boxes you should be able to get them to outperform the N box.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-28-2005 02:43 PM
тАО03-28-2005 02:43 PM
Re: Differences in cpu utilization between rx4660 and N-Class
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-28-2005 04:20 PM
тАО03-28-2005 04:20 PM
Re: Differences in cpu utilization between rx4660 and N-Class
hmmmm 2) Memory and IO systems need to have 'enough' oomph before CPU power becomes important. Did both boxes offers similar IO?
If your applition reall used thse 32Gb, then 16GB will be a serious handicap!
Hmmm 2: analyze table would not seem to be a reasonable approximation for any reasonalble application. It just does a tablescan and some counting. So with would be IO bound, and use minimal CPU. Even the memory would not be too critical.
>> Where should I look for in the system to find out why the run time has a pretty large range (1hr 40 mins
How did the CPU times, withing that elapsed time, compare?
The only reall way to presict you application behaviour on the new box.. it to try the application!
Can you get a loaner/tester and do a trial migration? You want to do that anyway no?
- to make sure you actaully knwo how to do the migration in detail no?
- to make sure you get the procedures set up just right
- to have a good estimate on how long the real/finale migration will take
- to perform a performance evaluation.
Good luck,
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-28-2005 10:53 PM
тАО03-28-2005 10:53 PM
Re: Differences in cpu utilization between rx4660 and N-Class
To me this sounds like a classic IO bottleneck on the rx4640. That said, there is not enough info to say one way or the otehr!
Are the disksubsystem for the two systems the same? If different please say how.
1 - If you have OV PerformanceAgent (MeasureWare); then look at the IO statistics of the two boxes. I would focus on the service times to each LUN/Disk. also check
2 - If you do not have OVPA, look at "sar -d" stats; again looking at the IO rates of te two systems and the service times.
Regards
Tim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-29-2005 12:14 AM
тАО03-29-2005 12:14 AM
Re: Differences in cpu utilization between rx4660 and N-Class
I'd also ask if these are identical databases, how was the itanium version created. Dropped indexes or rule based vs cost based config change could be something to look at.
If export import was used, there are some paramters the DBA could have touched during the creation or the 'new' instance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-29-2005 01:26 AM
тАО03-29-2005 01:26 AM
Re: Differences in cpu utilization between rx4660 and N-Class
Another analogy - a freeway - you have 1 with 7 lanes + a maintenance lane - max speed 100 KM per hour. The Itanium freeway only has 3 lanes and a maintenance lane - max speed 120 KM per hour. Well...it does take a rocket scientist to see which freeway can push through the most traffic....
A final thought - on Itanium - did you re-compile your apps (if any)?
Rgds...Geoff
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-29-2005 04:37 AM
тАО03-29-2005 04:37 AM
Re: Differences in cpu utilization between rx4660 and N-Class
The databases are identical. Both are test machines that were restored from the same backup set from a production N-Class (same as the one in question). All the kernel parameters are the same. We did use glance to see how the cpu's are being used. The SGA settings may be a bit different since the #of cpu & amount of memory in the box. Some of the kernel parameters (ie. shmax) may be tweaked a bit toward the amount of physical memory in each box.
They are using the same physical RAID storage device (EMC CX600) using RAID5 but the NClass has its database spread over more RAID (7 RAID of 5 disks each) as opposed to the rx4640 (4 RAID of 5 disks each). So basically, smaller luns on more spindles vs bigger luns on less spindles.
The queries are done with no user sessions and our dba assures me that there is no writes done with this query. Our initial thinking is with newer technology = less but faster cpu = less $$cost that could run the same database.
But since the rx4640 is only using 50% of the cpu's shouldn't it try to use more power out of it since it has more reserved? Disk I/O on both machines is very minimal when the query is run. I'm still boggled what is preventing the database from using most of the cpus resource, making its query run longer? All comments welcome. Thanks, J.D.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-29-2005 04:56 AM
тАО03-29-2005 04:56 AM
Re: Differences in cpu utilization between rx4660 and N-Class
analyze the tables and schemas. This will help the database rebuild its statistical information and run its sql more efficiently.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-29-2005 05:16 AM
тАО03-29-2005 05:16 AM
Re: Differences in cpu utilization between rx4660 and N-Class
I'm having the dba do that and also analyze the oracle execution plans. I'm at the same time verifying which disks the 9 datafiles in the table are hitting on each machine. I'll keep everyone posted. Thanks, J.D.