SQL Server ASPState Session Management – improving performance

S

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.

Add Comment

Leave a Reply

By RMTWeb

Archive

Tags

Get in touch

I'm available on just about every social media platform out there as RMTWeb.