Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

unexplained delay when connect to sql server

0 views

Skip to first unread message

Cecil Sheng

unread,

Jul 4, 2003, 6:36:52 AM7/4/03

Dear all,

we've met a problem in our java application. using latest MS
JDBC driver, and running on windows 2000 server with sun jdk 1.4.1_01.
it takes VERY long time when connecting to sql server. does anybody
knows its reason?
--
Cecil Sheng <cecil...@foquest.com.tw>

Joseph Weinstein

unread,

Jul 4, 2003, 12:30:08 PM7/4/03

to Cecil Sheng

Cecil Sheng wrote:

> Dear all,
>
> we've met a problem in our java application. using latest MS
> JDBC driver, and running on windows 2000 server with sun jdk 1.4.1_01.
> it takes VERY long time when connecting to sql server. does anybody
> knows its reason?

Hi. Very likely it's the network or DBMS. If you switch back to the previous
driver, is it faster now?

>
> --
> Cecil Sheng <cecil...@foquest.com.tw>

Bill Cheng [MSFT]

unread,

Jul 7, 2003, 12:14:16 PM7/7/03

Hi Cecil,

I would suggest that you open an incident with Microsoft Product Support
Services via
http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS, so that
we can have dedicated engineer to assist you. Issues with JDBC driver are
usually difficult to troubleshoot in newsgroups.

Have you checked raw connectivity speed from the problematic computer? If
you use Query Analyzer on the problematic computer, does it take long time
to connect to SQL Server and run queries? What are the CPU utilization and
memory when the problem occurred?

This posting is provided "AS IS" with no warranties, and confers no rights.

Regards,

Bill Cheng
Microsoft Support Engineer
--------------------
| Date: Fri, 04 Jul 2003 18:36:52 +0800
| From: Cecil Sheng <cecil...@foquest.com.tw>
| Subject: unexplained delay when connect to sql server
| X-Mailer-Plugin: Cliche Inserter for Becky!2 Ver.0.03 Rev.0, Popup
Memopad for Becky!2 Ver.0.03 Rev.2
| Message-ID: <20030704181511....@foquest.com.tw>
| MIME-Version: 1.0
| X-Mailer: Becky! ver. 2.06.02 with BkNews Plug-In Ver. 2.0
| Content-Type: text/plain; charset="US-ASCII"
| Content-Transfer-Encoding: 7bit
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| NNTP-Posting-Host: 211-23-128-217.hinet-ip.hinet.net 211.23.128.217
| Lines: 1
| Path: cpmsftngxa09.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: cpmsftngxa09.phx.gbl microsoft.public.sqlserver.jdbcdriver:445
| X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver

0 new messages