Solved

when running mpstat or vmstat in solaris, sys is using the cpu alot more than usr.  How can I find out what the system is doing and why it is hogging up the resources, slowing the system down.

Posted on 2008-10-24
3
899 Views
Last Modified: 2013-12-27
I am running SQL Remote Sybase replication process on Solaris 10.  The hardware is a V880 with 8CPU and 32GB memory.  WHen the process gets to "writetext", mpstat shows that sys is using more of the cpu than usr, and the server is very slow, even to type simple commands.  How can I tell what the sys is doing?  Any ideas how I can track this?
0
Comment
Question by:Blademonkey
3 Comments
 
LVL 11

Accepted Solution

by:
jgiordano earned 125 total points
ID: 22801034
Did you try using truss?

Or even dtrace since it is solaris 10?

here are some dtrace tools http://www.brendangregg.com/dtrace.html#Scripts

this dtrace script might be helpful - http://www.brendangregg.com/DTrace/lostcpu.html

0
 
LVL 1

Author Closing Comment

by:Blademonkey
ID: 31509866
Thank you very much!!
0
 
LVL 19

Expert Comment

by:grant300
ID: 22805030
Writetext usually means it is stuffing CLOBs or BLOBs into the database.  If you do not have any BLOBs or CLOBs in your schema, you can tune out now since this cannot be the problem.  The SYS time is all the driver level activity trying to get things to disk.  On Linux, you can see this as a bunch of I/O wait time.

Solaris is a very conservative operating system which is good for enterprise applications.  Unfortunately, it does some things in the name of stability that are not particularly helpful for database performance.  One of those is to, by default, turn off on-disk write caching.  This has an inordinately high impact on disk write performance, particularly for long sequential I/Os like file copies and continuous database writes to disk.

Fortunately, you can turn on-disk (the controller board bolted to the disk drive itself) caching at the Solaris driver level.  I don't recall the specifics but I have lived this problem before and the results are like night and day.  Definitely worth the time to track down the method for doing this.

BTW, ASE 12.5 was not all that stable.  v12.5.1 is the earliest release I would recommend.

Regards,
Bill
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

My previous tech tip, Installing the Solaris OS From the Flash Archive On a Tape (http://www.experts-exchange.com/articles/OS/Unix/Solaris/Installing-the-Solaris-OS-From-the-Flash-Archive-on-a-Tape.html), discussed installing the Solaris Operating S…
Java performance on Solaris - Managing CPUs There are various resource controls in operating system which directly/indirectly influence the performance of application. one of the most important resource controls is "CPU".   In a multithreaded…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now