locked
ASP.NET SqlServer Session Mode, Personalization and Profiles with High Availability RRS feed

  • Question

  • User1035987145 posted

    Hello,

    I am using SQL Server Session Mode in by WebForms application. Also, I am using ASP.NET Personalization and Profiles. While using these features of ASP.NET, we provide the SQL Connection String in config files.

    Now, my question is that - Can we have "High Availability" feature for Session, Profile and Personalization databases of ASP.NET?. If the database goes down, then also the Session/Profile/Personalization features of application should not be affected. How can I achieve that?


    For, my appliation code, we have our custom code which handles the database calls while database failover occurs. But, we do not have control over database calls occurring for Session, Profile and Personalization. So, I am not sure, how I can do that.

    Please guide.

    Thanks and Regards,
    Alpesh Chavda.

    Wednesday, July 5, 2017 6:36 AM

Answers

  • User541108374 posted

    Hi,

    what could be used is the default in memory strategy (already faster than SQL Server) in combination with sticky sessions so that a call from a specific user always lands on the same server.

    Other ways are fail over strategies of SQL Server. Likely best to be discussed with your DBA's and infrastructure architects.

    Grz, Kris.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, July 5, 2017 7:12 AM
  • User-707554951 posted

    Hi alpeshataspnet

    As far as I know, High availability is a system design approach and associated service implementation that ensures a prearranged level of operational performance will be met during a contractual measurement period.

    And it could include multiple database and application server connected in a clustered environment with redundant hardware. One of the method to make ASP.NET application available even if one server goes down it so make your application connect to secondary db server in the even of failure to connect to first server.

    http://gaurangpatel.net/high-availability-in-asp-net-application

    https://www.farbeyondcode.com/Considerations-when-implementing-high-availability-for-a-web-application-5-2861.html

    Following article introduces several SQL Server high-availability solutions that improve the availability of servers or databases.

    A high-availability solution masks the effects of a hardware or software failure and maintains the availability of applications so that the perceived downtime for users is minimized.

    https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/high-availability-solutions-sql-server

    Best regards

    Cathy

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, July 6, 2017 7:00 AM

All replies

  • User541108374 posted

    Hi,

    what could be used is the default in memory strategy (already faster than SQL Server) in combination with sticky sessions so that a call from a specific user always lands on the same server.

    Other ways are fail over strategies of SQL Server. Likely best to be discussed with your DBA's and infrastructure architects.

    Grz, Kris.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, July 5, 2017 7:12 AM
  • User-707554951 posted

    Hi alpeshataspnet

    As far as I know, High availability is a system design approach and associated service implementation that ensures a prearranged level of operational performance will be met during a contractual measurement period.

    And it could include multiple database and application server connected in a clustered environment with redundant hardware. One of the method to make ASP.NET application available even if one server goes down it so make your application connect to secondary db server in the even of failure to connect to first server.

    http://gaurangpatel.net/high-availability-in-asp-net-application

    https://www.farbeyondcode.com/Considerations-when-implementing-high-availability-for-a-web-application-5-2861.html

    Following article introduces several SQL Server high-availability solutions that improve the availability of servers or databases.

    A high-availability solution masks the effects of a hardware or software failure and maintains the availability of applications so that the perceived downtime for users is minimized.

    https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/high-availability-solutions-sql-server

    Best regards

    Cathy

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, July 6, 2017 7:00 AM