468,117 Members | 1,476 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,117 developers. It's quick & easy.

ASP.NET w/ SQL Server Sessions & Cluster Failover

Is there an elegant way to clear out the ADO connection pool used by the SQL
Server State Service following a cluster failover?

We are using a SQL Cluster to store both the ASP Session State database and
our application database.

When the SQL Server cluster is failed-over, any "pointers" to the live
connections stored in the connection pool are made invalid. When the
application tries to reference these "damaged" connections, it throws an
exception, and the pooling mechanism drops the bad connections from the
pool.

In our application, we are using a looping try/catch block to clear out the
bad connections from the pool following a failover, and the users typically
are not affected by the failover as a result of any exceptions in our
application code.

However, we don't have access to the source code for managing the ASPState
connections. It appears as though there is no mechanism for the ASPState
database to clear out the bad connections from the pool following a
failover, and thus the exceptions are affecting users.

Is SQL Server Session State Management even supposed to work with a SQL
Cluster?

Mike Olund
OpenRoad Communications
Nov 18 '05 #1
1 2852
there is support in asp.net 2.0, the supported method in asp.net 1.1 is to
change the connection string (thus not reusing any old connections).

if you want an unsupported method, you can use reflection to call an
undocumented method.

(http://www.sys-con.com/dotnet/article.cfm?id=483)
-- bruce (sqlwork.com)

"news.microsoft.com" <mo****@oroad.com> wrote in message
news:Oe*************@TK2MSFTNGP12.phx.gbl...
Is there an elegant way to clear out the ADO connection pool used by the SQL Server State Service following a cluster failover?

We are using a SQL Cluster to store both the ASP Session State database and our application database.

When the SQL Server cluster is failed-over, any "pointers" to the live
connections stored in the connection pool are made invalid. When the
application tries to reference these "damaged" connections, it throws an
exception, and the pooling mechanism drops the bad connections from the
pool.

In our application, we are using a looping try/catch block to clear out the bad connections from the pool following a failover, and the users typically are not affected by the failover as a result of any exceptions in our
application code.

However, we don't have access to the source code for managing the ASPState
connections. It appears as though there is no mechanism for the ASPState
database to clear out the bad connections from the pool following a
failover, and thus the exceptions are affecting users.

Is SQL Server Session State Management even supposed to work with a SQL
Cluster?

Mike Olund
OpenRoad Communications

Nov 18 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Chris Gatto | last post: by
2 posts views Thread by Jay Balapa | last post: by
4 posts views Thread by Ronald Green | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.