Connection Speed

Is there any known connection speed level where a low connection speed will
cause an application to not connect to sql server? I periodically have
problems with applications connecting to the sql server and the only thing I
have noticed is that when this is occuring the speed on the network is very
slow. It is about 3200 kbs.It is not an issue of speed, but how much bandwidth is available to your
application.
Connecting to SQL server on a 16kbit modem is possible, not if you are
trying this whilst mail is downloading and you are surfing 5 sites.
I would not try anything slower than 9.6kbit. It might bet irritating.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"John" <noEmail@.yahoo.com> wrote in message
news:eIZH#1UDFHA.3596@.TK2MSFTNGP12.phx.gbl...
> Is there any known connection speed level where a low connection speed
will
> cause an application to not connect to sql server? I periodically have
> problems with applications connecting to the sql server and the only thing
I
> have noticed is that when this is occuring the speed on the network is
very
> slow. It is about 3200 kbs.
>|||Does anyone have an article where microsoft talks about the amount of
bandwidth required for connecting? I would like some documentation to show
the higher ups.
Thanks

Connection Reset

Hi all

I have build an application on top of SQL Server 2005 and i am using microsoft driver. My application stops periodically becoz of Database Connection Loss and I get the following exception

com.microsoft.sqlserver.jdbc.SQLServerException: An exception occurred during the DBComms.transmit operation. Exception:Socket closed. Context:(5) [Thread[Thread-55,5,main], IO:7e2dc, Dbc:null].
10:06:14:703 AM at com.microsoft.sqlserver.jdbc.SQLServerException.ma keFromDriverError(Unknown Source)
10:06:14:703 AM at com.microsoft.sqlserver.jdbc.DBComms.transmit(Unkn own Source)
10:06:14:703 AM at com.microsoft.sqlserver.jdbc.IOBuffer.sendCommand( Unknown Source)
10:06:14:703 AM at com.microsoft.sqlserver.jdbc.SQLServerStatement.se ndExecute(Unknown Source)
10:06:14:703 AM at com.microsoft.sqlserver.jdbc.SQLServerStatement.do ExecuteQuery(Unknown Source)
10:06:14:703 AM at com.microsoft.sqlserver.jdbc.SQLServerPreparedStat ement.executeQuery(Unknown Source)

Unable to find the exact reason for the above problem. Pl advice

Thanks & Rgds
RoshiniIt apppears to me that you get some kind of timeout, and the connection is closed, but I might be proven wrong. Nevertheless, you should handle such cases, as this may happen even in the most critical high availability solutions, for instance if a SQL Server Cluster is failing over. Applications should be able to reconnect automagically.