Re: Connection refusals

This sounds suspiciously like a full connection pool. Check out my
whitepaper on managing the connection pool on my site.
http://www.betav.com/sql_server_magazine.htm
I would write an application to monitor the pool or simply setup a
performance counter view on the counters exposed by ADO.NET. I expect that
you've missed a Connection Close in an exception handler.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"James Wren" <JamesWren@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:50D6E4FA-173A-4751-A2EC-A9F8549C7356@xxxxxxxxxxxxxxxx
Hi,

We have a 64bit SQL Server 16GB Memory running on Windows 2003 x64. This
is
one of our main business database servers. At this time we have an issue
where the server will stop allowing new connections in, the client will
receive a timeout (instantly) and from .NET the stack is

at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()

If the client keeps trying eventually they might get in but other
connection
attempts continue to fail. This lasts for about 10 minutes usually then
goes
away.

Occassionally when this happens the .NET AppDomain is unloaded and a new
one
is created. However this does not happen all the time and appears to be a
side-effect not the cause.

What I really would like some help on is what performance counters might
be
worth looking at.

This is an upgrade of a server with 4GB 32bit SQL Server on Win2003 32 bit
which never had these issues. No code has changed, there are 5 CLR Stored
procedures which have not changed.


Any pointers would be much appreciated.

Thanks

James Wren


.

Loading