>To scale a web application to run in a web farm environment, one option to managing sessions is through SQLServer. However, if a you try to store a dataset to a session, an error results "Object must be serializable..." Ironically, the MS docs indicate that the dataset is serializable. Yet ASP.NET thinks otherwise.
>
If there is any way possible, espesially if you are storing datasets in session to use InProc sessions and in your server farm use sticky IP's you will get much better performance.
See this webcast for more info:
http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032250622&Culture=en-USBOb