Advertisement

03.01.2006 at 02:31AM PST, ID: 21756019
[x]
Attachment Details

High Kernel usgae for sysbase server

Asked by cpc2004 in Sybase Database

Tags: high, kernel, aix, sybase, sysbase

Our sybase server have 4 sybase DBs and it has only two processors. One Sybase server (ie sybaseA) uses almost 5o% of CPU and our sybase setting only use 1 processor. Our servers reports slow response at business for the sybaseA and it uses almost 50% of the CPU. According to VMSTAT, the kernel time is almost 60% of CPU. My question why the kernel time is over so 60%. Does it related to sybase parameter setting? I want to find out the bottleneck of the sybase servers.

                                                                                               US SY WA ID
06/02/08 09:02:24  2 0 537916 4550 0 0 0 0 0 0 1722 57679 2502 22 70 0 8
06/02/08 09:32:25  2 1 539835 3608 0 0 0 0 0 0 1689 69463 2409 19 80 0 0
06/02/08 10:02:24  2 0 540296 5960 0 0 0 0 0 0 1302 90319 1762 16 80 0 4
06/02/08 10:32:24  2 0 541335 5396 0 0 0 0 0 0 1632 38547 2660 19 65 0 16

We are using AIX 5.2 ML04 and sybase 12.5.

Any comment is appreciated.Start Free Trial
[+][-]03.05.2006 at 05:24PM PST, ID: 16110650

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.05.2006 at 06:46PM PST, ID: 16111270

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.05.2006 at 11:41PM PST, ID: 16112298

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.07.2006 at 07:12PM PST, ID: 16130022

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.08.2006 at 12:45PM PST, ID: 16138171

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Sybase Database
Tags: high, kernel, aix, sybase, sysbase
Sign Up Now!
Solution Provided By: alpmoon
Participating Experts: 2
Solution Grade: A
 
 
[+][-]04.04.2006 at 07:27AM PDT, ID: 16371373

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]04.04.2006 at 11:47PM PDT, ID: 16378654

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.05.2006 at 05:52AM PDT, ID: 16380855

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.09.2006 at 02:13AM PDT, ID: 16410670

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32