|
Home > Archive > SQL Anywhere database > July 2005 > ASA 9, Pervasive SQL interaction
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
ASA 9, Pervasive SQL interaction
|
|
| Bill Saffin 2005-07-14, 1:23 pm |
| I have a client running my application (ASA 9 database) and they're having
problems with the application becoming unresponsive at times. They're also
running an accounting package (Pervasive SQL) at times, and the "hanging"
problem seems to be worse when it's running.
Has anybody had any experience of this kind of interaction between two
database servers? Any ideas to solve?
| |
| Greg Fenton 2005-07-14, 8:23 pm |
| Bill Saffin wrote:
> I have a client running my application (ASA 9 database) and they're having
> problems with the application becoming unresponsive at times. They're also
> running an accounting package (Pervasive SQL) at times, and the "hanging"
> problem seems to be worse when it's running.
I cannot think of anything that Pervasive could to to interfere with
SQLAnywhere other than resource contention. Can you check the CPU,
disk, memory and network when one of these slowdowns is occuring to
determine if something is being maxed out?
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
| Breck Carter [TeamSybase] 2005-07-14, 8:23 pm |
| I agree with Greg... Pervasive and ASA may be competing for CPU and/or
memory but there should not be any direct interference.
What does Task Manager say?
Breck
On 14 Jul 2005 13:20:33 -0700, Greg Fenton
<greg. fenton_NOSPAM_@ianyw
here.com> wrote:
>Bill Saffin wrote:
>
>
>I cannot think of anything that Pervasive could to to interfere with
>SQLAnywhere other than resource contention. Can you check the CPU,
>disk, memory and network when one of these slowdowns is occuring to
>determine if something is being maxed out?
>
>greg.fenton
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
|
|
|
|
|