|
|
| handheldmaster 2005-12-14, 11:23 am |
| Using asa9.02/windows2003
My db server process running almost at 100% .. Anyway suggestions to check
what is causing this ?
Is their any tools available that can say "this" connection is the culprit
or "this" sql command is the culprit and needs to be optimized.
Any other pointers appreciated
| |
| Pavel Karady 2005-12-14, 11:23 am |
| >
>Using asa9.02/windows2003
>My db server process running almost at 100% .. Anyway suggestions to check
>what is causing this ?
>
I suggest checking the loops - if any loop in your script is using the
following framework:
WHILE EndLoop='N' LOOP
SELECT Joseph;
IF Joseph>4 THEN EndLoop='Y';
END LOOP;
Then you can expect 100% CPU usage (if you shall discover that this is the
reason, here's a solution: putting the WAITFOR DELAY of at least 1 tenth of
second will drop the CPU usage to 1-2% with not noticeable performance
impact).
Pavel
| |
| Rob Waywell 2005-12-15, 9:23 am |
| 100% CPU utilization can just indicate that you are getting your money's
worth out of the hardware. The first question to consider is whether the OS
still responsive? Are other processes getting CPU time when they need it?
This can be checked by opening doing just about anything on the server. As
long as the OS is responsive and other processes are getting time, then it
suggests that the system is still healthy.
--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional
Sybase's iAnywhere Solutions
Please respond ONLY to newsgroup
EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all
To Submit Bug Reports:
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288
"handheldmaster" <abc@456.com> wrote in message
news:43a04100$1@foru
ms-2-dub...
> Using asa9.02/windows2003
> My db server process running almost at 100% .. Anyway suggestions to check
> what is causing this ?
>
> Is their any tools available that can say "this" connection is the culprit
> or "this" sql command is the culprit and needs to be optimized.
>
> Any other pointers appreciated
>
>
>
>
>
>
>
| |
| handheldmaster 2005-12-15, 1:23 pm |
| > As long as the OS is responsive and other processes are getting time, then
> it suggests that the system is still healthy.
>
Yes OS is responsive to other processes .. no users are complaining about
access speed as such. After adding a few indexes the cpu came down. thanks.
Does anyone know of any 3rd party performance viewing tools for important
parameters inside the ASA database and provide historical information over a
period of time .. trending kind of stuff.
| |
| Greg Fenton 2005-12-15, 8:23 pm |
| handheldmaster wrote:
>
> Yes OS is responsive to other processes .. no users are complaining about
> access speed as such. After adding a few indexes the cpu came down.
Have you tried running any of the following against your system:
- Index Consultant
- Request Level Logging analysis (sa_get_request_time
and
sa_get_request_profi
le)
- Procedure Profiling
greg.fenton
|
|
|
|