What are the precautions you will take in order that SQLSERVER

Q

What are the precautions you will take in order that SQLSERVER Mode work properly ?

✍: Guest

A

Following are the things to remember so that SQLSERVER Mode works properly :-

SQLSERVER mode session data is stored in a different process so you must ensure that your objects are serializable.
IIS metabase (\LM\W3SVC\2) must be identical across all servers in that farm.
By default Session objects are stored in gTempdbh, you can configure it store outside gTempDBh by running Microsoft provided SQL script.

Note :- TempDB database is re-created after SQL SERVER computer reboot.If you want to maintain session state with every reboot best is to run SQL Script and store session objects outside TempDB database.

2007-10-23, 4220👍, 0💬