SQL Server 2008 Sessions

We are extremely new to ASP.net...actually working with an outside consultant which I don't currently have access to.

I am looking for:

1. Good documentation/best practices for ses开发者_如何学Gosion and session management. I'm finding some info now: http://support.microsoft.com/kb/317604

2. Review of application below for comments about how to best handle this scenario.

We have the following scenario:

1. OEM machine on floor providing status UPDATES every x.x seconds to Device_Status table.
2. When ASP.net client/user wants to view status of a particular machine, I want to notify the OEM machine on the floor to increase update rate to near real-time. Potentially with "realtimeupdate" flag in Device_Status table.
3. When ASP.net client/user moves on or logs out, update rate needs to return to x.x seconds.

Since we are very new to ASP.net, we don't have any clue about sessions and session management or if it is possible.

The only problem I see so far is if the ASP.net client connection is terminated prior to setting the "realtimeupdate" flag to 0. If this happens, the OEM machine will continue to provide real-time updates when they are no longer needed.

you can't count on a browser (or the user) to say "hey I'm done". People walk away from thr PC, surf to stackoverflow.com, hit the X to close the browser, etc. you'll need to code your web page to request "live" frequency with every page refresh. and have some independent server process turn off the "live" frequency if you don't get a page refresh asking for "live" frequency after some set amount of time. In addition to your page turning it off if the user asks for that.