worker process and sessions

what is relation between the two

[keds]

Hello ,

I am using Win2k3 server with IIS 6.0 and running ASP pages on my websites with Mysql database. I have co hosted websites on this IIS with different IP for each website and have created separate application pools for each website. At any given moment number of users on all websites together does not exceed 50.

Problem I am facing is worker process of one of the websites end up using lot of server resources and hangs the machine. First I thought of connections and recordsets which were opened in ASP pages and are not getting closed are causing this problem. I worked on it and now there are no such open objects.

Can you please advise me what could be possible reason for such behavior of worker process?

One more question that I have in my mind is one of these websites has users working on it for more than 4 hours , I mean their active session lasts for that much time or more. This website has lot of database activity and all rcordsets are set to "CursorLocation = aduseclient". Are longer sessions for this website causing such problems?

[korkus2000]

Sessions will chew on processes. If the site is using the session for variables and other things it can bog the server down. It is more of how many concurrent sessions are running than how long they are open.

[keds]

Thanks korkus2000 . At any given time there are not more than 50 concurrent users on my websites. Thats why I doubted about longer session. I have also mentioned about recordsets and the way I open it, reason being I am using mysql driver 3.51 and requires "CursorLocation = aduseclient" to handle paging.Are such kind of recordsets using session object?

[korkus2000]

Not sure about the SQL problem. How big are the data sets coming from the DB? Can you try and offload the sessions to a cookie?