on 07-29-2014 11:36 AM
SQL Anywhere 12.0.1.3797
Server: Windows server 2012, Intel Xeon CPU E5-2620 2.00 GHz, Windows 64 bits, 8 Gb ram
Workstation: Windows 7
SQL Anywhere is running as a service. 2 databases are started.
Client log in with a Powerbuilder Application ODBC connection.
User is entering data and everything works fine. After the input of about 10 lines, we suddenly have a delay of about 10 seconds. At this moment a sql command is send to the database to retrieve some data. We look at the taskmanager (on the server). Processor time of dbsrv12 is 0%, Processor time not active is about 80%. After the 10 seconds delay, the processor time of dbsrv12 increases to about 40% (for a few seconds to execute the sql command). After this, the user can continue. The next input of about 10 lines is very fast, and then we see the delay again.
Seems to me there is a hick-up in Windows system. The system administrator thinks its a sql anywhere problem since other programs run fine.
Whats the way to go to find out why we have this delay?
Thanks
Eric
Hi Eric,
I think your best opportunity to diagnose this issue is to take a look at Diagnostic Tracing, and possibly some of the other operating system performance counters - is there any disk activity against the database during these pauses? Can you see from the console log (-o) if there is any information (such as a checkpoint) surrounding the times that the pauses are seen?
Does it ever stabilize over time, or is it always after 10 seconds, "something happens"?
Regards,
Jeff Albion
SAP Active Global Support
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.