- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Very high CPU utlization
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
тАО06-10-2004 03:39 AM
тАО06-10-2004 03:39 AM
Re: Very high CPU utlization
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-10-2004 03:44 AM
тАО06-10-2004 03:44 AM
Re: Very high CPU utlization
I created indexes, done update stat..
All my queries are taking only index paths only.
I done database fragmentaion also. I distributed across 14 dbspaces. My whole databse is of 10GB. After this only actuall i got good reslts...
Any way..Thnks to all of them who participated in this...
Iam working in perfomance tuning on unix from last 1 year. So i will start new threads like this every day..Please participate in them. I am planing for this..Every day one topic will be there..Show your inteligence..And i will give realtime results for your thinkings...
***Let us share the knowledge****
Bye,
Sree
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-11-2004 02:37 AM
тАО06-11-2004 02:37 AM
Re: Very high CPU utlization
The HP-UX Performance Cookbook has also been posted to this forum before but I guess I will attached again.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-11-2004 05:38 AM
тАО06-11-2004 05:38 AM
Re: Very high CPU utlization
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-11-2004 10:21 AM
тАО06-11-2004 10:21 AM
Re: Very high CPU utlization
A couple of things for you to look at
1 - what is the read:write ratio you should be reading more than writing. If not why are you writing data ypu will not read!!
2 - You say that you are using indexes everywhere. I hope you do not mean this 100%. For instance "select * from table where tag_id not like 100" is MOST efficient when sequentially scanning the table and avoiding the index.
3 - What are the service times on the disks? If the disks are slow then informix/application may be waiting on the slow disk. striping etc may help (depend on result)
4 - when you do "onstat -g glo" the cpu-vp's should be using the most resource, then aio-vps, everything else should be way below these. Make sure your shm-vp & soc-vp (if they exist) are NOT heavy uses of resource. If they are, then move the poll threads to the cpu-vps. From what you said you should have 8-9 cpu-vps & i'd use 8-9 poll threads of the appropriate protocol.
5 - lastly.. and probably should have been top of the list. Are you getting the workload out you hoped for? If so then Bils comment is on-the-button. Though I personally do not like to see cpu's above 80% on a regular basis as I like to have something in my back pocket!! (now I get the sales speach on iCOD.. I do know about this, just have not used it)
Regards
Tim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-11-2004 08:02 PM
тАО06-11-2004 08:02 PM
Re: Very high CPU utlization
1.The disk service time is less as iam fragmenting the tables across 12 db spaces which lie on diffrent disks. And keeping indexes across 4 db spaces. As aim using EVA SAN it will do striping by default.
If i watch dbspace utilization on onperf tool, all db spaces are utilizing uniformly.
Can you say what is the maximum number they can go. I mean no of read / wrties per second. By this i can conferm that disk is ok.
2. I checked onstat -g glo.. in that i observed
soc 41.19 461.68 502.87
soc 41.57 220.52 262.09
soc 42.56 230.36 272.92
soc 42.22 225.04 267.26
soc 43.88 236.15 280.03
soc 41.65 223.41 265.06
Can u coment anything on this...
3. Up to know glance plus was showing network bottelneck. Now after putting seperate test lan. It is solved.
***Problem is problem until u feel that is not a problem****
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-12-2004 02:41 AM
тАО06-12-2004 02:41 AM
Re: Very high CPU utlization
skipping to the onstat -g glo..
you have 6 soc-vps evenly loaded(ish) What are the cpu-vps load in comparison? This is the key to tuning BALANCING the load. The best thing to post is the whole "onstat -g glo", but if you feel this is too much just the top bit which summarises the spead of the workload... to me your system should probably be optimised for local access (shared memory) and I'm guessing. If this is the case why do you have 6 soc-vps. My guess is that you may effectively have erronously assigned the soc-vps to the network vps (soc)
NETTYPE ipcshm,9,100,CPU
NETTYPE soctcp,6,100,CPU
NUMCPUVPS 9
This will assign the first 9 cpu-vps with shm-poll threads (sm_poll). The 6 socket poll threads WILL NOT go onto the cpu-vps so will end up as soc-vps (as yopu have). If this is you will need to decide what the split of shm connections & soc connections. say 2/3 1/3 split I would do the follwoing
NETTYPE ipcshm,6,100,CPU
NETTYPE soctcp,3,100,CPU
NUMCPUVPS 9
now all the poll threads will get onto each of the CPU-vps.
so to summarise
1 - onstat -g glo (the whole thing please)
2 - onstat -c or ONCONFIG would also be useful..
Timmmmy
- « Previous
-
- 1
- 2
- Next »