I have a problem with one customer, that I cannot solve: We installed SQL Anywhere 11 for 10 clients and the clients with old pcs with Windows Xp can work normally, but the connection form the new pcs with Windows 7 are so slow, that no one can work. Our programs need there about 20 seconds to start and select commands in dbisqlc need always more than 5 seconds for the smallest tables.

We tried once the same installation with Sybase 9, but it was the same effect.

Here is a logging from a Windows XP client:

Fre Feb 17 2012 09:33:29
09:33:29 Verbindungsversuch mit:
UID=rislogin;DBN=icline45;ENG=FXL-SERVER8;ASTOP=NO;INT=NO;DBG=NO;LOG=c:icline45sysmsgclientlog_xp.txt;LINKS='tcpip {Host=FXL-SERVER8;DoBroadcast=No}'
09:33:29 Verbindungsversuch mit einem laufenden Server...
09:33:29 Start der TCPIP-Verbindung wird versucht ...
09:33:29 TCP mit Winsock Version 2.2
09:33:30 Meine IP-Adresse ist 192.168.1.180
09:33:30 Meine IP-Adresse ist 127.0.0.1
09:33:30     TCPIP-Verbindung erfolgreich gestartet
09:33:30 TCPIP-Verbindung wird versucht (Adresse 192.168.1.13:2638 im Cache sasrv.ini gefunden)
09:33:30 Server mit dem Namen fxl-server8 wird gesucht
09:33:30 Server wird an der Adresse FXL-SERVER8 gesucht
09:33:30 Server gefunden, Servername wird überprüft
09:33:30 Datenbankserver an Adresse 192.168.1.13:2638 gefunden
09:33:30 Datenbankserver fxl-server8 auf Verbindung TCPIP gefunden
09:33:30 Verbunden unter Verwendung von Clientadresse 192.168.1.180:1293
09:33:30 Verbunden mit Server über TCPIP an der Adresse 192.168.1.13:2638
09:33:30 Verbunden mit SQL Anywhere Server Version 11.0.1.2472
09:33:30 Hinweise zur Anwendung:
09:33:30 IP=192.168.1.180;HOST=NTRATZ;OSUSER=mboelian;OS='Windows XP Build 2600 Service Pack 3';EXE=C:ICLine45BindirRISSTART.EXE;PID=0x184;THREAD=0xd28;VERSION=11.0.1.2436;API=DBLIB;TIMEZONEADJUSTMENT=60
09:33:30 Verbunden mit dem Server, Verbindung mit einer laufenden Datenbank wird versucht...
09:33:30 [  182] Verbindung mit der Datenbank erfolgreich eingerichtet

Here is a logging from a Windows 7 client:

Fre Feb 17 2012 09:37:09
09:37:09 Verbindungsversuch mit:
UID=rislogin;DBN=icline45;ENG=FXL-SERVER8;ASTOP=NO;INT=NO;DBG=NO;LOG=c:\icline45\sysmsg\clientlog_w7.txt;LINKS='tcpip {Host=FXL-SERVER8;DoBroadcast=No}'
09:37:09 Verbindungsversuch mit einem laufenden Server...
09:37:09 Start der TCPIP-Verbindung wird versucht ...
09:37:09 TCP mit Winsock Version 2.2
09:37:09 Meine IP-Adresse ist 192.168.1.183
09:37:09 Meine IP-Adresse ist ::1
09:37:09 Meine IP-Adresse ist 127.0.0.1
09:37:09     TCPIP-Verbindung erfolgreich gestartet
09:37:09 TCPIP-Verbindung wird versucht (Adresse 192.168.1.13:2638 im Cache sasrv.ini gefunden)
09:37:09 Server mit dem Namen fxl-server8 wird gesucht
09:37:09 Server wird an der Adresse FXL-SERVER8 gesucht
09:37:09 Server gefunden, Servername wird überprüft
09:37:09 Datenbankserver an Adresse 192.168.1.13:2638 gefunden
09:37:09 Datenbankserver fxl-server8 auf Verbindung TCPIP gefunden
09:37:09 Verbunden unter Verwendung von Clientadresse 192.168.1.183:49269
09:37:09 Verbunden mit Server über TCPIP an der Adresse 192.168.1.13:2638
09:37:14 Verbunden mit SQL Anywhere Server Version 11.0.1.2472
09:37:14 Hinweise zur Anwendung:
09:37:14 IP=192.168.1.183;HOST=PC-NTRATZ;OSUSER=ntratz;OS='Windows XP Build 2600 Service Pack 3';EXE=C:\icline45\bindir\risstart.exe;PID=0xb00;THREAD=0x348;VERSION=11.0.1.2436;API=DBLIB;TIMEZONEADJUSTMENT=60
09:37:14 Verbunden mit dem Server, Verbindung mit einer laufenden Datenbank wird versucht...
09:37:14 [  185] Verbindung mit der Datenbank erfolgreich eingerichtet

You can see that there is a period about 5 seconds in the slow process between the TCPIP connection and the trailing server connection.

Has anyone an idea about this case?

asked 17 Feb '12, 07:09

afgun's gravatar image

afgun
61116
accept rate: 0%

edited 17 Feb '12, 09:51

Breck%20Carter's gravatar image

Breck Carter
26.9k440613886

Why does it say OS='Windows XP Build 2600 Service Pack 3' for both?

(17 Feb '12, 09:54) Breck Carter

Just a hint: In case you prefer English log messages (at least to help the primarily English-based community to understand your logs), the following FAQ tells how to do so (temporarily):

"How to get an English error message"

(17 Feb '12, 10:19) Volker Barth

THE SOLUTION IS: - cmd as an administrator - netsh interface tcp set global autotuninglevel=disabled - reboot

permanent link

answered 08 Mar '12, 04:18

afgun's gravatar image

afgun
61116
accept rate: 0%

So you're saying it wasn't an IPv6 related problem?

(08 Mar '12, 05:03) Volker Barth

The issue seems related to IPv6, which is enabled by default on Windows 7.

"::1" would be the IPv6 loopback address.

I would try to disable that or specify the MyIP protocoll option to just use the IPv4 address...

Cf. this doc.

permanent link

answered 17 Feb '12, 10:04

Volker%20Barth's gravatar image

Volker Barth
31.4k316458676
accept rate: 32%

edited 17 Feb '12, 10:11

in second log, strange row: 09:37:09 Meine IP-Adresse ist ::1

May be ethernet configuration in this PC has mistakes. Try to resolve situation with this strange ::1 interface.

permanent link

answered 17 Feb '12, 09:58

AlexeyK77's gravatar image

AlexeyK77
70761224
accept rate: 8%

edited 17 Feb '12, 10:00

The value ::1 is the IPv6 equivalent of the IPv4 address 127.0.0.1 which is "localhost"

(17 Feb '12, 10:09) Breck Carter

Are you sure Windows 7 is involved?

Is there a dual-boot or VM involved?

Both logs say OS='Windows XP Build 2600 Service Pack 3'

If the client was running Windows 7 the second log would say something like OS='Windows 7 Build 7601 Service Pack 1'

permanent link

answered 17 Feb '12, 10:16

Breck%20Carter's gravatar image

Breck Carter
26.9k440613886
accept rate: 21%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×22

question asked: 17 Feb '12, 07:09

question was seen: 2,959 times

last updated: 08 Mar '12, 05:03