Explain the Limitations & Issues with Automatic SQL Server State Management?
Although using SQL Server to store your session state relieves you of many difficult development issues, youll still need to consider some important limitations:
Youre limited to SQL Server.
This technique can only use SQL Server, no other server database. If you do not have a SQL Server installation available, you will be unable to use this solution.
Performance may suffer.
Like any of the state management techniques, using SQL Server to manage your applications state can cause your performance degrade a little. Because it takes a little bit of time to make a connection and read and write state information in the database, theres no avoiding a small bit of overhead.