cancel
Showing results for 
Search instead for 
Did you mean: 

SQL anywhere 12.0.1.3797 delay

eric_verhorstert
Explorer
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

jeff_albion
Employee
Employee
0 Kudos

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


Answers (0)