473,320 Members | 1,707 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Run away SPIDs to ASPState database

We are running a ASP.NET 1.1 web app on Windows Server 2003 SP1. We are
using IIS 6.0 native mode and .NET 1.1 SP1 is installed.

We have 3 web apps in our web farm. We are using SQLServer session state
and have our machinekeys matched. We just launched a few days ago.

We did an iisreset this morning on all 3 and tonight when things settled
down I noticed we had 30 SPIDs still connected to the web apps. These SPIDs
were all connected to the ASPState database (around 10 SPIDs coming from
each webapp). The SPIDs connected to our main database had released from
the pool and only a few remained.

After doing some profiling, I noticed that the ASPState database was getting
hammered by calls to

declare @p2 varbinary(7000)
set @p2=NULL
declare @p3 bit
set @p3=1
declare @p4 int
set @p4=13520
declare @p5 int
set @p5=50
exec dbo.TempGetStateItemExclusive2
@id='4y4ren45clx5wpuwzwgz0r55b1e38631',@itemShort= @p2 output,@locked=@p3
output,@lockAge=@p4 output,@lockCookie=@p5 output
select @p2, @p3, @p4, @p5

I have read that this could happen with earlier versions of .NET if a
non-serializable object was attempted to be stored in session. However I
thought this problem of infinite looping was fixed and an error was
generated.

Anyone have this situation or know what's going on?
May 17 '06 #1
0 1159

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Tony | last post by:
We are a software company that builds an ASP.Net web application which implements cookieless sessionState with SQLServer- the session is stored in the url. Our ASPState database has been built...
0
by: Bryan Ax | last post by:
Quick question regarding best practices for using the AspState database for storing session variables in .NET web applications. I know I need to configure the web.config file with a database user...
2
by: Glenn Venzke | last post by:
I'm trying to put together a web form that lists all current session information. The session info is stored in SQL server database (ASPState) and I'm trying to retreive and display using a...
0
by: Eduardo Rosa | last post by:
Hi, I'm reading a ms tutorial about session in asp.net, and I' can't start the aspstate, somebody can help me? tutorial:...
0
by: david | last post by:
How to create the user for ASPSTATE? I got error: Exception Details: System.Data.SqlClient.SqlException: EXECUTE permission denied on object 'TempGetStateItemExclusive2', database 'ASPState', owner...
0
by: Tim Greenwood | last post by:
We just discovered that the "temp' database ASPState is in full recovery mode. Is this necessary? Seems ridiculously overkill seeing that when we reboot the sql server machine we really don't...
2
by: tcw | last post by:
We would like to use ASPState to handle the session State. Since we have several web applications (web sites) in our web server, do we have to create an ASPState database for each web application...
0
by: Kevin Jackson | last post by:
We are running a ASP.NET 1.1 web app on Windows Server 2003 SP1. We are using IIS 6.0 native mode and .NET 1.1 SP1 is installed. We have 3 web apps in our web farm. We are using SQLServer...
1
by: =?Utf-8?B?RWQ=?= | last post by:
I presently have an ASP.NET 2.0 application in production, that uses a state database "ASPState". I have another seperate application that has the same requirment. Is there any problem with...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.