470,641 Members | 1,575 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,641 developers. It's quick & easy.

ASPState .net Session Sate performance issues on SQL Server

I don't know if I should post this here or in SQL Server, but thought I'd start here.

We have been using the default ASPState database that microsoft creates for session state tracking. Even though we sometimes only have 10-15 users connected, it is the highest source of database waits on our entire SQL Server. The waits are always on CPU and "LCK_M_U", whatever kind of lock that is.

I used to only delete expired sessions 1 x per week and there were 60k rows in the db. Since then, I have implemented various types of jobs to delete the expired sessions - they run every minute now, and there are only about 400 rows in the table. But the waits have not changed. Does anyone have any ideas about why there are so many waits on it or what is happening to it? The transaction logs have started growing so fast I have started to truncate them every 10 minutes just to make sure they don't take up the entire disk... and the DB is in SIMPLE recovery mode! Any ideas to try would be much appreciated.

Amy
Mar 27 '07 #1
2 4733
kenobewan
4,871 Expert 4TB
Welcome to the site. What version of the .net framework are you using? I assume that you have a web farm and are aware that using SQL will take 10-25% longer. Try adjusting the statenetworktimeout of the session state, but sounds like you have a bigger problem. Are your servers running at nearly 100%. Please provide more info about how you have set this up. Thanks.
Mar 28 '07 #2
very nice and precise article

http://sanjevsharma.blogspot.com/200...-database.html
May 14 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by sandy | last post: by
4 posts views Thread by Ram Stern | last post: by
5 posts views Thread by Abhilash.k.m | last post: by
4 posts views Thread by John Q. Smith | last post: by
1 post views Thread by marcfischman | last post: by
7 posts views Thread by Martien van Wanrooij | last post: by
1 post views Thread by Korara | last post: by
???
1 post views Thread by Stoney L | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.