Session state frequently ends up on a busy SQL Server. What seemed like a good idea in development turns into a problem in production. While there are valid business reasons for persisting session state to permanent storage; there are equally valid reasons to avoid using SQL Server as the permanent storage. We’ll investigate why session state poses problems for SQL Server and cover an alternate solution that allows for persistent session state. This talk is for developers and DBAs who want a better way to safely track ASP.NET session state.
What We Do:
SQL Critical Care®
If your SQL Server is too slow or unreliable, and you're tired of guessing games, we'll help.
In just 4 days, we find the root cause, explain it to you, and show you how to get pain relief. Learn more now.
Contact the Brent Ozar
team online or call:
It won't hurt.
PostgreSQL gets UPSERT (HT Michael Banck)
SQL Server Training
- In-Person Training Classes:
- Advanced Querying and Indexing
- The Senior DBA Class of 2015
- SQL Server Performance Troubleshooting
- Online Video Classes:
- Execution Plans
- DBA Interview Question and Answer Kit
- Developer's Guide to SQL Performance
- How to Tune Indexes
- Introduction to Internals
- SQL Server on VMware and SANs