ASP.NET SqlServer Session Replication

Question

Curious whether folks have setup 2 way transactional replication on the tables ASP.NET uses for SqlServer stored session state (ASPStateTempSessions and ASPStateTempApplications) and the tables used for membership, role, and personalization? How did it work out? Were there any gotchas?

Answer 1

For Membership, you are probably fine with Replication, alhtough a cluster might be better for scale. For state, I would be more inclined to use a cluster.

I would say the exception to this is when you have a geographically separated set of servers, but it is rare to have websites, except for some of the largest, geographically separated out.

Have I ever done replication on state or membership tables? no.