SharePoint Session Management - which SQL Server option?

Posted by frumious on Server Fault See other posts from Server Fault or by frumious
Published on 2010-06-09T11:12:53Z Indexed on 2010/06/09 11:23 UTC
Read the original article Hit count: 208

Filed under:
|
|
|
|

We're developing some custom web parts for our WSS 3 intranet, and have just run into something we'd like to use ASP.NET sessions for. This isn't currently enabled on the development server. We'd like to use SQL Server as the storage mechanism, because the production environment is a web farm with very simple load-balancing.

There are 3 options you can choose from to set up the SQL Server session storage, tempdb, default separate DB, named DB. Both tempdb and default separate DB create a new DB to store certain information in; tempdb stores the actual session info in tempdb, which doesn't survive a reboot, and default separate DB stores everything in the new DB. Since you've got to create the new DB either way, my question is this: why would you ever choose to store the session info in tempdb? The only thing I can think of is if you'd like to have the ability to wipe the session by rebooting the server, but that seems quite apocalyptic!

© Server Fault or respective owner

Related posts about sql-server

Related posts about sharepoint