I use a certain database solely for session state. The database says there's 25 mb in there, even when not in use. Yesterday my system yielded an error having to do with session state, probably because this database exceeded the storage allocated. I was able to allocate more storage to this database through the Winhost control panel, this solved the problem. I never had this problem before. Shouldn't the session state clear itself out? Why is 25mb sitting in there. I'm afraid eventually i'll have no more storage to allocate to it. I tried shrinking the database thru Management studio, but this helped only a little.
I should add that I deleted this database, then restored it, and I think it restored to a different machine. wonder if this matters.... I assume I can delete the records in the session database myself, but I'd like to know what happened.
