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.