Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wangji
Starting Member
2 Posts |
 Posted - 2007-02-14 : 11:40:26
|
| We have a .Net application using ASPState database to store session state. Sometime, users complained about application very slow, and what we found was there were a lot of blocking happening in AspState database.To be more specific , here is the sysprocesses datawaitype waitresourcesLCK_M_U KEY: 9:85575343:1 (e1022ce16790)LCK_M_U KEY: 9:85575343:1 (e1022ce16790)LCK_M_U KEY: 9:85575343:1 (e1022ce16790)LCK_M_U KEY: 9:85575343:1 (e1022ce16790)LCK_M_U KEY: 9:85575343:1 (ab02212cf9a6)LCK_M_U KEY: 9:85575343:1 (e1022ce16790)85575343 is the objectid of ASPStateTempSessions tableIt looks like a lot of key range locks on the clusted index of sessionid column, when the sessions tried to update. When it happened, there were about 140 user connections. Disk array didn't show any contention(Altough it's a raid 5, I was worried about the write performance, but it doesn't show to be an issue). CPU was running at 15%(it's a 8-way system). Here are what I have tried to solve the problem1)Add an index to the Expires column 2)Configure DeleteExpiredSessions to run less frequent, from every 1 minite to every 2 minute. But it still show a lot of blocking. Any idea? |
|
|
astuemky
Starting Member
1 Post |
Posted - 2007-03-27 : 18:45:03
|
| We are experiencing this exact same problem; was wondering if you ever found a resolution for it? Thanks... |
 |
|
|
|
|
|
ASPState database contention