Re: memory leak when quering from SQL server
From: Jon Skeet [C# MVP] (skeet_at_pobox.com)
Date: 07/25/04
- Next message: Spence: "Use of radio buttons"
- Previous message: Uzi Baruch: "memory leak when quering from SQL server"
- In reply to: Uzi Baruch: "memory leak when quering from SQL server"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 25 Jul 2004 20:19:35 +0100
Uzi Baruch <uzibaruch@hotmail.com> wrote:
> 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.
Are you calling Dispose on everything appropriate (DataReader,
SqlConnection etc)?
-- Jon Skeet - <skeet@pobox.com> http://www.pobox.com/~skeet If replying to the group, please do not mail me too
- Next message: Spence: "Use of radio buttons"
- Previous message: Uzi Baruch: "memory leak when quering from SQL server"
- In reply to: Uzi Baruch: "memory leak when quering from SQL server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
