Application slows down

[mamin]

My application works under IIS 5.1 and is connected with oracle 9.2
database. After a few days of working it starts to work slower aned
slower. I've checked connections with database if they are closed but
in Enterprise Menager Console - Instance - Sessions all connections
are closed. I've noticed that process aspnet_wp.exe uses more and more
memory, maybe this is the reason? Killing this process results in
getting my application work faster. What should I do to prevent my
application from getting slower. (I want to avoid restarting
aspnet_wp.exe process).What can I check except for connections and
aspnet_wp.exe process. Maybe it's another way to check closed
connections...?

 

[Hans Olav]

Sounds like there are some IDisposable objects in your app that you're not
disposing.
All IDisposable objects needs to be freed by you, and isn't collected
properly from the GC. SqlConnection, SqlDataReader and so on are all
IDisposable, meaning that you should always call obj.Close() when you're
done using them.

Another great way is to use C# using {} mechanism:

using (SqlConnection con = new SqlConnection(...))
{
using (SqlDataReader = ....)
{
}
}

This way, the Close() method is automatically called for the objects inside
the using clause.

'Hans Olav.

 

[mamin]

I've checked all places where Connection and DataReader is being used
but everywhere they're being closed.

 

[mamin]

I noticed, that applications starts to slow down, after running it from
another computer.I mean that from computer A i can run application and
it works fine, then I'm running application from computer B and after
that on both computers, application runs very slowly. And even after
restarting Oracle database, it still runs slowly. The only way to make
it faster is killing aspnet_wp.exe.