We have already discussed few things on the SQL Server
Session management and it seems like a mix of both good and bad. We need to be
careful from the performance point of view while storing the values in session.
Unnecessary dumping of objects into sessions may lead to performance hazards.
So, just put enough thought into it before going for the SQL Server Session
management.