Home > IT Blogs > SQL Server with Mr. Denny/

SQL Server with Mr. Denny:

IIS 7

1
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...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

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. ...

  Bookmark and Share     4 Comments     RSS Feed     Email a friend

October 15, 2009  7:06 AM

The polished turd that is Dell’s Gold Level Support department really isn’t all that supporting



Posted by: Denny Cherry
IIS 7, Windows 2008

If you follow me on twitter then you've heard bits and pieces of this already on my twitter stream. In preparation for the onslaught of security patches which were released on October 14, 2009 I went ahead and patched all our severs the...

  Bookmark and Share     5 Comments     RSS Feed     Email a friend

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...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

1