Subject Re: Firebird 1.5 probably leaking memory
Author jstahl80
> Most likely the big chunks of memory are occupied by the Win
filesystem
> cache.

I thought, that file system cache is not counted as process memory
but shows up as system cache?

> Try using some tools from sysinternals.

Got Process Explorer from sysinternals. Here is what is says about
fbserver.exe, performance tab:

CPU:
Priority: 8
Kernel Time: 1:26:48.453
User Time: 4:26:39.390
Total Time: 5:53:27.843
Context: 1466

Virtual Memory:
Private Bytes: 1055100 K
Peak Private Bytes: 1058452 K
Virtual Size: 1183660 K
Page Faults: 153044878
Page Fault Delta: 394

Physical Memory:
Working Set: 110540 K
WS Private: 108248 K
WS Shareable: 2292 K
WS Shared: 924 K
Peak Working Set: 184800 K

I/O:
Reads: 2970023
Read Delta: 0
Read Bytes Delta: 0
Writes: 17284339
Write Delta: 28
Write Bytes Delta: 224.0 KB
Other: 313784735
Other Delta: 888
Other Bytes Delta: 24.3 KB

Handles:
Handles: 168
GDI Handles: 9
USER Handles: 3

The physical memory data is reasonable, the database cache is round
about 80 MB. But the total private bytes seam to be much too high.
SortMemBlockSize and SortMemUpperLimit are default.

If anyone has some tips what to check further, I will do. But please
before weekend. The database supports an industrial production
system, so I want to restart the server before weekend to avoid
raising trouble.

Thanks.
Jojakim