0
votes
1answer
1k views

Diagnosing Blocking issues using Blocked Process report

I have an application that is going down as a result of timeouts. During these times we see a massive spike in response times from the database that holds ASP session state. In an effort to to ...
0
votes
2answers
419 views

How are DB locks tied to connections and sessions?

I've heard of page- and row-level locks, but never heard them used with regards to sessions and connections. Today, our (MySQL) DBA was talking about row locks and implied that their scope can be set ...
4
votes
1answer
3k views

ASPState database locking and growth problems

We use an ASPState database to persist .NET Session state on a SQL Server 2005 cluster. We are seeing some strange behavior during peak periods The DeleteExpiredSessions proc is run every minute ...
1
vote
0answers
262 views

Oracle locked sessions with ASP.Net

I am connecting to an Oracle database in ASP.Net using SQLDataSource. My connection string is: <add name="ConnectionString3" connectionString="Data Source=sml; User ID=sml; Password=sml; ...