SQL Server with Mr. Denny:

Session State


February 24, 2011  2:00 PM

ANSI Settings can have all the difference in the world.

Posted by: Denny Cherry
Session State, SQL Server

So a little while back we noticed that we had some high CPU load coming from a single stored procedure in the Session State database.  This single procedure (TempUpdateStateItemLong) was taking up 80% of the CPU time that the database was using (we used Spotlight for SQL Server Enterprise from...

January 6, 2011  2:00 PM

Lets get session state out of the database, and into memory where it belongs.

Posted by: Denny Cherry
Paul Randal, Session State, SQL Server

One of the all to common configuration mistakes that are made is to put the session state within the SQL Server when a website begins to scale to multiple web servers. Some background For those that don't know what session state is, let me take a step back and fill you in. ...

July 6, 2009  11:00 AM

IIS 7 and Session State

Posted by: Denny Cherry
IIS 7, Session State, Windows 2008

While working on moving my companies data center from Texas to California we ran across an issue with IIS 7 on Windows 2008 because we were using the ASPState database to handle session state. If you're like me you probably upgrade when you have the chance.  If you're like my company you don't...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: