Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
SQL Anywhere 10 CPU Usage
74 views
Skip to first unread message
jonowens
Oct 21, 2009, 2:25:54 PM10/21/09
to
We have a user who recently upgraded to SQL Anywhere 10,
Version 10.0.0.3722 from ASA Version 9.0.2.3137. Since
they've upgraded (about 3 weeks ago), they've noticed that
the dbsrv10.exe is continually using about 25% of their CPU
and occasionally (about once per week so far) it goes up
close to 100% for no apparent reason. When that has
happened, all of the apps on that server get very slow so
they've stopped the Sybase service and then restarted it.
Upon restarting, the CPU usage returns to 25% again but
otherwise they can process without any issues. They are
using a Windows 2003 Server, Service pack 1. We have many
other users using version 10.0.0.3722 without experiencing
similar problems. Any ideas on what may be causing the
excessive CPU usage or what we could do to rectify the
problwm?
Version 10.0.0.3722 from ASA Version 9.0.2.3137. Since
they've upgraded (about 3 weeks ago), they've noticed that
the dbsrv10.exe is continually using about 25% of their CPU
and occasionally (about once per week so far) it goes up
close to 100% for no apparent reason. When that has
happened, all of the apps on that server get very slow so
they've stopped the Sybase service and then restarted it.
Upon restarting, the CPU usage returns to 25% again but
otherwise they can process without any issues. They are
using a Windows 2003 Server, Service pack 1. We have many
other users using version 10.0.0.3722 without experiencing
similar problems. Any ideas on what may be causing the
excessive CPU usage or what we could do to rectify the
problwm?
Breck Carter [TeamSybase]
Oct 22, 2009, 9:06:14 AM10/22/09
to
You might find Foxhound to be helpful in pinpointing the cause, or try
using the Application Profiling facility in Sybase Central.
using the Application Profiling facility in Sybase Central.
Breck
http://www.risingroad.com/foxhound/index.html
--
Breck Carter http://sqlanywhere.blogspot.com/
RisingRoad SQL Anywhere and MobiLink Professional Services
breck....@risingroad.com
jonowens
Oct 27, 2009, 11:38:46 AM10/27/09
to
Thanks Breck. Can you provide me the registration key?
Breck Carter [TeamSybase]
Oct 28, 2009, 6:32:01 AM10/28/09
to
Send me an email, I will reply with a key.
breck dot carter at gmail
breck dot carter at gmail
Breck
0 new messages