1

We are migrating a number of the 2008 Windows clusters to the 2016 servers and consolidating databases in the same AlwaysOn cluster. Our dev teams are currently using ASPState databases specific to their application. As a rule it's only one ASPState database per server but we need it to be able to accommodate multiple Web applications.

Questions

  1. Is it possible to use one ASPState with multiple Web applications? If it is, then how?
  2. Should this ASPState database be a part of the AG group? If it's part of the one AG than other AG's won't be able use it.
1

As a rule it's only one ASPState database per server but we need it to be able to accommodate multiple Web applications.

Your company just dictated your answers and infrastructure, sadly.

Is it possible to use one ASPState with multiple Web applications? If it is, then how?

Apparently so:

  1. Stack Overflow Answer
  2. Maybe it is or isn't a good idea?

Should this ASPState database be a part of the AG group?

If you're going to use AGs then it doesn't have to take part in it but it'll need to be loaded and properly setup on all replicas. If you put it in an AG, then you'll only have a single AG for all applications which may or may not be a good thing, depending on the application requirements.

Since the ASP state database is really just about throw away session state data, if there is a failover it won't make a real difference.

If it's part of the one AG than other AG's won't be able use it.

That's true. If it's not in an AG but loaded on each replica by itself not in an AG that should work as I reference above.

0

Great answers. Using these and other information from Erin in SQLSkills, I replicated the same ASPState database on each of the replicas. I have also converted the ASPState into in-memory databases, tables - Schema_Only, and backups to NULL. Works really fast.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.