SQL Connection Timeout Questions

1

Frequency of witness pings to partners
Does anyone know how often the witness instance pings the partners? I am aware of the timeout setting but want to know exactly how often the ping is initiated. Is it the same or different from the timeout value. Thanks in advance for your reply.

Answer Question   |  May 4, 2011  6:59 PM
Network Timeout, SQL Connection Timeout, SQL Server 2005 SP3, SQL Server 2008 R2
asked by:
5 pts.

DOT NET SQL CONNECTION TIME OUT PROBLEM
IN MY SQL CONNECTION STRING I WAS MENTION CONNECTION TIME OUT IS 500. MY SQL PROCEDURE WAS RUNNING 45 SECONDS ONLY IN QUERY ANALYZER. ITS RUN ON DOT NET PROGRAM THEN CONNETION TIME OUT ERROR WAS COMMING.

Answer Question   |  April 21, 2010  4:53 AM
.NET, SQL connection, SQL Connection Timeout
asked by:
5 pts.

1