SQL Server ASPState Session Management - improving performance

SQL

Recovery Model

Make sure ASPState is set to simple recovery – this will dramatically reduce the impact to the log that can be caused by the high volume of (transient and largely disposable) writes that are likely to go here:

ALTER DATABASE ASPState SET RECOVERY SIMPLE;

Usually this database does not need to be in full recovery, especially since if you are in disaster recovery mode and restoring your database, the last thing you should be worrying about is trying to maintain sessions for users in your web app – who are likely to be long gone by the time you’ve restored. I don’t think I’ve ever come across a situation where point-in-time recovery was a necessity for a transient database like ASPState.

Previous
Previous

Top 10 tips to improve SQL Server Query performance

Next
Next

PC Pro Podcast 252