Last post Oct 21, 2015 12:31 AM by Rovastar
Oct 14, 2015 02:03 PM|mwise11|LINK
I have a webfarm named webfarm-A using shared configuration (not replication). Each node in the farm is pointing at the SQL server ASPState database for session state. I have been tasked to create an additional webfarm called webfarm-B. Is it a good idea
to point webfarm-B at the same ASPState database that webfarm-A is using? Should webfarms share ASPState databases?
Oct 15, 2015 02:17 AM|Weibo Zhang|LINK
By default, the Aspnet_regsql.exe tool will create a database named ASPState containing stored procedures that support SQLServer mode. Session data itself is stored in the tempdb database by default. You can optionally use the -sstype option to change the
storage location of session data. “-sstype c” with the “-d option” could specify the SQLServer mode database. For more things, please refer to the following article. If you have any issues that is the same with this issue, you’d better post them
here to get more professional suggestions.
This is the ASP.NET SQL Server Registration Tool that you should read them carefully when you implement the SQL Server session state in a web farm.
I hope it’s useful to you.
Oct 21, 2015 12:31 AM|Rovastar|LINK