memory leak when quering from SQL server

  • Thread starter Thread starter Uzi Baruch
  • Start date Start date
U

Uzi Baruch

Hi



I have a query that gets binary info from the SQL Server.



The problem is that the query is very large and the process that performs it
consumes a lot of memory.



Actually it consumes the amount of memory as defined in the SQL Server
properties (memory tab).



The problem is even bigger, because the process does not release the
consumed memory and if I decrease it then i get a lot of page faults.





Any help would be appreciated



Uzi
 
Uzi Baruch said:
I have a query that gets binary info from the SQL Server.

The problem is that the query is very large and the process that performs it
consumes a lot of memory.

Actually it consumes the amount of memory as defined in the SQL Server
properties (memory tab).

The problem is even bigger, because the process does not release the
consumed memory and if I decrease it then i get a lot of page faults.
Click to expand...

Are you calling Dispose on everything appropriate (DataReader,
SqlConnection etc)?
 
Back
Top