By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,369 Members | 1,147 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,369 IT Pros & Developers. It's quick & easy.

ASP.NET w/ SQL Server Sessions & Cluster Failover

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.