dbTalk Databases Forums  

99% of CPU usage

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss 99% of CPU usage in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ivan
 
Posts: n/a

Default 99% of CPU usage - 01-28-2010 , 11:44 AM






We have 6 servers that have the same configurations.
Each server runs 16 instances of the same application to
access databases. Dbsvr8 is setup as a service on each
server. At startup, each instance of the application
connects to 2 databases with protocol of SHMEM.
Randomly, for any of these servers, dbsvr8 shows using 99%
of CPU. We don’t know exactly what causes it to take up
99% of CPU, and when this happens, nothing works (can’t
run application, can’t connect to the Sybase database…).
To solve the problem, I can kill dbsvr8 from Task Manager
(it’s setup to restart automatically). Once I do that and
restart applications, then everything will return to normal.

We tried to log with –z, but that fills up the log file
before the problem shows up (the huge log file actually
caused some problems).

The specs of the machines are as followed:

Dell Server PER710
Intel Xeon CPU x5570 @2.93GHz (2 processors)
32 GB RAM

Windows Server 2008 standard
64 bit operating system

Sybase dbsvr8 version 8.0.2.4372

Any suggestions to figure out this problem?
Thanks.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.